Toad World® Forums

Heterogeneous Connection Error - Oracle and SQLServer


I am using the Query builder to create a simple join of an Oracle table and a SQLServer table. However, when I execute the query it gives the following error:

Cross Query Database Error: Invalid data source definition: Invalid connection.;ConnectionOpen (Invalid Instance()).

My connections to these Database are working fine on their own, but have a problem with Cross Connection queries.

How can I fix this issue?



Any tips on what to do here???

To Tony:

Thank you for posting in Toad World.

I am currently responding on the other, newer, thread. I’m hoping we can come to a solution there.…/53104.aspx

Software Developer I,

-Joshua Liong