Microsoft KB Archive/156221

= ACC95: Btrieve ODBC Error "Table is Not Defined in Dictionary" =

Article ID: 156221

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access Developer's Toolkit 2.0
 * Microsoft Access Developer's Toolkit 1.1

-



This article was previously published under Q156221



SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

The BTI ODBC Driver version 1.0.1 may return error 204:

Table is Not Defined in Dictionary

This error generally occurs with a catalog function, such as SQLGetInfo. This can occur in both the 16- and 32-bit versions of the BTI ODBC driver.



CAUSE
A catalog function, such as SQLGetInfo, causes the ODBC interface to return a backslash (\) as the SQL_SEARCH_PATTERN_ESCAPE character. This means the backslash may indicate that certain characters that follow are interpreted as literals in search patterns.

When Microsoft Access generates an SQL statement that contains the backslash followed by the literal characters, the search is performed on the full string, including the backslash. This causes the search to fail and produces the error.



RESOLUTION
A patch is available from Pervasive Software, formerly known as Btrieve Technologies, in their Compuserve forum [GO Btrieve]. The update version is v1.0.3, and is in a self-extracting file called Odbcv103.exe.



MORE INFORMATION
The BTI ODBC driver is manufactured by Pervasive Software, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: SQL ADT attach link

Keywords: kbprb kb3rdparty KB156221

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.