Unanswered: Error when passing date values via ADO Recordset.Open method
SQL Server DB
Trying to run the following example:
"Recordset.Open "sp_GetEvent'" & strDate & "'
This works fine for US locale, but does NOT for UK locale(2057)
"Error converting data type varchar to datetime"
I could use the command object and pass values in as parameters, but I need a forward only cursor.
My only solution seems to be to set the active connection, parameters and command text via a ADO command object and have the Recorset open the command object.... but.... it's so late in the game, there is TOO much code to change.
I guess what I'm asking is.... Am I missing something? Should this work? What is a quick fix?