SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error 7302 connecting to Linked server db2oledb
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rimsky
Starting Member

Netherlands
12 Posts

Posted - 09/20/2012 :  04:47:53  Show Profile  Reply with Quote
Hi all,
I have a puzzeling problem. I can't get a successful connection to a AS400 DB2 database.
Here's the setup:
SQL2005 SP4 in VMWARE W2K3 sp3. Connection setup, tested and ok.
SQL2005 SP4 Instance3 in Active Cluster W2K3 SP3. Connection setup, tested and ok.
SQL2005 SP4 Instance2 in Active Cluster W2K3 SP3. Connection setup, tested and ok.

SQL2005 SP4 Instance1 in Active Cluster W2K3 SP3. Connection setup, tested and failed.

On each of the sql servers I installed db2oledb from the same source successfully. On each server I can connect using the Data Access Tool.

Only on Instance1 I get a connection error. I have unset and set the AllowInProcess option to no avail.

Any ideas to get this working?
Since the Linked Server is working on other (identical) servers, I can get to the data, but not from Instance1. Don't think I can do a [link-server].[linked-server] connection?


Here's the connection error:



===================================

"The test connection to the linked server failed."

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd)
   at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LinkedServerConnectionTest.Invoke()

===================================

Cannot create an instance of OLE DB provider "DB2OLEDB" for linked server "ENIACDB2". (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476

------------------------------
Server Name: TECHCYB1-SQL01\TECH01
Error Number: 7302
Severity: 16
State: 1
Procedure: sp_testlinkedserver
Line Number: 1


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000