Hi,

using the following SQL-Command I copy very fast a lot of rows
from a INFOMIX DB (source) into a ACCESS DB (destination):
INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab;

After changing the Informix IDS Server from version 7 to version 10 I
allways get the
message "Types incompatible".

I believe I need a newer ODBC-driver, my actuel version is :
INTERSOLV 3.11 32-Bit INFORMIX 9

Is there anyone who is able to help me?

thanks michael