Microsoft KB Archive/245390

Knowledge Base

PRB: Open Record Fails When Specifying URL as Active Connection

Article ID: 245390

Article Last Modified on 9/17/2003

---

APPLIES TO

• Microsoft Data Access Components 2.5
• Microsoft Data Access Components 2.6
• Microsoft Data Access Components 2.7
• Microsoft Visual Basic 6.0 Professional Edition
• Microsoft Visual Basic 6.0 Enterprise Edition

---

This article was previously published under Q245390

SYMPTOMS

When you try to open a record object with a URL specified as the active connection, you might get the following error:

Run-time error '-2147467259 (80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

CAUSE

ADO did not interpret the specified URL as a valid connection string. Since the active connection did not specify any provider, ADO prompts the OLE DB provider for ODBC (MSDASQL), that is the default provider, for more information about the Data Source.

RESOLUTION

Make sure you specify the "URL=" keyword in your source parameter. This lets ADO open the record with the specified URL over which all subsequent record operations apply.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Start a new Visual Basic project. Form1 is created by default.
2. Add a Reference to Microsoft ActiveX Data Objects 2.5 Library

3. Paste the following code in the general declaration section of Form1:

   Private Sub Form_Load()
   
         Dim rec As New ADODB.Record
   
         ' The following line would generate error -2147467259. 
         rec.Open "", "http://servername"
   
         ' Comment the above line and uncomment the following line to resolve the problem
         ' rec.Open "", "URL=http://servername"
   
         rec.Close
   
      End Sub
                       

   NOTE: You should replace "http://servername" with a valid URL from your environment.
   
   

4. Run the above code to notice the behavior.

REFERENCES

For more information on the Record object, please refer to the Platform SDK or to the MSDN Library online.

Additional query words: kbGrpMDAC kbDSupport kbMDAC250

Keywords: kbprb KB245390

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.