Hi everyone!

I am having the issue with date field while accessing VFP table from ASP (thru VBScript). The following statement

SELECT * FROM tblAbc WHERE trans_date => ‘11/21/2006’ AND trans_date <= ‘11/27/2006’

returning an error

“ODBC driver does not support the requested properties”

Connection to the table:
------------------------------------
set cn = Server.CreateObject("ADODB.Connection")
cDatabasePath = Server.MapPath("/DATA")
connstr = "Driver={Microsoft Visual FoxPro Driver}; UID=;SourceDB="&cDatabasePath&";SourceType=DBF;"
cn.Open connstr

adOpenStatic = 3
Set rs = CreateObject("ADODB.Recordset")
------------------------------------

I would appreciate any input