Thanks jo,

I am working on your View option. I think that's the very good idea. coz after doing all this i m just wasting my time neither i resolved that...

You know what i did.. i tried to link with Oracle provider and trying to join all the server. let's see i m going right way or not.

If you have...

Yes i think u r right.

So do u have any other solution to do same thing? View is not reliable option as i have so many tables in the system....

hey first of all can you please let me know physically and logically is it possible to connect Oracle server to sql server via another sql server ?

I'll try to answer this on Tuesday.

Does a basic query works?

It could be that distributed transactions ain't configured correctly.

(Are the server machines windows 2003?)

*spGetNewExhibitJSubContractorsDetails is located on the external system...

Hey Jo,

Thanks for your support.

I read that article.I tried to connect with DTS but not able to connect with DTS also. I dont know why?

See below is original scenario:

In...

1)Can Internal System fetch data from the Oracle 10g?

2)External System can fetch non-oracle data from Internal Sytem?

If both are true, there is likely a security-issue/login mismatch.

Any clue if the external...