Red Gate forums :: View topic - Getting started
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Data Compare for Oracle
Data Compare for Oracle forum

Getting started

Search in Data Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
pshros



Joined: 27 Mar 2013
Posts: 1

PostPosted: Wed Mar 27, 2013 12:34 pm    Post subject: Getting started Reply with quote

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
---------------------------
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 87
Location: Red Gate Software

PostPosted: Thu Mar 28, 2013 5:10 pm    Post subject: Reply with quote

Hi,

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group