May 3, 2010 at 2:42 pm
Environments:
1: Windows Server 2003 32-bit; MSSQLServer 2005 (both with all apppropriate SP's apppled); Oracle Client 10.2.0 32-bit
2: Windows Server 2003 64-bit; Oracle 10 64-bit
On machine where I am trying to create the linkserver, the tnsping and sqlplus are working without error. When I try the test connection to the linkserver, I get:
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The test connection to the linked server failed."
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "PSPRODDB".
OLE DB provider "MSDAORA" for linked server "PSPRODDB" returned message "ORA-12154: TNS:could not resolve the connect identifier specified
". (Microsoft SQL Server, Error: 7303)
------------------------------
I've been searching forums for days and things appeared to be configured properly (as far as I can tell). Any ideas or direction?
EXEC master.dbo.sp_addlinkedserver @server = N'PSPRODDB', @srvproduct=N'Oracle', @provider=N'MSDAORA', @datasrc=N'MSDAORA', @provstr=N'PSPRODDB'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'PSPRODDB',@useself=N'False',@locallogin=NULL,@rmtuser=N'ps',@rmtpassword='########'
May 3, 2010 at 2:44 pm
Sorry. Wrong forum ...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply