Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-06-06 : 03:35:26
|
| Hi,We have a DB2 server which is linked to our SQL Server 2005 database. The link is through ODBC connection. Now, we are able to access some of the tables without any problems. But couple of tables are not accessible and we get following error::""com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL1822N Unexpected error code "08S01" received from data source "TESTPROD". Associated text and tokens are "Communication link failure". SQLSTATE=560BD "Any ideas on why this is happening and how to resolve this?Thanks,Ujjaval |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-06 : 10:09:14
|
| Maybe db2 odbc issue, checked with IBM? |
 |
|
|
ujjaval
Posting Yak Master
108 Posts |
Posted - 2007-06-07 : 11:12:15
|
| yeah DB2 is fine because our server is already communicating with other SQL Server. We just can't figure out why its not communicating with this SQL Server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 00:58:34
|
| Checked mdac version on it? |
|
|
|
|
|
|
DB2 connectivity with SQL Server