| |
| Invalid Field Type when creating ODBC DataSource |
 |
I'm using BatchMove to create a table in an ODBC DataSource. How come I'm getting the error "Invalid Field Type"?
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:
. Use the Native driver (SQL Links) driver for the Database if one exists
2. Create the table yourself and use BatchAppend instead of BatchCopy. 7/ 3/99 0:35:27 AM
|
|
| Hits/month |
2,500,000+ |
Downloads (Since May 2000) |
7,393,709 |
| Total Files |
6,023 |
| Forum msgs |
7,670 |
| Articles/FAQs |
70+/900+ |
Top Selling Software at Amazon
|