Oracle 10g R1 linked server

Oracle 10g R1 linked server


I am testing the integration of Orecale entities in a sql server based installation. I have successfully created the linked server, but when trying to import the entities with the integration studio, the attached error occurs.

I have tried several approaches (even the registry keys modification), but none of them was successfull (and the error message unfortunately isn't clear). Has anyone experienced this before? Is 10g supported?

Service Center version:
Integration Studio:

Thanks in advance

João Gomes
Hi João

DB Link Servers over databases other then SQL Server are not fully supported by Integration Studio. This may generated the type of errors like the one you've reported, during the database/tables introspection.

Have you tried to define a SQL view that maps the respective table(s) over the DB Linked Oracle server and import that view instead of directly the Oracle tables?


Miguel João