I am accessing Foxpro 2.6 tables using the VFP Odbc Driver
I am trying to use SET DATE in ASP in the following way:

SET objConn = Server.CreateObject("adodb.connection")
strConnection = "DSN=ERSData"
objConn.Open strConnection
strCommand = "SET DATE BRITISH"
objConn.execute(strCommand)

IIS returns:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Visual FoxPro Driver]Syntax error or access violation

I can use other set commands such as SET EXCLUSIVE and they work. Why does SET DATE not work over the VFP ODBC driver?

Anyone have any ideas?

Thanks in advance

George