Creating the ODBC DSN
To set SQL Server Options
- Click Start, point to Settings, and then click Control Panel.
- Double-click ODBC Data Sources.
- Click the System DSN tab and click Add.
- Select SQL Server from the list of installed ODBC drivers. Click Finish.
- In the Create New Data Source to SQL Server dialog box, enter the name and server of the data source in the text boxes provided. Set Name to "FmLib" and Server to "(local)". The Description is optional. Click Next.
- Select the SQL Server Authentication option button and enter sa in the Login ID text box. For this login ID, there is no password. Click Next.
- Select the default database check box, and find FmLib in the list of databases. Click Next and Finish.
- In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source to ensure that everything is working. Click OK to finish.
- Click OK to close the Create New Data Source to SQL Server dialog box.
- Click OK to close the ODBC Data Source Administrator.