Create an ODBC Data Source

To create an ODBC data source:

1. Open your Windows Control Panel.

   

2. Select Administrative Tools > Data Source (ODBC).

   The ODBC Data Source Administrator window opens.

   

3. On the File DSN tab click the Add button.

   The Create New Data Source window opens.

   

4. Select the SQL Server driver.

5. Click the Next button.

   

6. Enter a name for the Data Source.

7. Click the Next button.

   A Create a New Data Source to SQL Server window opens.

   

8. Click the Finish button.
9. Enter a Description and select the Server.

10. Click the Next button.

    

11. Click on the With SQL Server authentication and use the login... option.
12. In the Login ID box, type JurisRPT
13. In the Password box, DO NOT TYPE A PASSWORD, instead leave it blank (as shown above.)

14. Click the Next button.

    Another window opens.

    

15. Make sure to change the default database to the Juris® database (not JBills).

16. Click the Next button.

    Another window opens.

    

17. Accept the defaults and click the Finish button.
18. Click on the Test Data Source button.
19. Click on the OK button to close the wizard.

Now that the Data Source has been established, it may be used to link to Juris through ODBC compliant software such as Microsoft Access or Excel.