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