VB6 application
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?