ADODB.Recordset error '800a0bb9'... Arguments in conflict? 2

[fsteeman]

Hello all,

Could anyone help me I am stuck with this very annoying problem, whereas I am doing everything by the book!

When I access my asp-page I get the following error message:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/evolution/default1.asp, line 49


This is my original code:

dim db, rs, rsegm, strConn, sql

Set db = Server.CreateObject ("ADODB.Connection")
DBP = "f:\

http://www\steeman\db\evolution.mdb;"

strConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & DBP

db.ConnectionTimeout = 30
db.CommandTimeout = 80
db.open strconn

set rsegm = Server.CreateObject ("ADODB.Recordset")
rsegm.Open "SELECT * FROM segments", db, adOpenForwardOnly, adLockOptimistic

As a test I also copied a similar procedure from a tutorial and tried that: same result...

I also tried the page on a totally different server: no difference...

Could someone please tell me what is wrong?!

Cheers,

Fedor

 

[newmediaguy]

Hi Fedor

Can you post the SQL string please

Thanks



Glen
Conception | Execution

 

[ChrisHirst]

is the adovbs file specified as an include?



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

 

[newmediaguy]

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=160

Have a look at this, found it on google by pasting your error.

Thanks





Glen
Conception | Execution

 

[newmediaguy]

all so i would recommend adding the

<%Option Explicit%>

that should help trap any errors and point you too a reason

thanks


Glen
Conception | Execution

 

[FesterSXS]

where is line 49? Where is the rest of your code?


Tony

http://www.SpiraxSarco.com

 

[fsteeman]

Dear all,

The problem was that I did not include the adovbs file. I never realized it was that necessary (believed that the server readily could understand what adOpenKeySet is) until now. Well, so you learn... Thanks for all the tips!

Cheers,

Fedor