I have Visual COBOL 9, UnixODBC 2.3.9, Microsoft ODBC Driver 18 for SQL Server installed on RHEL 9.
odbcinst -j
unixODBC 2.3.9
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /xxxxxxx/odbc.ini
I have ODBCINI set to xxxxxxx/odbc.ini
LD_LIBRARY_PATH = :/opt/microfocus/VisualCOBOL/lib:/opt/microsoft/msodbcsql18/lib64:/usr/lib64
When I ran a simple COBOL program to connect to the database, I keep getting the following error:-
OpenESQL Error: Unable to load ODBC Driver/Driver Manager. Ensure that your
database environment is set correctly.
Connection to database failed:
Sqlcode = -0000010000
Sqlstate = IM001
Sqlerrmc =
Any help/suggestion will be appreciated.
Thanks!