Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Set ODBC File Permissions

    • Product: Voyager

    Question

    Set the proper permissions on ODBC-related files in Windows

    Answer

    1. Open Windows Explorer & navigate to the C:\Oracle\product\10.2.0\client\network\ADMIN\ (or similar depending on your installation) directory
    2. Right-click on the tnsnames.ora, then click on Properties
    3. Click on the Security Tab, then click on Authenticated Users
    4. Click Edit, check the Allow box next to “Full control”, then click OK.
    5. Hit OK on the Properties box
    6. Repeat steps 1-5 for the sqlnet.ora file

    Additional Information

    Windows Active Directory Group Policy and/or User Access Control sometimes prevents the ODBC drivers from reading these files properly.


    • Article last edited: 27-Sep-2019
    • Was this article helpful?