How can I set up Attaché ODBC as a System DSN?

/How can I set up Attaché ODBC as a System DSN?

How can I set up Attaché ODBC as a System DSN?

Summary: Attaché’s ODBC creates only User DSNs by default. It is possible to set up a system DSN.

Please note that we do not recommend making any changes to your registry without a complete backup. If you are unsure about any steps in the procedure below, we strongly recommend you contact an Attaché consultant to assist you with this.

Details:

1. Create a DSN using Attaché’s ODBC Administrator as usual.

2. Go to the Windows ODBC Administrator and open the User DSN that has just been created.

3. Take note of the Database Script Name and Data Dictionary Path.

4. Create a System DSN using the Faircom Driver with the same Database Script Name and Data Dictionary Path as noted in step 3.

5. The System DSN has its settings stored in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{SYSTEM DSN Name} where {SYSTEM DSN Name} is a registry key name with the same name as the System DSN just created. A UserName needs to be specified for the DSN. Add a string value named “UID” to the registry key and set its value to the Attaché user name.

6. A password cannot be set on the DSN because its encrypted. A blank password can be used however. If a blank password for a user in Attaché is a problem, then set up a user dedicated for the purpose and set its menu rights to prevent access to any Attaché menu items.

 

By |2017-12-06T12:07:57+00:00December 6th, 2017|0 Comments