04-23-2002, 10:40 AM
ODBC drivers created on my machine, after upgrading to Client Access Express V5R1, are invalid. We use ODBC drivers to link AS/400 files to Microsoft Access databases. When I link an AS/400 file using the ODBC driver created with CA Express V4R5, it links properly and I can open the file successfully. When I link and then try to open a file using the newer ODBC driver created with CA Express V5R1, it prompts me for all the ODBC information again (like it never saved it properly). Then I get a generic ODBC error message. Also, when I compare the two ODBC drivers through notepad, they look totally different. The CA Express V4R5 driver contains a lot more information. I am using the the latest service pack, SI02795. Any ideas?