Difference between INFORMIX IDS Server 7.0 and 10.0 ?
Posted in 2006
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?
michael