This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to
Article Number 000385088 for more information about troubleshooting BMC products in containers.
Legacy ID:KA357994
To manually configure the driver, please follow below steps:
- Have installed or have access to the following files is required:
Normally found in the <midtier_install>\WEB-INF\lib
arodbc81_build001.dll
arapi81_build001.dll
arrpc81_build001.dll
arutl81_build001.dll
For Midtier version 9.X
Normally found in the <midtier_install>\WEB-INF\lib
arodbc91_build001.dll
arapi91_build001.dll
arrpc91_build001.dll
arutl91_build001.dll
- Open regedit.
- Navigate to:
HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBC.INI
1. Create New Key called 'AR System ODBC Data Source'
2. Within the AR System ODBC Data Source, create the following strings:
ARDiaryDescend with a value of 0
ARUseLabel with a value of 0
ARUseUnderscores with a value of 1
Driver with a value of <path\to\>arodbc81_build001.dll
3. Click on the key, ODBC Data Sources, then add a new string called 'AR System ODBC Data Source' with a value of 'AR System ODBC Driver'
- Navigate to:
HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI
1. Create a new key called 'AR System ODBC Driver'
2. Within the AR System ODBC Driver key, create the following strings.
APILEVEL with a value of 0
ConnectFunctions with a value of YYN
DestPath with a value of <path\to\midtier\WEB-INF\lib>
Driver with a value of <path\to\midtier\WEB-INF\lib>\arodbc81_build001.dll
DriverODBCVer with a value of 03.51
Setup with a value of <path\to\midtier\WEB-INF\lib>\arodbc81_build001.dll
SQLLevel with a value of 1
Create a DWORD (32bit ) Value called UsageCount with a decimal value of 207615648
- Navigate to
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers
1. Create new String called 'AR System ODBC Driver" with a value of Installed
- Reboot your system
- Open the 32bit ODBC Administrator Panel
Verify that the AR System ODBC Data Source is listed on the System DSN and you can configure it.
Please note that you should explicitly run the 32-bit version from c:\Windows\SysWOW64\odbcad32.exe.
If you use Start, Run, odbcad32.exe you may not get the correct version and you will not be able to configure the driver.