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

ID: Q156221

The information in this article applies to:

Microsoft Access 7.0
Microsoft Access Developer's Toolkit, versions 2.0, 7.0

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 : kb3rdparty OdbcNonms
Version : 7.0
Platform : WINDOWS
Issue type : kbprb