Creating an ODBC Connection

How do I create an ODBC connection for use with SafeKey?

First you must have been granted SafeKey rights to be able to access the raw table information via an ODBC connection (Security>Set Up Organization Menus).

To create an ODBC connection to access your data via another application, use the following steps:

1. Select Start>Run.
2. At Run enter: odbcad32.
3. The ODBC Data Source Administrator will appear — select the File DSN tab.
4. Select Add.
5. Select the SQL Server driver for the data source.
6. Enter a descriptive name for the Data Source.
7. Click Finish to enter the SQL Server driver connection information.
8. Enter a description for the Data Source.
9. From the drop-down list, select the MIP Server.
10. Verify the authenticity of the logon ID using SQL Server authentication.
11. Enter your Logon ID and Password that has been granted SafeKey rights.
12. Change the default database to the database you want to access.
13. On the final panel, no changes are necessary — just click Finish.
14. Review the Configuration information and Test the Data Source.
15. Once the Data Source has been successfully tested, it will now be available for use with other applications.