To set up an SQL Server data source using ODBC
- Click
Start menu (Windows)
Settings Control Panel. - Double-click the ODBC icon.
- In
the ODBC Data Source Administrator dialog box, do one of the following:
- Choose the User DSN tab to create a data source that is visible only to you and can be used only on the computer you create it in.
- Choose the System DSN tab to create a data source that is visible to all users who have access rights to the computer.
- Choose the File DSN tab to create a data source that can be shared with other users who have the same ODBC drivers installed on their systems.
- Click Add.
- Select SQL Server, and then click Finish.
- Follow
the instructions in the wizard to complete the data source setup.
Microsoft provides additional Help topics describing the interface components of each page in the wizard. To view Help for a wizard page, click Help.
- In the ODBC Data Source Administrator dialog box, click OK.