Error - ODBC driver does not support the requested properties.

I am taking my first crack at writing some ASP and have no clue as to what this error is pertaining to. If anyone can help me out, I will be in your perverbial debt for ever!

--------------------------------------------------------------------------------

The error I am getting is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/agentlookup.asp, line 8


-----------------------------------------------------------------------------


And here is the code it is referencing:

<%' Open the connection
set rs= server.createobject("adodb.recordset")

set con= server.createobject("adodb.connection")

con.open"cham33.champion"
usn=request.form("zipcode")
rs.open"select * from zips where zipcode='"&Usn&"'",con,1,1


' now we are going to perform IF block
If Rs.EOF Then
Session("Authenticated") = 0
Response.Redirect ("notfound.asp")
Else
while not rs.eof
response.write rs("Name")
response.write rs("address")
response.write rs("Zip")
response.write rs("Phone")
response.write rs("email")
rs.movenext
wend
end if

rs.close
con.close
%>

--------------------------------------------------------

Any suggestions are welcome and appreciated

thanks

Try

rs.open "select * from zips where zipcode='" & Usn & "'", con, 1, 1