>Here again is the code I use to access foxpro 2.6 data from visual interdev:
>
>< %
>datethen=date()-6
>datenow=date()
>qry = "select * from kdata where k_date >= '" & datethen & " and"
>qry = qry & " k_date <= '" & datenow & "'"
>
>set rs1 = server.createobject("ADODB.Recordset")
>open.rs1 qry, "DSN=foxcon"
>
>while not rs1.eof
>response.write rs1.name & " " rs1.k_date
>wend
>% >
>
>
>I think the mistake is in the field k_date since k_date is a foxpro 2.6 date datatype. I tried using curly braces - it did not work.
>
>Also, I set the foxcon DSN at the system DSN in ODBC Data Sources in Control Panel. I don't think the problem is here since the query works well when I leave out the k_date condition.
>
>Can somebody help me fix my code?
>
>
>Ramon Carlos
Try this as your while loop:
while not rs1.eof
response.write rs1("name") & " " & rs1("k_date")
wend
As well, I would recommend you try to use OLEDB instead of ODBC if possible. We've had problems with ODBC on our IIS server (it would crash for no apparent reason) and we were informed by Microsoft that the ODBC was causing the problems, and that we should move to exclussively ODBC. So much for backward and o-compatible technologies!
Hugo
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith