Help and Support

PRB: SQL_DRIVER_NOPROMPT Error When Using DEconnection in VB COM Object

View products that this article applies to.
Article ID:253114
Last Review:December 3, 2003
Revision:3.0
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

Back to the top

CAUSE

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

Back to the top

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.

Back to the top

STATUS

This behavior is by design.

Back to the top

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
198378 (http://support.microsoft.com/kb/198378/EN-US/) HOWTO: Use the VB DataEnvironment in Your MTS Components
193128 (http://support.microsoft.com/kb/193128/EN-US/) HOWTO: ODBC and OLEDB Connection Prompt Control in ADO

Back to the top

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

Back to the top

Keywords: 
kbdataenv kbprb KB253114

Back to the top

Article Translations

 

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.