Microsoft KB Archive/218600

Knowledge Base

How To Use Data Links to Create a Connection String at Run Time

Article ID: 218600

Article Last Modified on 7/13/2004

---

APPLIES TO

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

---

This article was previously published under Q218600

SUMMARY

This article demonstrates how to programmatically use Data Links feature of the Microsoft Data Access Components in order to generate a connection string at run-time.

MORE INFORMATION

In version 2.0 of the Microsoft Data Access Components, Data Links were introduced. Data Link files are similar to ODBC DSN files, but allow you to select an OLE DB provider to connect to your database. With the OLE DB Provider for ODBC drivers, you can also connect to an ODBC data source.

Double-clicking on a Data Link file displays a set of property pages that allow you to build a connection string to connect to your database.

You can use this same functionality in your Visual Basic applications by following the steps listed below:

1. Launch Visual Basic and open a new Standard Exe project. Form1 is created by default.
2. Select References from the Project menu, and then select Microsoft OLE DB Service Component 1.0 Type Library from the list of available references.
3. Add a CommandButton to your form.

4. Add the following code to the Click event of your CommandButton:

   Private Sub Command1_Click()
       Dim objDataLink As New DataLinks
       Dim strConn As String
       
       strConn = objDataLink.PromptNew
       MsgBox "The connection string you created is:" & _
              vbCrLf & strConn
   End Sub
                       

5. Run the project.

When you click the CommandButton, you will see the Data Links property pages. Once you have specified how you want to connect to your database and click the OK button, you'll see the connection string in a dialog box.

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

189680 How To Use Data Link Files with ADO 2.0

244659 How To Create a Data Link File with Windows 2000

309485 How To Build a Connection String Programmatically in ADO.NET by Using Visual Basic .NET

Additional query words: datalink

Keywords: kbhowto KB218600

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.