Question and Answer Database
FAQ: FAQ4667B - Invalid Field Type when creating ODBC DataSource
Category: Database (ODBC)
Platform: All Windows
Product: All-CBuilder, BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x,
Question:
I'm using BatchMove to create a table in an ODBC DataSource. How come I'm getting the error "Invalid Field Type"?
Answer:
This error occurs for ODBC drivers where SQLGetTypeInfo(SQL_DOUBLE) returns a result set. In this case, the result is
float is attempted to be created on the DataSource even though the DataSource does not support floats. A clasic example of
this is Microsoft or Oracle's ODBC driver for Oracle.
There two possible solutions:
1. Use the Native driver (SQL Links) driver for the Database if one exists
2. Create the table yourself and use BatchAppend instead of BatchCopy.