ODBC Profiles - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide

Language
English (United States)
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
13.1

Smart Instrumentation uses an ODBC profile when connecting to a Smart Instrumentation database on SQL Server.  When you install Smart Instrumentation 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 Smart Instrumentation.

SQL Server ODBC Profiles

When you install Smart Instrumentation on SQL Server, the software creates an ODBC profile on the Windows registry level and 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 Smart Instrumentation, 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 Smart Instrumentation database residing on a different machine.

When installing Smart Instrumentation, the software creates an ODBC profile for every shipped .ddti file on the Windows registry level and 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.ddti 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 Smart Instrumentation 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.

See Also

Smart Instrumentation Database Schemas