How can we help you today? How can we help you today?

No schemas retrieved for comparison

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
jcossio
0

Comments

4 comments

Sort by
  • 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
    Simon C
    0
  • Alice E
    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/vi ... hp?t=10147
    Alice E
    0
  • 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
    jcossio
    0
  • Alice E
    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.
    Alice E
    0

Add comment

Please sign in to leave a comment.