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

Posted on 2009-02-11
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

    I haven't seen this with Oracle, but maybe NULLS or an empty string?

    check your connection string:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now