>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

You better use parameters:

strSelect = "SELECT * FROM tblAbc WHERE trans_date between ? AND ?"

set cmd = CREATEOBJECT("ADODB.Command")
cmd.CommandType = 1
set pStart = cmd.CreateParameter("start",adDate)
set pEnd = cmd.CreateParameter("end",adDate)
pStart.Value = #...#
pEnd.Value = #...#
cmd.Parameters.Append( pStart )
cmd.Parameters.Append( pEnd )
cmd.ActiveConnection = con
set oRS = cmd.Execute()

Cetin