Options
Getting started
pshros
Posts: 2
Hi,
I am new to Oracle, and have an application that uses the managed .NET provider (Oracle.ManagedDataAccess.dll v4.112.3.50). My connection string is User ID=student;Password=******;Data Source=***.***.***.**:****/ASYDB;Pooling=false;
I am trying to use Data Compare for Oracle but can get neither the TNS nor the Manual modes to connect. I get the following error below. Clearly I need to install or configure something. Any pointers?
Connection Initialization Error
Unable to connect to database ***.***.***.**(ASYDB):
Unable to load d:\app\Peter\product\11.2.0\client_1\oci.dll. Please check that you use 64x version of Oracle client with 64x application.
Please check you are using the correct architecture version of Data Compare, and that you are using a 9i client version or above.
If these problems persist, please enable direct connection mode in Application Options and retry.
OK
I am new to Oracle, and have an application that uses the managed .NET provider (Oracle.ManagedDataAccess.dll v4.112.3.50). My connection string is User ID=student;Password=******;Data Source=***.***.***.**:****/ASYDB;Pooling=false;
I am trying to use Data Compare for Oracle but can get neither the TNS nor the Manual modes to connect. I get the following error below. Clearly I need to install or configure something. Any pointers?
Connection Initialization Error
Unable to connect to database ***.***.***.**(ASYDB):
Unable to load d:\app\Peter\product\11.2.0\client_1\oci.dll. Please check that you use 64x version of Oracle client with 64x application.
Please check you are using the correct architecture version of Data Compare, and that you are using a 9i client version or above.
If these problems persist, please enable direct connection mode in Application Options and retry.
OK
Comments
It's possible you installed the 32-bit client on a 64-bit machine, which is fine, but requires you to use our "Data Compare for Oracle 2 (32-bit)" executable.
If not, then it would be good if you could try going to "Tools->Application Options..." in the menu, and checking the box for "Prefer direct connection". Restart the application and try again.
Let us know how you get on!
Michael Christofides
Product Manager - Oracle tools
Could you submit a support request and perhaps attach it as an image?
https://redgatesupport.zendesk.com/home
Many thanks,
Michael