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, Question: Whenever I open a table via Microsoft's ODBC Text driver I get the error "Invalid table name". How come? Answer: 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