INFORMIX - MS ACCESS Connection "Michael Andreas" <andy[ at ]dachrinne.de> 14.07.2006 12:37:10 Hi, using the following SQL-Commands I copy a informix table-structure and later very fast the table-rows to a MS-access DB: SELECT * INTO tab1 FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; INSERT INTO tab1 SELECT * FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; source: INFOMIX IDS Server 7.0 destination : MS Access 2000 ODBC-Driver : INTERSOLV 3.11 32-Bit INFORMIX 9 If I change the source DB from INFORMIX IDS Server 7.0 to INFOMIX IDS Server 10.0 for both commands I get the error-message: reserved error : there is no message for this error (message from MS-query). I changed the field-types but the result is the same. The table dont includs a serial field. My Question: What is the difference between Version 7 and 10? Who knows a solution for my problem? andrew

Re: INFORMIX - MS ACCESS Connection Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 14.07.2006 12:39:43 hi Michael, Michael Andreas wrote: [Quoted Text] > My Question: > What is the difference between Version 7 and 10? > Who knows a solution for my problem? Nearly all ODBC/OLE DB drivers are somehow version specific. The Informix drivers i've dealt with are so, therefore check your driver version (i assume it is some 3rd party driver) against its specifications. > andrew Micheal, Andreas, Andrew? mfG --> stefan <--