Rads R
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.
-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;"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.