Wednesday, March 7, 2012

AS/400 DB2 and SQL Server..

Hi Guys,
We are using Linked server to access DB2 on AS/400 from SQL Server. Well, things are fine when we test with SELECT statement. When we use update etc... a strange error comes up. Cannot open File 'C:\Program Files\DataDirect\ODBC41\Drivers\.'. Well, on the first time I did an update it seemed like it worked. But I had given the wrong Criteria so nothing got updated. But going forward, I am always getting this error. Can somebody please help me.
Thanks in advance
AshokIt is ok now guys. It turned out we had not set up the journal properly on the AS/400. It works great now.

No comments:

Post a Comment