Data Link Properties
This dialog is used for creating a connection to an OLE DB data source, typically via ODBC. The dialog is opened when clicking the Connect... button in the Data page of the Tool Pane in the Edit Script dialog.
The first tab lists the names of the OLE DB providers. In order to create an ODBC data connection, select OLE DB Provider for ODBC Drivers, then click Next>> to get to the Connection tab.
On the Connection tab under 1, specify the source of data, a previously configured data source is chosen. There are two different types of ODBC data sources that may come into question.
Pre-Defined Data Sources
ODBC data sources which have been predefined can be accessed by selecting the radio button Use data source name. The drop-down list contains all the data sources that are defined. Select the data source to use.
If necessary specify User name and Password for the data source. The connection can also be tested by pressing the Test Connection button.
Finally click the OK button. The connect statement is ready.
Generic Data Sources
Generic data sources are used e.g. for database files. If a generic data source is to be used or a new source should be created, select the Use Connection String radio button and click Build. This opens the Select Data Source dialog.
There are two types of data sources available: File data sources and Machine data sources. The latter data sources are specific to the local machine and user while file data sources are specific to a file. Any of the two can be used. Each has a separate page in the Select Data Source dialog.
Generic data sources are used e.g. for database files. If you want to use a generic data source or create a new source, select the Use Connection String radio button and click Build. This opens the Select Data Source dialog.
There are two types of data sources available: File data sources and Machine data sources. The latter data sources are specific to the local machine and user while file data sources are specific to a file. Use any of the two. Each has a separate page in the Select Data Source dialog.
Double-click a data source, then browse to the applicable database file in the dialog that opens.
When hitting RETURN it returns to the second page of the Data Link Properties dialog.
Specify if necessary User name and Password for the data source. It is also possible to test the connection by pressing the Test Connection button.
Finally click the OK button. The connect statement is ready.