Access <--ODBC--> Informix woes
Posted in 1994
Topics: Connectivity: ODBC / JDBC / .NET
I am using Access, ODBC, third party ODBC drivers for Informix (made by Q+E), Informix, and PC-NFS winsock.dll to extract data from an Informix database that is on an RS/6000. I have been experiencing some problems and was wondering if anyone has encountered (and hopefully solved) similar problems with similar configurations. I can attach tables from an Informix database to an Access database. The problem I have crops up when I try to open a number of these tables (in datasheet view). At some point, Access crashes during the opening of a table. If I restart Access, however, that same table can be opened without a problem. None of the tables are very large. I have spent quite some time crashing Access, but have not been able to detect any sort of pattern to the crashes. If you have any ideas, I'd like to hear them. I'm sure that any information you can share would be very useful. Thanks in advance. Dave David MacMahon Software Engineer davidm@marcam.com