You receive an error message similar to the following:
Requested registry access is not allowed
The account used by TX does not have permission to get a list of all System DSN entries on the machine. TX needs this permission when you create a ODBC data source.
Grant permission to read the list of System DSN entries in the registry by following the steps below.
You need administrative rights to complete this guide.
- Determine which account is used by TX.
- From the Start menu, click Run, type "regedit", and then click OK to start Registry Editor.
- In the HKEY_LOCAL_MACHINE window, browse to the HKLM\SOFTWARE\ODBC\ODBC.INI key. The ODBC.INI key contains a subkey for each ODBC system DSN that is registered on the machine.
- Right-click the ODBC.INI key and from the context menu, click Permissions.
- Add the user account that you identified in step 1 to the list of users who can access this key, and select the Read check box for this user.
- Click Apply, and then close Registry Editor.
As stated in any Microsoft knowledge base article involving changes to the registry, if you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. We cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.