May 3, 2007 at 11:21 am
So, I have a SQL2000 and a SQL2005 box that are as identically configured as you can get. I have the Oracle8i client installed and configured on both servers. The sqlnet.ora and
tnsnames.ora files are identical. Both 2000 and 2005 can connect to the external Oracle8i database through the SQLPlus program that comes with Oracle. However as far as linked servers go, only the 2000 box can connect to Oracle. The 2005 server just returns the following message when I try to query through a linked server:
OLE DB provider "MSDASQL" for linked server " * DBNAME HERE* " returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
If it matters, I am using the following syntax through both SQL Servers:
select * from openquery(*DBNAME*, 'select * from ....')
Any ideas? Thank you very much!
May 10, 2007 at 7:01 am
Anyone?
OLE DB provider "MSDASQL" for linked server "SERVERNAME" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SERVERNAME".
May 10, 2007 at 10:22 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply