Here is the updated code (still does not work):

< %
Date_From = "09/01/1999"

db_qry = "select * from kdata"
db_qry = db_qry & " where k_date >='" & Date_From & "'"
response.write db_qry
set rs = server.createobject("ADODB.Recordset")
rs.Open db_qry , "DSN=foxprocon"

while not rs.EOF
response.write rs("kp_date") & " " & rs("model") & "
"
rs.MoveNext
wend

% >

this outputs the ff. in the browser:

select from kdata where k_date >='09/01/1999'

That's it. It does not enter the while..wend loop and i'm puzzled since the foxpro database is not empty. I checked it and it has a large amount of data.

Again, thanks for the help :)