Microsoft OLE DB Provider for ODBC
In order to create an ODBC using the new DSN correctly, follow the steps below:
- Select the Use connection string option and click the Build... button. Set data source properties in the opened Select Data Source dialog.
- Enter the log on information to connect to the server in the User name and Password fields. You may leave these fields empty as these connection parameters are provided in the created connection string.
- If necessary, select/deselect the available options: Allow saving password, Blank password.
Click the Test Connection button to see if your connection settings are specified correctly.