Hello folks,
I have a linked server from SQL server to DB2...But today when i test the connection it fails giving the following error message....
"The test connection to the linked server failed."
Addition Information:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SQLServer.ConnectionInfo)
Cannot create an instance of OLE DB provider "DB2OLEDB" for linked server "name of the server) (Microsoft SQL Server, Error: 7302)
Can anyone help me in this issue
Regards,
Pradeep