How To Troubleshoot "ADODB.Connection" Error 800a0bb9 from Recordset DTC

A Visual InterDev Design-Time Control (DTC) may return the following error message: This article outlines some of the common steps to take to troubleshoot this error message.

This error occurs because the Recordset Design-Time Control errors are filtered through the Visual InterDev 6.0 Script Library. Usually the problem manifests as a blank or incorrect connection string.

To troubleshoot this error, follow these steps:

1. This error often occurs because the Global.asa file does not fire. As a result, the Application and Session variables that are initialized in the Session_OnStart and Application_OnStart events are not created. The most common cause for Global.asa not firing is if the virtual folder that contains the file is not set up as an application.
   
   IIS 3.0
   
   To resolve this problem in Internet Information Server (IIS) 3.0, set up a virtual folder where the Global.asa and .asp files exist in IIS. Allow this folder Read and Execute permissions.
   
   IIS 4.0 and IIS 5.0
   
   To resolve this problem in IIS 4.0 and 5.0, make your virtual directory an "Application" as follows:
   
   
   1. Open Microsoft Management Console.
   2. Right-click on the virtual folder where the Global.asa file exists, and then click Properties.
   3. On the Directory tab, click Create.
   4. Click OK to close the Properties window.
   Personal Web Server
   
   To resolve this problem for Personal Web Server on a computer that is running Microsoft Windows 95 or Windows 98, see the following article in the Microsoft Knowledge Base:
   184572  (http://support.microsoft.com/kb/184572/EN-US/ ) PRB: Creating Application with PWS 4.0, Windows 95 and VID
2. Verify that Global.asa is not losing session state instead of not firing at all. To do this, follow these steps:
   1. Open the Global.asa file, and add the following code into the Session_OnStart event:

      Session("Test") = Now()
      						

   2. Create an Active Server Pages (ASP) page named Test.asp. Use the following code to write out that session variable:

      <%
      Response.Write "Session variable: " & Session("Test")
      %>
      						

   3. In your browser, view Test.asp. If the date/time string appears after the "Session variable: " text, Global.asa is firing.
   For additional information about this error when Global.asa is firing, but the session state or application state is being lost, click the article numbers below to view the articles in the Microsoft Knowledge Base:
   281298  (http://support.microsoft.com/kb/281298/EN-US/ ) PRB: Session Variables Do Not Persist When Application Contains Empty Global.asa
   182891  (http://support.microsoft.com/kb/182891/EN-US/ ) INFO: Session ID Does Not Persist in Active Server Pages
   172864  (http://support.microsoft.com/kb/172864/EN-US/ ) BUG: ASP Pages Fail on Access to Session and Application Objects
   178037  (http://support.microsoft.com/kb/178037/EN-US/ ) PRB: Session Variables Are Lost When ASP Is Located in Frameset
   173307  (http://support.microsoft.com/kb/173307/EN-US/ ) PRB: Nested Virtual Roots Can Lose Session State
3. This error can occur because of a permissions problem. Turn on Basic Authentication for this application only to see if there is a permissions problem. To do this, follow these steps:
   
   
   1. Open Microsoft Management Console.
   2. Right-click the virtual directory where the Global.asa file exists, and then click Properties.
   3. On the Directory Security tab, under Anonymous Access and Authentication Control, click Edit.
   4. Clear all of the checkboxes, and then select the Basic Authentication check box.
   5. Click Apply, and then click OK.
   6. View the page again. When you are prompted to log on, use an Administrator account.
   If the Web page works correctly when you use Basic Authentication, you most likely have a permissions problem on a file. Change back to your default authentication scheme, and use the Windows NT File Monitor to check for file "Access Denied" errors. Windows NT File Monitor is available from the following Sysinternals Web site:
   http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx (http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx)
4. This error can occur if a bound field contains spaces in its name, such as "Field One". The Visual InterDev 6.0 Script Library does not delimit field names. As a result, a syntax error occurs. To resolve this problem, see the following article in the Microsoft Knowledge Base:
   259388  (http://support.microsoft.com/kb/259388/EN-US/ ) PRB: 800a0bb9 Error Occurs With Data Bound Design-Time Control
5. Verify that the TEMP and TMP environment variables exist as system variables when you connect to a file-based database, such as Microsoft Access.
   
   To do this, follow these steps:
   1. On the Start menu, click Settings, click Control Panel, and then double-click the System icon.
   2. On Microsoft Windows NT, click the Environment tab.
      
      On Microsoft Windows 2000, click the Advanced tab, and then click Environment Variables.
   3. Under System Variables, search for the TEMP and TMP variables. If these variables exist, verify that the path is correct.
      
      If these variables do not exist, under System Variables, click New. In the Variable Name box, type TEMP. In the Variable Value box, type c:\temp.
   4. Repeat the previous step for the TMP variable.

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.