[cobalt-users] ASP database connectivity

["Hedwyg van den Elzen" <hedwyg@xxxxxxxxxxxx>]

Hi,

I have a .dbf database on a cobalt-server with ASP (ChiliSoft).
I got this error message:

ADODB.Connection.1 error '800a0bb9'

The application is using arguments that are of the wrong type, are out
of acceptable range, or are in conflict with one another.

My code is:

<%
connectionstring = "DRIVER={Microsoft dBase Driver (*.dbf)};DBQ=" &
Server.MapPath("adressen.dbf")
Set db = Server.CreateObject("ADODB.connection")
db.Open connectionstring
sql = "SELECT voornaam FROM adressen ORDER BY voornaam"
Set rs = db.Execute("sql")
Do While NOT rs.EOF
Response.Write rs("voornaam")
Response.Write "<br>"
rs.MoveNext
Loop
db.Close
%>

What's wrong?

Best regards,
Hedwyg van den Elzen
The Netherlands