Solved

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

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
error in oracle form 11 53
Automate an Oracle update in Excel 7 70
Creating a View from a CTE 15 49
SQL query to retrieve alphabetical characters only from nvarchar string 16 54
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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…
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…

752 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