Create ODBC DSN
This command creates an ODBC data source.
Data Source Name
Enter the name of the data source here. If you wish to duplicate the settings of a DSN already existing on your system, click the drop-down arrow and choose the DSN to capture.
Driver Name
Enter the name of the data provider here. With the
engine, no variables may be used in this field. With the , variables are allowed.Registration
- Check System DSN. to create a
- Check User DSN. to create a
Attributes
Specify your data source attributes here. You may enter multiple attributes by pressing CTRL+ENTER.
Notes
- Do not dereference variables using $ signs in the field.
- Dereference variables using square brackets instead.
- For instance, instead of using $TARGETDIR$, use [TARGETDIR].