# Configuring the ODBC jEDI on Windows

Created At: 11/22/2019 7:51:18 PM
Updated At: 12/30/2019 5:54:06 PM
Original Doc: configuring-the-odbc-jedi-on-windows
Original ID: 497473
Internal: Yes

For windows operating systems, only the jEDIdrivers.ini file needs to be properly configured for correct function of the utility (as the ODBC definitions are defined in the native Windows 32/64 bit manager). It can exist in the **%SYSTEMROOT%, %JBCDATADIR%/config,**or **%HOME%**environment variables. Moreover, since the ODBC jEDI is comprised of a set of bin (executable) and lib (driver libraries and subroutines) binary-object files, you must ensure the lib directory path is added to your PATHenvironment variable (before beginning the steps listed below). The full path of the bin directory is located within your PATHenvironment variable, and the full path of the lib directory is located within your JBCOBJECTLISTenvironment variable.

For the configuration example below, we will be configuring an MSSQL ODBCdriver by doing the following:

  1. Navigate to the Control Panel

configuring-the-odbc-jedi-on-windows: 1574210484997-1574210484997

  1. Click on System and Security

configuring-the-odbc-jedi-on-windows: 1574210506636-1574210506636

  1. Click on System

configuring-the-odbc-jedi-on-windows: 1574210547647-1574210547647

  1. Confirm whether you have a 32 or 64 bit operating system

configuring-the-odbc-jedi-on-windows: 1574458856453-1574458856453

  1. Navigate back to the System and Security page

configuring-the-odbc-jedi-on-windows: 1574210995160-1574210995160

  1. Click on Administrative Tools

configuring-the-odbc-jedi-on-windows: 1574211022130-1574211022130

  1. Open the ODBC Data Sources app for the operating system we found in step 4 (64-bit in this example)

configuring-the-odbc-jedi-on-windows: 1574267302290-1574267302290

  1. Click on Add

configuring-the-odbc-jedi-on-windows: 1574359914331-1574359914331

  1. Select SQL Server Native Client [version] and click on Finish

configuring-the-odbc-jedi-on-windows: 1574268421531-1574268421531

# Note

For SQL Server, the **SQL Server Native Client [version]**must be the selected driver due to its ability to support Multiple Active Statements (MAS).

  1. Fill out the fields to define the Microsoft SQL Server Native Client driver

configuring-the-odbc-jedi-on-windows: 1574360349136-1574360349136

  1. Click on Next

configuring-the-odbc-jedi-on-windows: 1574268826282-1574268826282

  1. Click on With SQL Server authentication using a login ID and password entered by the user, and enter the user id and password used to enter your RDBMSserver

configuring-the-odbc-jedi-on-windows: 1574268921696-1574268921696

  1. Click on Next

configuring-the-odbc-jedi-on-windows: 1574269134579-1574269134579

  1. Update the fields listed as desired

  2. Click on Next

configuring-the-odbc-jedi-on-windows: 1574269249743-1574269249743

  1. Update the fields listed as desired

  2. Click on Finish

configuring-the-odbc-jedi-on-windows: 1574360641898-1574360641898

  1. Click on Test Data Source to test theODBC driver configuration, this will let you know if the ODBC driver correctly connected to your MSSQL database server

configuring-the-odbc-jedi-on-windows: 1574360672226-1574360672226

# Troubleshooting

If you did not receive the "TESTS COMPLETED SUCCESSFULLY!" message, make sure you selected the correct server in step 10, and entered the correct username and password information to connect to the server in step 12.

  1. Navigate to the %SYSROOT% or %HOME% directory (where the jEDIdrivers.ini file lives) using the File Explorer

  2. Open jEDIdrivers.ini up for editing using your favorite text editor

configuring-the-odbc-jedi-on-windows: 1574273580209-1574273580209

  1. Update the file parameters in the file to reflect the correct ODBC driver parameter values (these will depend on which driver you're setting up). Use the parameter descriptions in the jEDIdrivers.ini file definition section of the Structure of ODBC jEDI Initialization Files document to identify what needs to be changed.

# Note

The DSN parameter value corresponds to the name of the ODBC data source you created in the steps above.

jEDIdrivers.ini

[General]
JRLAlock = 0
FullyExpanded = 0
PasswdsEncrypted = 0
TblSep = __
VMCSep = __
CSVdir = /dbms/JEDICSV

[ODBC]
default = DSN=MSSQL;UID=sa_new;DATABASE=ds_Portal_prod
msmatrix = DSN=MSSQL;UID=sa_new;DATABASE=hs_label_matrix

[ODBC_default]
passwd = expswrd

[ODBC_matrix]
passwd = expswrd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

Introduction to the ODBC jEDI

Installing the ODBC jEDI on Linux/Unix

Installing the ODBC jEDI on Windows

Structure of ODBC jEDI Initialization Files

Structure of ODBC jEDI Mapping Files

Configuring the ODBC jEDI on Linux/Unix

Using the ODBC jEDI