Open DataBase Connectivity (ODBC) is a standard database access method that allows you to access and modify data from any application, regardless of which database management system is handling the data.
To add a Microsoft SQL Server Data Source:
SQL data source options |
|
Option |
Description |
Data Source Name (DSN) |
The name used by your script to connect to the source database. |
ODBC Driver Name |
Microsoft SQL Server is the default driver. |
DSN Description |
The description of the data source. |
Associated SQL Server |
The host name of the remote/local SQL Server. |
Default Database Name |
The name of the default database to be used, if database name was not provided in the ODBC connection. |