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

ID: Q197323

The information in this article applies to:

Microsoft Visual InterDev, version 6.0
Microsoft Internet Information Server versions 3.0, 4.0
ActiveX Data Objects (ADO), versions 2.0, 2.1 SP2

SYMPTOMS

The following error appears:

ADODB.Connection error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

CAUSE

Events in the Global.asa file are not fired, and as a result, Application or Session variables used for data connectivity are not initialized.

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:

Open Microsoft Management Console.

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

Click Createunder the Directory Tab.

Click OK to close the Properties window.

Try to view the page again from your browser.

Make sure the DSN has been created on the IIS computer.

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

Q184572 PRB: Creating Application with PWS 4.0, Windows 95 and VID

Additional query words:

Keywords : kbASP kbCtrl kbDatabase kbVisID600 kbGrpASP kbGrpMDAC kbDSupport kbADO210sp2
Version : WINDOWS:2.0,2.1 SP2,6.0; winnt:3.0,4.0
Platform : WINDOWS winnt
Issue type : kbprb