Solved

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

Posted on 2003-11-13
4
3,236 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Database tuning – How to start and what to tune. This question is frequently asked by many people, both online and offline. There is no hard and fast rule-of-thumb for performance tuning, however, before beginning the tuning process one should a…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now