Главная страница | назад

Article #19742: ODBC Connections via Microsoft ODBC Text driver

 Question and Answer Database

     FAQ: FAQ4742B - ODBC Connections via Microsoft ODBC Text driver
Category: Database (ODBC)
Platform: All-32Bit
 Product: All-CBuilder,   BC++5.x,   C++Builder1.0,   C++Builder3.x,   C++Builder4.x,   Delphi2.x,   Delphi3.x,   Delphi4.x,   VdBase7.x,   


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:
1. 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/13/99 10:45:44 AM

Last Modified: 01-SEP-99