On the Windows Start menu,
click Settings, click Control
Panel, click Administrative Tools,
click Data Sources (ODBC). The ODBC
Data Source Administrator dialog box is displayed.
In
the ODBC Data Source Administrator dialog
box, click the User DNS tab if you want the
data source to be visible only to you on this machine, or click
the System DSN tab if you want
the data source to be visible to others on this machine and on the
network. Click Add. The Create
New Data Source dialog box is displayed.
NoteYou may not use the File
DSN tab, because Fdo does not support its use.
In
the Create New Data Source dialog box,
click SQL Server, click Finish. The Create
a New Data Source to SQL Server dialog box is displayed.
In this dialog box, in the text entry box labeled Name ,
type the name that you want to use as the
value of the DataSourceName connection property.
In
this dialog in the text entry box labeled Server, type
the name of the SQL Server that you
want to connect to.
Click Next to
go to the next screen where you see the network login Id is used
to verify the user’s identity.
Click Next to
go to the next screen where you can change the default database.
Click Next to
go to the next screen where you can change other parameters.
Click Finish.
The ODBC Microsoft SQL Server Setup dialog
appears showing the configuration parameter settings.
In
this dialog click Test Data Source.... The SQL
Server ODBC Data Source Test dialog appears giving you
test results. Click OK to close this dialog.
Click OK to
close the ODBC Microsoft SQL Server Setup dialog .
In
the ODBC Data Source Administrator dialog
box, you see the DSN that you just added listed. Click OK.