ACC95: Btrieve ODBC Error "Table is Not Defined in Dictionary" (156221)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access Developer's Toolkit 2.0
- Microsoft Access Developer's Toolkit 7.0
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.
| Modification Type: | Major | Last Reviewed: | 11/14/2003 |
|---|
| Keywords: | kb3rdparty kbprb KB156221 |
|---|
|