Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Step 5. Create a Windows Data Source (Test the Setup)

Step 5. Create a Windows Data Source (Test the Setup)

To test the client configuration, or if a System Data Source is not available on the client machine, you can create a System Data Source with the Windows ODBC Data Source Administrator, based on the architecture of the machine.
  1. Open the Windows ODBC Data Source Administrator.
    1. On a 64-bit Windows machine, you can find the ODBC Data Source Administrator in the following locations:
      • 64-bit ODBC Administrator:
        <Windows installation>\System32\odbcad32.exe
      • 32-bit ODBC Administrator:
        <Windows installation>\SysWOW64\odbcad32.exe
    2. On a 32-bit Windows machine, you can find the ODBC Data Source Administrator in the following location:
      • 32-bit ODBC Administrator:
        <Windows installation>\System32\odbcad32.exe
  2. To view the System Data Sources, click the
    System DSN
    tab at the top of the window.
    The following image shows the
    System DSN
    properties:
    The ODBC Data Source Administrator window has empty Name and Driver properties in the System Data Sources box.
  3. Click
    Add
    .
    The
    Create New Data Source
    window opens.
  4. In the
    Create New Data Source
    window, click the name of the ODBC driver that you want to create a DSN for, based on the database that you want to connect to.
  5. Click
    Finish
    .
    The ODBC setup window opens.
  6. Provide the DSN details that the ODBC setup window requires and click
    Test Connection
    . When the successful connection dialog box appears, click
    OK
    to close the dialog box.
  7. Click
    OK
    to close the ODBC setup window.
    The DSN appears in the
    System DSN
    tab of the
    ODBC Data Source Administrator
    window.
  8. Note the System Data Source Name property value, which the client application requires to connect to the target database.
  9. Click
    OK
    to close the ODBC Data Source Administrator.

0 COMMENTS

We’d like to hear from you!