ADO Connection Error

[MattG]

Can anyone give me an idea why this isn't working?

strMDBpath = "dmiscal.mdb"
oConn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & strMDBPath


the error is:

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.



Thanks!



Matt

[Bob Barrows]

MattG wrote:

> Can anyone give me an idea why this isn't working?
>
> strMDBpath = "dmiscal.mdb"
> oConn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
> strMDBPath

It's got nothing to do with your error, but you should use the native Jet
OLEDB provider instead of the obsolete ODBC driver:

oConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
strMDBPath

>
>
> the error is:
>
> 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.
>

I suspect the error is not being caused by this line of code. You must have
a later line of code that uses one of the ADO constants (asOpenStatic,
adUseClient, etc.) and you have failed to include the definitions of those
constants in your page. The best way to do this is described here:
[url]http://www.aspfaq.com/show.asp?id=2112[/url]

--
HTH,
Bob Barrows - Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Tom Kaminski [MVP]]

"MattG" <remove.msg@standardpub.com> wrote in message
news:uNwPceLlDHA.2328@TK2MSFTNGP10.phx.gbl...

> Can anyone give me an idea why this isn't working?
>
> strMDBpath = "dmiscal.mdb"
> oConn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & strMDBPath
>
>
> the error is:
>
> 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.

[url]http://www.aspfaq.com/show.asp?id=2102[/url]

--
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]

[Aaron Bertrand - MVP]

"MattG" <remove.msg@standardpub.com> wrote in message
news:uNwPceLlDHA.2328@TK2MSFTNGP10.phx.gbl...

> Can anyone give me an idea why this isn't working?
>
> strMDBpath = "dmiscal.mdb"
> oConn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & strMDBPath

You need to provide a proper path. If dmiscal.mdb is in the same folder as
the ASP page, you can say:

cst = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & server.mappath("dmiscal.mdb")
oConn.open cst

> 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.

I'm guessing you will still get this error message, but it's probably
happening on a different line...