Adding SQL server data sources

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:

1. Open the Site Administrator Home page.

2. In the ODBC Data Source area, click Add SQL Server Data Source.

3. The Add SQL Data Base form displays:

• In the Data Source Name (DSN) text box, enter the name your script uses to connect to the source database.

• In the ODBC Driver Name text box, the SQL Server is the default driver.

• In the DNS Description text box, enter the description of the data source.

• In the Associated SQL Server text box, enter the SQL Server name, which is the host name of the remote/local SQL Server.

• In the Default Database Name text box, enter the name of the default database to be used, if database name was not provided in the ODBC connection.

4. Click Add. The SQL Server data source is added and is displayed on the List OBDC Data Source page.