Creating the Hello World DSN

Use the following procedure to create an ODBC System DSN for the Hello World application.

To create an ODBC System DSN

1. Open Control Panel and double-click the ODBC icon.
2. Click the System DSN tab and click Add.
3. Select SQL Server from the list of installed ODBC drivers. Click Finish.
4. Enter the name and server of the data source in the text boxes provided. The description is optional. Click Next. (In the CML, Name is "FmLib", Server is "(local)". In Hello World, Name is "HelloWorld", Server is up to the user.)
5. Click the SQL Server Authentication option and enter sa in the Login ID text box. Click Next.
6. Select the default database check box, and find FmLib in the list of databases. Click Next and then Finish.
7. Click Test Data Source to ensure that everything is working. Click OK to finish. Close the ODBC Administrator applet.