Establish a connection with a database using Open Database Connectivity (ODBC)
protocols.
-
Use the ODBC Data Source Administrator dialog box to register and
configure drivers to make them available as data sources. In the Windows Control Panel,
select to configure a data source name connection.
-
Place an Open Connection node in your code.
-
Use a string or a path to specify the DSN you created, and wire it to the
connection information input.
If you experience problems connecting to a database after configuring your DSN, 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 DSN 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.

Note
You can use any ODBC-compliant
driver with the Database Connectivity API.