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