Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mgarrettDev
Starting Member
1 Post |
 Posted - 2007-09-07 : 21:11:39
|
| Hello,I have a problem which I have spent the whole day trying to resolve but with little success...Here is the situation:I installed the Oracle Client 9.x.x on to my production MS Windows 2003 Server running MS SQL Server 2005 Enterprise (I need to make a Linked Server connnection to an Oracle database). The problem is if I try to create the Linked Server, I get an "Oracle Client software not installed. You must have the Oracle Client software installed to create connection" message from SQL Server. This is frustrating because the software is installed and I am able to make queries through SQL*Plus to the Oracle Database...Here is my checklist ---1) the PATH variable on the Windows Server is set correctly to the proper ORACLE HOME directory (with proper /bin directories set as well)2) I have an updated MDAC component installed3) registry configuration are correct for Oracle 9i4) created test Linked Server connections to various datasources (not Oracle) I am assuming the tsnames.org file is set up correctly or I would be able to make queries from SQL*PLUS, is this assumption correct?I am at a lost as to what to try next...Any information would be greatly appreciated,Thank you,mgarrettDev |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-07 : 23:17:18
|
| Tried create odbc dsn to oracle then create linked server with ole db provider for odbc driver? |
 |
|
|
|
|
|
Linked Server Problem to Oracle