RE: Linked Server and remote TNSNAMES

2003-07-30 Thread Goulet, Dick
Jay, No, it's a MicroSlop thing. IIS & MTS have the same problem. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 30, 2003 12:00 PM To: Multiple recipients of list ORACLE-L We have a SQL Server database that needs to link to an Or

Linked Server and remote TNSNAMES

2003-07-30 Thread Jay Hostetter
We have a SQL Server database that needs to link to an Oracle database. I have been able to successfully setup this "linked server" entry in SQL Server, but only when I am using a local TNSNAMES.ORA. We typically have all of our Win2000 machines point to a central TNSNAMES.ORA file that is on