Using 2 databases and 2 connection strings  but getting error when connecting to Oracle

Posted on 2009-02-11
Medium Priority
Last Modified: 2012-05-06
I have 2 connection strings one for Sql Server till now it is connecting perfectly with Sql Server but as the application needed more validations I had to connect to Oracle DB . The error I am getting now is this :
-2147217887: Multiple-step OLE DB operation generated errors. check each OLE Db status value, if available. No work was done.
I thought this error may also be raised when there is a datatype issue but the datatype and sizes are perfect.
Anyone's help would be greatly appreciated.
Thanks for your time.

I have checked some web sites and came to know that it might be the connection string issue 
and these are connection string parameters I have tried each of them but to no avail 
Global Const E1_CONN_STRING = "Provider = msdaora;Data Source = s123;initial catalog = D01;User id=xxxxx;password=xxxxxx"
Global Const E1_CONN_STRING = "Provider = msdaora;Data Source = S123;Persist Security Info=False;Integrated Security=Yes;initial catalog = D01;User id=xxxxx;password=xxxxx"
Global Const E1_CONN_STRING = "Provider=OraOLEDB.Oracle;Data Source=s123;initial catalog=D01; User id=xxxxx;password=xxxxx;"

Open in new window

Question by:Radhs74
1 Comment
LVL 17

Accepted Solution

dbaSQL earned 1000 total points
ID: 23618325
I haven't seen this with Oracle, but maybe NULLS or an empty string?

check your connection string:

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

839 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