Creating a Data Link for the ODBC Data Source
- Updated2025-11-07
- 1 minute(s) read
Creating a Data Link for the ODBC Data Source
To access Citadel data from an ADO client, you need a data link to ODBC. If you are able to create the data link from within your ADO client, you might be required to create the data link multiple times. Complete the following steps to create a data link once that can be stored anywhere on your system or network:
- Create a Citadel 5 ODBC data source if you do not have one.
- Create a new text document with a .txt extension.
- Open this text document in Notepad and select File»Save as to display the Save as dialog box.
- In this dialog box, select All Files from the Save as type pull-down menu.
- In the File name pull-down menu, enter a file name with a .udl extension, for example data_link.udl
- Right-click the .udl file and select Properties from the shortcut menu. In the dialog box that appears, click the Provider tab and select Microsoft OLE DB Provider for ODBC Drivers.
- Click the Next button or the Connection tab and select the Citadel 5 ODBC data source name.
- Click the OK button.