Create a data source to point to the SQL Server database

1. Open the ODBC Administrator either from Standard Time or from the Control Panel.  The ODBC Administrator is usually found in the Administrative Tools section of the Control Panel.  Choose the File DSN tab.
   
   If you are located in Europe, you may need to check the option named "Change the language of SQL Server system messages" and change the language to "British English" or "English" in the File DSN configuration.  This will ensure that dates are translated correctly for your SQL Server installation.  This language choice must match your SQL Server database.  Normally in Europe, this is either 'British English' or U.S. English'.
   
   
   
   
   
2. Click Add, and then choose the SQL Server driver, and then click Next.
   
   
   
   
3. Name the new data source "Standard Time sql", and click Next.
   
   
   
4. Click Finish to create the data source, then choose the server that your SQL database is running on.  This name will be the name of the computer that Microsoft SQL Server is running on.
   
   
   
5. Choose to use NT Authentication.  Click Next.
   
   
   
6. Choose to change the default database to "Standard Time".
   
   
   
7. Click Finish to finalize the data source.
   
   
   
8. Test the data source to confirm that it is set up properly, and then click OK.
   
   
   
9. The data source should be shown in the File DSN list.  You are finished!
   
   If you are located in Europe, you will need to check the option named "Change the language of SQL Server system messages" and change the language to "British English" in the File DSN configuration.
   
   
   Click the Back button in the browser to learn more about how to set up Standard Time to use the new data source to access the database on SQL Server.