( This is an edit...the real post was really big )
I'm having problem with my SQL Server 2008 to DB2 linked server.
I'm getting this error:
TITLE: Microsoft SQL Server Management Studio
The linked server has been created but failed a connection test. Do you want to keep the linked server?
ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch.
Cannot initialize the data source object of OLE DB provider "DB2OLEDB" for linked server "DB2LINKEDSERVER". OLE DB provider "DB2OLEDB" for linked server "DB2LINKEDSERVER" returned message "". (Microsoft SQL Server, Error: 7303)
When click "connect" on DSN:
Error in SQL Server Management Studio: