PDA

View Full Version : ODBC Driver not correct using Client Access Express V5R1



lrdeghand@dstsystems.com
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?

lrdeghand@dstsystems.com
04-23-2002, 10:40 AM
I forgot to specify that this ODBC driver is created as a "File DSN". We want to store the ODBC driver on the network and let several people access it. If I create the ODBC driver as a "User DSN", it works fine.