Solved

Need help deciphering ASP/ADO/OLEDB error message '800a0e7d'

Posted on 2003-11-13
4
3,249 Views
Last Modified: 2007-12-19
I get the following error message:

---------------------------------------------------
ADODB.Command error '800a0e7d'
Requested operation requires an OLE DB Session object, which is not supported by the current provider.
---------------------------------------------------

Here's the context:

1) I Set the variable cn = a new connection object "ADODB.Connection"

2) I open (cn.Open) the connection with "Provider=MSDAORA.1" & other_data

3) I Set the variable cmd to a new command object "ADODB.Command"

4) The error message happens here: I set the cmd.ActiveConnection = cn.

One funny thing:  No matter at what stage I check the value of cn.Provider, it is always equal to "MSDASQL", not "MSDAORA" as expected.  Could this be a hint about the problem?
0
Comment
Question by:tamills
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
wsteegmans earned 250 total points
ID: 9740484
Can you give the complete ConnectionString (without username and password ;-))

Normally, it indeed should work like this
connStr = "Provider=MSDAORA.1;User ID=<userid>;" & _
               "Password=<password>;Data Source=<server>.<dbname>;"

If that doesn't work, download the Oracle OLEDB provider and use this connection string:
connStr = "Provider=OraOLEDB.Oracle;User ID=<userid>;" & _
               "Password=<password>;Server=<server>;Data Source=<dbname>;"

Some other connectionstrings that should work:

ConnectString ="Data Source=DBName;Provider=OraOLEDB.Oracle;User ID=userid;Password=pwd;PLSQLSet=1"
ConnectString ="DSN=ORACLE;DRIVER={Microsoft ODBC for Oracle};User ID=userid;Password=pwd;"
ConnectString ="DSN=ORACLE;DRIVER={Oracle ODBC Driver};User ID=userid;Password=pwd;"
ConnectString ="DSN=oracle;Provider=MSDASQL;UID=userid;PWD=pwd;"
ConnectString ="Provider=MSDAORA;Data Source=DBName;User ID=userid;Password=pwd;"

Is your connection really open (check status)?

Can you open a recordset based on this connection?
0
 

Author Comment

by:tamills
ID: 9741768
My connection string is:
Provider=MSDAORA;Data Source=some.machine.com;USER ID=someid;PASSWORD=somepwd

I'll look into the other questions and get back.
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9791609
Could you experiment with the different connectionstrings?
Need additional info?
0
 

Author Comment

by:tamills
ID: 9811291
ACCEPTANCE COMMENT

Everything was correct but the question from wsteegmans "Is your connection really open?" made me go back and check the basics at a detailed level.  The connection really was working.  But I had been givin some bogus information on several levels from colleagues (wrong connection was a working connection, but didn't contain the right data).

Thanks
0

Featured Post

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question