Establish a connection with a database using Microsoft ActiveX Data Object (ADO)
protocols.
-
Connect a True constant to the
prompt? input of the Open
Connection node. The prompt? input
displays the Data Link Properties dialog box when you run
your code. Configure your data connection by selecting the available options in
the dialog box.
-
In Windows Explorer, right-click an empty location in a folder and select from the short-cut menu. Change the file extension of this
document from .txt to .udl.
-
Use a path control to specify the path to your UDL file.
Use the path created in step 2.
If you experience problems connecting to a database after configuring your UDL, try
the following troubleshooting strategies:
- Verify the requested server is running.
- Verify the network is running.
- Verify there are available server connections.
- Verify with your administrator whether the maximum number of user licenses
has been reached.
- Check whether you have permission to access the specified database.
- Check whether the specified UDL exists.
- Select the correct provider for a database. You must create a DSN to connect
to a database that uses ODBC, while you must use a UDL to connect to
databases that use ADO and OLE DB.