Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 ODBC Connections via Microsoft ODBC Text driver


Whenever I open a table via Microsoft's ODBC Text driver I get the error "Invalid table name". How come?   

    The BDE calls SQLTables to determine whether a table name exists. The BDE does not expect table names returned by SQLTables to have an extension, but Microsoft's Text driver does include extensions (Because unlike other drivers, it allows for tables with different extensions within the same database.) and therefore the tablename cannot be verified.

    There are two possible workarounds to the problem: . Use text files without extensions. To configure Microsoft's ODBC Text driver to do this run ODBC Administrator, configure your DSN, click Options, and *. as an extension. 2. Use the BDE Native Text driver instead.

    7/ 3/99 0:45:44 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