I have a problem that I think is ODBC related.

I have used Linked Servers in MS SQL Server 2000 to link an SQL Server to an AS400 using the AS400 Client Access ODBC driver. The liked servers work fine and I have been transferring data between them for some time.

However recently we changed the length of one of the columns in one of the AS400 files from 10 characters to 20 characters and the data transfer fell over when it tried to delete data from the AS400 file. Everything works fine again if we change it back to 10 characters.

I have investigated a number of theories and can only think that the ODBC driver is somehow caching or remembering the file structure and failing when the actual structure does not match what it is expecting.

Does anyone have any ideas on how to fix this problem (we do need to change the column size so leaving it at 10 characters is not an option) or any better theories?

Any help would be greatly appreciated.

Regards, Trog28.