Error only at ids 10: Why?

Hi, using the following SQL-Command I copy a lot of rows from a INFOMIX DB (source) into a ACCESS DB (destination) very fast: INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab WHEREtab_typ = 50; After changing the IDS Server to version 10 I allways get the message "Types incompatible". Why? thanks michael

Michael Andreas wrote: > using the following SQL-Command I copy a lot of rows > from a INFOMIX DB (source) into a ACCESS DB (destination) > very fast: > > INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab WHERE> tab_typ = 50; > > After changing the IDS Server to version 10 I allways get the > message "Types incompatible". Why? What was the previous version of IDS? 7.x? 9.x? What types are in the table? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

> What was the previous version of IDS? 7.x? 9.x? the previous version was 7.x > What types are in the table? int, date, string

> What types are in the table? The types are serial, integer, and char. If I copy the same recordset row by row and colum by colum I dont get the error! michael