Link to home
Start Free TrialLog in
Avatar of Rads R
Rads RFlag for United States of America

asked on

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

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

ASKER CERTIFIED SOLUTION
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial