Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

PRB: SQL_DRIVER_NOPROMPT Error When Using DEconnection in VB COM Object


View products that this article applies to.

This article was previously published under Q253114

↑ Back to the top


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� HOWTO: Use the VB DataEnvironment in Your MTS Components
193128� HOWTO: ODBC and OLEDB Connection Prompt Control in ADO

↑ Back to the top


Keywords: kbdataenv, kbprb, KB253114

↑ Back to the top

Article Info
Article ID : 253114
Revision : 4
Created on : 12/3/2003
Published on : 12/3/2003
Exists online : False
Views : 380