No schemas retrieved for comparison

[jcossio]

After I put my servers details via manual connection, the schemas to compare dropdowns do not populate even after a refresh list is issued. I type the schemas manually and hit compare no button and then I get the following error:

Could not load file or assembly 'Oracle.DataAccess, version=2.111.6.0, culture=neutral,...

etc.

Do I need to install something else? how.

Thanks

George

[Simon C]

It looks like you haven't installed the ODP.NET assemblies that the program requires. You can have a look here for the required client install settings; you'll need to re-run the oracle client installer and install over the top of your existing install.

SimonC

[alice.easey]

The latest build should allow you to connect without requiring the ODP.NET assemblies.

More info and download link here:
http://www.red-gate.com/messageboard/viewtopic.php?t=10147

[jcossio]

Thanks Alice. I was struggling to download the 487MB oracle client suggested by Simon (thanks Simon anyway). I downloaded the latest release of SC and now the schemas to compare retrieve information. But when I tell it to compare the following error comes up (after a while on "Registering database one" Populating PL/SQL text objects):

ORA-00904: "P"."OBJECT_TYPE": Invalid Identifier

And then aborts the process.

Thanks

George

[alice.easey]

Hi George,

Thanks for trying out the latest version - I'm glad it's helped with the client issues.

It sounds like there's a malformed query somewhere. Is it possible for you to set up tracing so that it'll log the query on the server? Hopefully that'll help track down what's going on.

We're currently adding logging to the next build, which will make this process a bit easier.

Alice.