uses an ODBC profile when connecting to a database on SQL Server. When you install on SQL Server, the software automatically creates an ODBC profile on your client machine. The created profile type is System DSN, which allows every user working on this machine to connect to the database using this profile. You do not need to configure this profile to connect to .
SQL Server ODBC Profiles
When you install on SQL Server, the software creates an ODBC profile on the Windows registry level and also adds database profile connection parameters in the [Database] section of the Intools.ini file. For SQL Server 2014 database server, on every client machine where you install , the software creates the MSS2014 profile. It is not possible to create SQL Server ODBC profiles using the Internal Setup Utility. However, you can use the Internal Setup Utility to test the connection to your database using any other ODBC profile for SQL Server that exists in your Windows registry.
-
To ensure that you do not receive errors when opening a domain from your database, in the [Database] section of the Intools.ini file, the ServerName parameter must have the same value as <ODBC profile name> in the ODBC connection string.
-
You must use your tools to create an ODBC profile if you want to connect from your client machine to another database residing on a different machine.
When installing , the software creates an ODBC profile for every shipped .db file on the Windows registry level and also adds database profile connection parameters in the [Database] section of the Intools.ini file. For example, if you chose to create an empty database rather than a demo database, in the Intools.ini file, the software automatically sets the connection parameters to enable the use of the ODBC profile created for the Intools.db database. Connection parameters for other ODBC profiles are commented out.
You must create an additional ODBC profile in the following case:
-
You need to connect from your client machine to another database residing on a different machine.
The Internal Setup Utility provides a convenient method of creating ODBC profiles, although, you can define ODBC profiles using the Windows Control Panel, Data Sources option, on the System DSN tab or User DSN tab. When creating an ODBC profile using the Internal Setup Utility, you have an option to define the profile creation method. The following methods are available:
System DSN
Allows you to create a database profile on the registry entry level of the local machine so that every user working on this machine can connect to the database using this profile. The profile appears in the Windows registry in the following path: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.
User DSN
Allows you to create a database profile on the registry entry level of the current user so that only the current user working on this machine can connect to the database using this profile. The profile appears in the Windows registry in the following path: HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI.
User DSN and System DSN
Allows you to create a profile on both registry entry levels.