Re: Informix and MS Access

In article <3p5nfl$mcl$1@mhadg.production.compuserve.com>, 76646.3261@CompuServe.COM says... > >I have successfully attached a Microsoft Access database to an >Informix Online database on Unix using the Q+E ODBC Informix >drivers and Informix INET for Windows version 5. > >Queries and reports seem to work just fine. > >My problem is in trying to insert 12,000 records located in an >Access table into the an Informix table. The insert query starts >off just fune until it gets to about 50% or 60% percent complete. Do I read this right that you are wanting to copy the data from the PC end up to the server? If so,as a workaround, have you considered exporting the table as delimitered text with a vertical bar (pipe symbol) as the delimiter. This can then be copied up to the server and loaded using the standard informix load command ie 'load from filename insert into tablename.' > At that point, everything starts to slow down --- Windows seems >to begin to swap to the hard drive, network traffic just about >stops, and Access seems to only be inserting 5 to 10 records per >minute. I let the job run for over 12 hours and it never will >finish --- my PC finally hangs. > >It seems that Windows starts running out of memory and starts >swapping way too much --- it shouldn't --- the PC is a 486/66 >with 16 MB of RAM. > >Any suggestions? > >I have read that there is a possible memory leak in Inet for >Windows --- is this true? Any workarounds.