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 |
|
ryanthk
Starting Member
2 Posts |
 Posted - 2004-06-23 : 04:06:12
|
| Hi guys,Need some help here.Is there a compatibility issue between IBM OLE DB Provider and Windows Server 2003?I seem to have problems running DTS using the IBM OLE DB Provider, which always results in the following error :CLI0119E Unexpected System Failure. SQLSTATE=58004This only happens when I select the transactions in workflow properties, ie: Join transactions when present.Not much information is provided in the DB2 nor SQL server log files.The problem don't seem to occur in Windows 2000 Server, as it runs fine.Help urgently required. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-23 : 14:38:40
|
| You will need to contact IBM to find out if their driver is compatible with Windows Server 2003.Tara |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2004-06-24 : 20:19:37
|
| I'd bet that DB2 is not configured to participate in a distributed transaction. Is it running on an AS/400? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-25 : 03:49:44
|
| call 1-800-IBM-SERV-ec |
|
|
|
ryanthk
Starting Member
2 Posts |
Posted - 2004-06-26 : 04:08:43
|
| Nopes... The DB2 is running in another windows machine...Currently the configuration is like this..SQL SERVER -> DTS -> IBM DB2(Win2K3) (WIN2K)Any ideas/suggestions? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-28 : 12:24:19
|
| So IBM's driver supports Windows 2003? That is something that you need to find out from IBM. IBM probably has an updated driver that you need to install on the database server.Tara |
|
|
|
|
|
|
IBM OLE DB Provider and Win 2k3 Server