PRB: No Information Returned for SQLSTATE IM006 from Driver
Article ID: 164173
Article Last Modified on 8/26/1999
APPLIES TO
- Microsoft Open Database Connectivity 3.0
This article was previously published under Q164173
3.00
WINDOWS
kbprg kbinterop kbprb
SYMPTOMS
If the database driver's SQLSetConnectAttr function call fails during a
SQLConnect or a SQLDriverConnect function call, the driver manager returns
SQL_SUCCESS_WITH_INFO and SQLSTATE IM006. However, no information from the
database driver is returned on why SQLSetConnectAttr failed. In contrast,
SQLBrowseConnect returns SQLError along with the error message from the
driver.
MORE INFORMATION
When SQLConnect or SQLDriverConnect is called and the database driver has
not been loaded, the Driver Manager loads the driver and calls
SQLAllocHandle. If connection attributes were specified, the driver manager
then calls SQLSetConnectAttr in the driver. However, if the driver's
SQLSetConnectAttr function fails, the Driver Manager returns
SQL_SUCCESS_WITH_INFO and SQLSTATE IM006 for the connection function, while
the error message from the driver is lost.
Keywords: KB164173