Set ODBC Permissions

From Free State Drivers
Revision as of 16:22, 15 January 2015 by Cvopicka (talk | contribs) (Created page with "For individuals that are not administrators or "Power Users" on there system it will be necessary to set permissions for a key in the system registry. This is necessary to al...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

For individuals that are not administrators or "Power Users" on there system it will be necessary to set permissions for a key in the system registry. This is necessary to allow FPS to connect to databases through an ODBC connection. Without these permissions the user will be unable to create the temporary key in the registry that ODBC stores database connection information.

Steps to Update Registry Permissions

Standard Method

  • Open the registry by running REGEDIT from the start menu or command prompt.
  • navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
and on 64-bit installations:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ODBC
  • right click on the "ODBC" key
  • select "Permissions..."
  • Select "User" from the list of groups and users
  • Click "Allow" Full Control in the permissions section
  • Click "OK"
  • Exit the registry editor


The results should be immediate. However, if they are not reboot your machine.

Advanced Method

THIS IS AN ADVANCED METHOD TO SET REGISTRY PERMISSIONS. THIS IS NOT SUPPORTED BY FBRI AND THE USER MAY USE AT THERE OWN RISK.

First you will need the SubInAcl[1] utility from Microsoft

once you have downloaded the utility the following commands can be used to set permissions from a script or the command prompt.

SUBINACL /subkeyreg HKEY_LOCAL_MACHINE\SOFTWARE\ODBC /grant=Everyone=F
SUBINACL /subkeyreg HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ODBC /grant=Everyone=F

Notes: