ADODB.Command error '800a0bb9'

[JoNRTW]

Hi,

I was wondering if I could ask for your assistance.

I have a script (not written by me) which I am trying to get working.

It's a script that handles a login. When logging in I get:

ADODB.Command error '800a0bb9'

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

default.asp, line 27

I've read a few help threads but none of which are helping unfortunately.

Basically, the line it refers to is either:

Line 27 of the file:

    MM_rsUser_cmd.ActiveConnection = MM_templenews_STRING

Line 32 of the file: 

    Set MM_rsUser = MM_rsUser_cmd.Execute

I am providing two lines, as the file has some HTML in it before the ASP starts (5 lines) so not sure which specific line the error refers to.
Any help would be greatly appreciated

Thanks in advance,

Jon

[burnme]

The error is referring to the first chunk of code you gave reffing the line 27. You can tell because it is attempting to set the MM_rsUser_cmd, which is attempting to connect to a database. SO, whatever you are passing in the MM_templenews_STRING is in wrong and needs to be fixed. If you want more help I need more code.

[JoNRTW]

Hi,

Many thanks for the reply

The connection string is included in another file. The string is:

MM_templenews_STRING "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../../private/temple-news.mdb;"

Before that, in the included connection file, we have:

' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_templenews_STRING
'MM_templenews_STRING = "dsn=templenews;"

Thanks again

Jon

[JoNRTW]

BUMP.

Can anybody offer any assistance with this please?

[yamaharuss]

Your connection variable is missing the equal sign.