Configuring ODBC

ODBC must first be configured before you can use the DB library.
At the moment, the DB library only supports MSSQL and ORACLE.
“Configuring ODBC" explains the following topics:

ODBC Setting Guide (MSSQL)

To configure ODBC for MSSQL server connection, complete the following steps:

  1. In the search window of the Windows Start menu, enter "odbc” and perform a search.

  2. Under the "Administrative tools" item, click Set up data Sources (ODBC).

  1. In the "ODBC Data Source Administrator" window, Click User DSN > Add.

  1. In the "Create New Data Source" window, select the "SQL Server" driver from the list of drivers and click Finish.

  1. In the "Data Source to SQL Server" window, enter the name, description, and SQL server IP and click Next.

  1. Select an authentication type and enter the login ID and password, and then click Next.

    • Contact your DB administrator for the login ID and password required for the SQL Server connection.

  1. Select a database to connect to and click Next.

8. Set additional options and click Finish.

ODBC Settings Guide (Oracle)

Drivers for accessing the Oracle database are not included in the Windows operating system.
To use an Oracle database, visit the Oracle website first and install the ODBC driver before proceeding with the settings.

To configure ODBC in Windows after installing the Oracle ODBC drivers, complete the following steps:

  1. Register the system parameters.

    1. On File Explorer, right-click "This PC” and click Properties in the context menu.

    2. In the "System properties” window, click Advanced > Parameters.

    3. In the "Parameters" window, create the “TNS_ADMIN” parameter on the system parameter list.

    4. Set the path to, under the "ORACLE_HOME” parameter path, "network\admin” folder. "tnsnames.ora” and "sqlnet.ora” files must exist in that folder.

The Oracle installation path must be included in the “Path” parameter. Add the path for the "ORACLE_HOME” parameter as the "Path" parameter value.

  1. In the search window of the Windows Start menu, enter "odbc” and perform a search.

  2. Under the "Administrative tools" item, click Set up data Sources (ODBC).

  1. In the "ODBC Data Source Administrator" window, Click User DSN > Add.

  1. In the "Create New Data Source" window, select the "Oracle" driver from the list of drivers and click Finish.

    • The name of the Oracle driver may vary depending on the version.

  1. Enter the driver information, including the Data Source Name, TNS Service Name, and User ID, and click Test Connection.

  1. In the "Oracle ODBC Driver Connect" pop-up window, enter the password and click OK.

  1. Enter the driver information, including the Data Source Name, TNS Service Name, and User ID, and click Test Connection.

  1. On Designer, ensure that the DB registered in the DSN properties of the DBConnection activity card is properly displayed.