Task 2 – Create the ODBC Data Source

This is a command line with parameters and is found in the createDSN.cmd file. Executing this file first runs the setEnv.bat file (errors in this file will interfere with execution of the command line), and then executes the following command line:

%ASANY10%\dbdsn -w "exesample"
         "uid=DBA;pwd=SQL;dbf=exercisedb.db;eng=exercisedb"

Notice that the parameters include the data source name exesample, the default user name and password, and the database name. For more information on these parameters, see the SQL Anywhere documentation, referenced in Related publications.