PRB: SQL_DRIVER_NOPROMPT Error When Using DEconnection in VB COM Object (253114)


The information in this article applies to:

  • Microsoft Active Server Pages
  • Microsoft Visual Basic Professional Edition for Windows 5.0
  • Microsoft Visual Basic Professional Edition for Windows 6.0
  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.1 SP2
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
This article was previously published under Q253114

SYMPTOMS

The following error may occur when you use DEConnection in a Visual Basic COM object running under ASP:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC DriverManager]
Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled

CAUSE

This error occurs when properties of the DEConnection are not set correctly.

RESOLUTION

To resolve this problem, make sure that the DEConnection's RunPromptBehavior property is set to adPromptNever and specify values for the RunPassword and RunUserName properties of the control.

STATUS

This behavior is by design.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

198378 HOWTO: Use the VB DataEnvironment in Your MTS Components

193128 HOWTO: ODBC and OLEDB Connection Prompt Control in ADO

Modification Type:MajorLast Reviewed:12/3/2003
Keywords:kbDataEnv kbprb KB253114
©2003 Microsoft Corporation. All rights reserved.