PRB: ADODB.Connection Error 800a0bb9 When Using Recordset DTC

ID: Q197323

The information in this article applies to:

SYMPTOMS

The following error appears:

ADODB.Connection error 800a0bb9, "Application is using arguments that are using the wrong type, out of acceptable range, or are in conflict with one another" when using the Visual InterDev 6.0 Recordset Design Time Control.


CAUSE

This error occurs because the Recordset Design Time Control (DTC) errors are filtered through the Visual InterDev 6.0 script library.


STATUS

This behavior is by design.


MORE INFORMATION

For IIS 3

The Global.asa file is not getting "fired" because the directory where the Global.asa is located has not been set up as Virtual Directory in Internet Information Server (IIS); therefore, the Session variable with the DSN and connection information is empty. This can be checked by doing a Response.Write Session("variableName").

The resolve this problem, set up a virtual directory where the Global.asa and ASP files exist in IIS and set it to allow Read and Execute access.

For IIS 4

The Global.asa file is not getting "fired" because the directory containing the Global.asa file is not set to be an Application.

To resolve this problem, make your virtual directory an "Application" using the following steps:
  1. Open Microsoft Management Console.


  2. Bring up the properties for the virtual directory where the Global.asa file exists


  3. Click the Create button under the Directory Tab.


  4. Click OK to close the Properties window.


  5. Try to view the page again from your browser.


  6. Make sure the DSN has been created on the IIS Machine.


This error occurs because the Recordset Design-Time Control errors are filtered through the Visual InterDev 6.0 script library. Normally, with a hand coded ADO connection, the error message would be as follows:
OLE DB Provider error for ODBC Drivers error 80004005 [Microsoft] [ODBC Driver Manager] Data Source Name not found and no default driver specified.


REFERENCES

For additional information, please see the following articles in the Microsoft Knowledge Base:

Q188715 Global ASA Not Firing when Visual InterDev made IIS4 Application" [iis]

Q190006 ODBC Drivers Error 80004005" When Browsing ASP Pages

Q183060 INFO: Troubleshooting Guide for 80004005 & Other Error Messages 


Keywords          : kbASP kbCtrl kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0; WINNT:3.0,4.0
Platform          : WINDOWS winnt 
Issue type        : kbprb

Last Reviewed: May 4, 1999