PRB: ODBC Connections Must Be Opened With SQL_DRIVER_NOPROMPT

• Microsoft Transaction Server 1.0

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 more information, visit the following sites on the World Wide Web:

http://support.microsoft.com/

http://msdn.microsoft.com/support

Additional query words: Open Database Connectivity

Keywords : kbinterop kbMTS kbMTS100 kbGrpCom kbDSupport TSrvODBC
Version : winnt:1.0
Platform : winnt
Issue type : kbprb