Microsoft KB Archive/253114

= PRB: SQL_DRIVER_NOPROMPT Error When Using DEconnection in VB COM Object =

Article ID: 253114

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft Active Server Pages 4.0
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.1 Service Pack 2
 * 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.

