Version: 2024.1.1

Connection Configuration

All database connections specify the database, the user and password and the database scheme where the database objects are stored.

Oracle​

The connection to an Oracle database uses a single field to specify the database.

Standalone Connect Descriptor​

The easiest way of connecting to an Oracle database is to use the connect descriptor directly in the connection string. This requires no additional settings and no other config files. This is equal to the settings in tnsnames.ora but it must be given in one line. See the Oracle documentation for more details.

Example:​

The values for HOST, PORT and the SERVICE_NAME have to be filled out correctly.
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverName)(PORT=serverPort))(CONNECT_DATA=(SERVICE_NAME=serviceName)))

The setting in the inPoint.Wizard would look like this: inPoint.Wizard - Standalone Connect Descriptor

Naming method (using sqlnet.ora)​

Using sqlnet.ora it's possible to use the advanced Oracle connection settings like:

  • tnsnames (local naming method): Resolve a network service name through the tnsnames.ora file on the client.
  • LDAP (directory naming method): Resolve a database service name, net service name, or network service alias through a directory server.
  • NIS (external naming method): Resolve service information through an existing Network Information Service (NIS)

The configuration files from Oracle must be placed in local directory, depending on the method used these files are named differently. E.g. for LDAP the files sqlnet.ora and ldap.ora are required. In any case these should be supplied by the Oracle administrator.

After placing all required files in the directory the system environment variable TNS_ADMIN must be created which points to this directory.

Important:
Only processes started after the change will have the new value and only if started from the desktop and not an already running command line. If in doubt restart the machine.

Example:​

The setting in the inPoint.Wizard is only the name which the Oracle client will look up itself:

inPoint.Wizard - Standalone Connect Descriptor

SQL-Server​

For Microsoft SQL-Server there are two fields one for the name of the server and one for the name of the database itself.

Example:​

The setting in the inPoint.Wizard would look like this: inPoint.Wizard - Standalone Connect Descriptor

Name / Network Address​

The default is to use the name or the ip-address of the machine, because this requires no additional settings.

Named Instance​

In case of a named instance, the name of the instance is added to the server name separated by a backslash.
e.g. localhost\MyInstance

Non default port​

If a port other than the default is used it has to be added to the server name separated by a comma.
e.g. localhost,1433

Alias​

It's possible create an alias using SQL Server Configuration Manager and enter the name of the alias instead of the server name.

Important:
Create the same alias for 32-Bit and 64-Bit!