PRB: SQL_DRIVER_NOPROMPT Error in IIS 4.0 ISAPI Application

• Microsoft Visual C++, 32-bit Editions, versions 5.0, 6.0

SYMPTOMS

An ISAPI extension running under IIS 4.0 gives the following error when CDatabase::Open is called to open a database connection in an ODBC data source:

Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled

RESOLUTION

Use the CDatabase::OpenEx function and specify the noOdbcDialog option to open your database connections.

   CDatabase db;
   db.OpenEx(_T("DSN=myDS;UID=myID;PWD=myPWD;"), CDatabase::noOdbcDialog); 

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The SQL_DRIVER_NOPROMPT flag instructs ODBC to connect with the information passed in the connect string and to avoid displaying a login dialog box at run time.

CDatabase::OpenEx() with the noOdbcDialog option calls SQLDriverConnect with the SQL_DRIVER_NOPROMPT flag. Using the CDatabase::Open function causes MFC to use SQL_DRIVER_COMPLETE instead of SQL_DRIVER_NOPROMPT.

NOTE: Make sure you are using a "System DSN" and not a "User DSN" with an ISAPI application. The process for creating a System DSN is identical to that for creating a regular data source. Open the 32-bit ODBC Administrator (in the Control Panel) and click the System DSN tab, then click Add to create a System DataSources.

REFERENCES

Refer to the Visual C++ online help for a complete description of the OpenEx function.

For additional information and tips on using ISAPI and MFC ODBC, please see the following article(s) in the Microsoft Knowledge Base:

Q160906 HOWTO: Use MFC 4.2 ODBC Classes in an ISAPI DLL

Additional query words: kbvc500 kbvc600

Keywords : kbDatabase kbMFC kbODBC kbVC
Version : WINNT:5.0,6.0
Platform : winnt
Issue type : kbprb