How To Set up a Microsoft SQL Server ODBC Data Source

Summary

The steps in this article are for use with version 3.6x and later of the SQL Server ODBC driver.

More Information

To locate your version of the driver:
  1. Click the Start button, click Settings, then click Control Panel.
  2. If you're using Windows NT, double-click on Data Sources(ODBC). For Windows 2000 and XP, double-click on Administrative Tools, then double-click on Data Sources(ODBC). The ODBC Data Source Administrator window should appear.
  3. Click the Drivers tab.
  4. Scroll down to SQL Server. The value listed in the Version column should be 3.6x or later.
To setup an MSSQL Data Source:
  1. Click the Start button, click Settings, and then click Control Panel.
  2. If you're using Windows NT, double-click on Data Sources (ODBC). For Windows 2000 and XP, double-click on Administrative Tools, and then double-click on Data Sources (ODBC) . The ODBC Data Source Administrator window should appear.
  3. To create a data source for the current user only, click the User DSN tab. To create a data source for all users of the computer, click the System DSN tab. FRx Software recommends the use of a System DSN for all data sources, even if the computer is used by only one user.
  4. Click the Add button. The Create New Data Source window appears.
  5. Select the SQL Server driver, and then click Finish. The Create a New Data Source to SQL Server window appears.
  6. Type a name for the data source in the Name box.
  7. If desired, type a description for the data source in the Description box.
  8. In the Server box, type the name of the server to which the data source will connect, and then click Next.
  9. Choose the method of authentication required to connect to your SQL Server.
  10. If SQL Server authentication was chosen in step 9, type a Login ID and Password, and then click Next.
  11. If a database name cannot be specified in the application that will use this data source, select the Change the default database to check box, and then select the database from the drop-down list. If the application does allow a database name to be specified, this step is not necessary - the application will provide the default database when connecting to the data source.
  12. All other check boxes on this screen may be left alone unless specific changes are necessary for your server or environment. Click Next.
  13. All options on this screen may be left alone unless specific changes are necessary for your server or environment. Click Finish.
  14. Click the Test Data Source button and verify that it tests successfully.
  15. Click OK, and then click OK again to return to the ODBC Data Source Administrator window.
  16. Click OK to close the ODBC Data Source Administrator window.

References

Eigenschaften

Artikelnummer: 965049 – Letzte Überarbeitung: 04.02.2009 – Revision: 1

Feedback