Article ID: 167745 - Last Review: March 2, 2005 - Revision: 1.1

PRB: ODBC Connections Must Be Opened With SQL_DRIVER_NOPROMPT

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q167745
Expand all | Collapse all

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.
Back to the top

STATUS

This behavior is by design.
Back to the top

REFERENCES

For information on obtaining version 2.0, please see the following article in the Microsoft Knowledge Base:
185174  (http://support.microsoft.com/kb/185174/EN-US/ ) INFO: Latest Version of Microsoft Transaction Server


For more information, visit the following sites on the World Wide Web:
http://support.microsoft.com/ (http://support.microsoft.com/)
http://msdn.microsoft.com/support (http://msdn.microsoft.com/support)
Back to the top
APPLIES TO
  • Microsoft Transaction Services 1.0
Back to the top
Keywords: 
kbprb KB167745
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top