Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 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

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use