Re: [cobalt-users] ASP database connectivity

["Sqlcoders.com Programming Dept" <coders@xxxxxxxxxxxxx>]

The error message should say the error is on line xxx.
>From the top of your asp file go down xxx lines, and then post what the text
of line xxx is, along with the 4 lines above and below it.
Almost definitely the problem is in the way you've written your SQL
query(SQL = "SELECT voornaam FROM adressen ORDER BY voornaam") although the
error will point to the next line because that's where the statement is
executed.
try removing the "ORDER BY firstname" part and see if that helps, if not
post the lines that the error message mentions, as described at the top of
this email and I may be able to help more(been a while since I worked in
dBase, but OBBC should let any normal query work)

Regards,
Dw


----- Original Message -----
From: "Hedwyg van den Elzen" <hedwyg@xxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Monday, October 29, 2001 6:04 AM
Subject: [cobalt-users] ASP database connectivity


> 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
>
>
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>