PRB: ODBC Connections Must Be Opened With SQL_DRIVER_NOPROMPT (167745)
The information in this article applies to:
- Microsoft Transaction Server 1.0
This article was previously published under Q167745 SYMPTOMS
ODBC connections not opened with the SQL_DRIVER_NOPROMPT are rejected by
Microsoft Transaction Server. This is because a Transaction Server
component cannot cause an ODBC logon dialog box to be displayed. Specifying
SQL_DRIVER_NOPROMPT means that if the connection information is incorrect,
you will receive an error. If you are using a data access library, it must
be capable of specifying SQL_DRIVER_NOPROMPT when it connects to the ODBC
driver.
RDO and ADO allow you to specify SQL_DRIVER_NOPROMPT, while DAO does not
(unless you are using ODBCDirect).
If you are using Visual C++ and the MFC ODBC classes, you must use
CDatabase::OpenEx and specify the noOdbcDialog option to open your database
connections. Using CDatabase::Open causes MFC to use SQL_DRIVER_COMPLETE
instead of SQL_DRIVER_NOPROMPT, so CDatabase::Open always fails.
STATUS
This behavior is by design.
REFERENCES
For information on obtaining version 2.0, please see the following article in the Microsoft Knowledge Base:
185174 INFO: Latest Version of Microsoft Transaction Server
For more information, visit the following sites on the World Wide Web:
| Modification Type: | Minor | Last Reviewed: | 3/2/2005 |
|---|
| Keywords: | kbprb KB167745 |
|---|
|