Getting started

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Getting started

Postby pshros » Wed Mar 27, 2013 12:34 pm


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.
Posts: 1
Joined: Wed Mar 27, 2013 12:29 pm

Postby Michael Christofides » Thu Mar 28, 2013 5:10 pm


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
Michael Christofides
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests