Unanswered: Error when passing date values via ADO Recordset.Open method
The following works in the US locale, but not UK locale(2057).
Recordset.Open "sp_GetEvent '" & strDate & "'
The following error is generated:
"Error converting data type varchar to datetime"
I have to use Recordset.Open due to specified cursor type. I know I can set the active connection, command text and parameters etc... in a command object and have the recordset open the command object, but due to time constraints, this might be too costly.
Am I doing something wrong? What am I missing? Is there a quick fix?
Remember... this is NOT problem in the US. I'm having the problem when changing the regional settings from US to UK.
What is the format of the date that is being passed ? Also, are you converting the date ? You can do the following with the stored procedure - convert(datetime,'31-12-1999 15:00',103) - The 103 is for British/French date formats.