By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

ADODB.Connection error '800a0bb9'

P: n/a
I have an application that we are moving to a 2003 server using IIS6.
Currently, it works fine with IIS5 on a NT server. When I try to log
into the application and connect to an Oracle DB, I get the following
error:
ADODB.Connection error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

Here is the code that is causing the error. The line where the error is
occuring is 'objDBConn.cursorlocation=adUseClient'
Sub OpenDB

strDBAction = "Open Database"

Set objDBConn = Server.CreateObject("ADODB.Connection")

objDBConn.cursorlocation=adUseClient
objDBConn.Open Application("DB_CONNECTION_STRING")

If err.Number <> 0 OR objDBConn.Errors.Count <> 0 Then
Call ErrHandler
End If

End Sub

Any ideas anyone would have to help fix the problem would be greatly
appreciated. Thank you very much.

Mike

Oct 25 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Do you have adUseClient defined anywhere?

Ray at work

<wo***********@yahoo.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
I have an application that we are moving to a 2003 server using IIS6.
Currently, it works fine with IIS5 on a NT server. When I try to log
into the application and connect to an Oracle DB, I get the following
error:
ADODB.Connection error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

Here is the code that is causing the error. The line where the error is
occuring is 'objDBConn.cursorlocation=adUseClient'
Sub OpenDB

strDBAction = "Open Database"

Set objDBConn = Server.CreateObject("ADODB.Connection")

objDBConn.cursorlocation=adUseClient
objDBConn.Open Application("DB_CONNECTION_STRING")

If err.Number <> 0 OR objDBConn.Errors.Count <> 0 Then
Call ErrHandler
End If

End Sub

Any ideas anyone would have to help fix the problem would be greatly
appreciated. Thank you very much.

Mike

Oct 25 '05 #2

P: n/a
http://www.aspfaq.com/search.asp?q=800a0bb9&x=9&y=10

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

*** Sent via Developersdex http://www.developersdex.com ***
Oct 25 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.