May 15, 2008 at 3:57 am
Hi,
I am trying to connect to an ORACLE instance from SQL Server, without installing ORACLE Client on the SQL server box itself ?
I'm afraid that I do not have much depth in ORACLE, but believe that the TNS entries won't have much relevance without installing ORACLE Client, and all the scripts I have tried had a reference to the TNS names.
A line of guidence (and sample connection script) will be greatly appreciated.
Regards
May 15, 2008 at 12:35 pm
Whenever I have made a connection to Oracle through SQL Server I have installed the Oracle client on the SQL server box.
I'm not sure you can connect to Oracle without having the client installed. Why don't you want to install it?
May 16, 2008 at 1:25 am
Thanks for responding...... our production (SQL) Sever (with no ORACLE Client installed) is maintained by another party, and sadly they are not in favour of disturb the current installations.....
Might be possible in the long run.....but we want the data very urgently.
Regards.
May 16, 2008 at 1:35 am
If you don't want to install the Oracle client on the SQL Server in question then you might find another computer running SQL Server on which you can install the Oracle client and a link. Then you link to that second SQL Server instance and its link to Oracle.
Haven't got a clue if this works (link to a link). But it's a cute idea.
May 16, 2008 at 2:09 am
Thanks for the suggestion.........this one sounds pretty good.
Regards
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply