Error only at ids 10: Why?
Michael Andreas copied rows from Informix into Access with an INSERT ... SELECT over ODBC. After the server moved from 7.x to IDS 10 it always failed with Types incompatible. Jonathan Leffler asked about versions and column types, which were serial, integer, char and date. Copying row by row and column by column worked. No cause or fix was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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