Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-11-13
4
Medium Priority
?
3,258 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 1000 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

704 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