AcuXDBC Connection Error

Hello Everyone;

We are a software developing company.

Our client has a main application which runs on linux and developed with acucobol using vision database.

 

They have acuxdbc installed.

[root@localhost bin]# ps -ef | grep acu
root      2073     1  0 07:06 ?        00:00:00 /opt/acucorp/922/bin/acushare -start
root      2439     1  0 07:06 ?        00:00:01 /opt/acucorp/922/bin/acurcl -start
root      2467     1  0 07:06 ?        00:00:00 /opt/acucorp/922/bin/acuserve -start
root      2468     1  0 07:06 ?        00:00:00 /opt/acucorp/922/bin/xdbcsrvr -p20222
root      2473     1  0 07:06 ?        00:00:00 /opt/acucorp/922/bin/xbissesd -f /etc/xbis.conf -n
root      2474     1  0 07:06 ?        00:00:00 /opt/acucorp/922/bin/xbisengd
root      6770  3675  0 14:20 pts/1    00:00:00 grep --color=auto acu

 

I can query the database with xdbcquery tool


[root@localhost bin]# xdbcquery /cacuxdbc04:system/manager/xvision:acuxdbc.cfg
                  VORTEXsql - Simple Interactive SQL.
                        Version 2.0.5.0 - Production.
Copyright ▒ 1989-2015, Trifox, Inc., California, USA.
                       All Rights Reserved Worldwide.
SQL (/? for help) ==> select * from PUBLIC.OTELSTANDARTISYERI where ISYERI_ADRES like '%kaya%';
 ISYERI_NO ISYERI_ADRES ISYERI_UNVAN                   ISYERI_SIRA ISYERI_RES_ADI                 ISYERI_SIFRE ISYERI_SAKLI ISYERI_GRUP ISYERI_BOS                                                 ISYERI_STAF
 --------- ------------ ------------------------------ ----------- ------------------------------ ------------ ------------ ----------- ---------------------------------------------------------- -----------
         1 kaya2010     kaya                                     9 kaya                                        T                      0                                                            ASYA

SQL (/? for help) ==>

I can connect to the application with acuthin. So I do not have a IP or PORT problem.

 

I have installed 2 different version of ACUODBC driver to my windows 10 client.

As the application is 32 bit I am using C:\Windows\SysWOW64\odbcad32.exe

  1. AcuCorp AcuXDBC |  8.01.02.00 | Micro Focus | ACUXDBC.DLL| 5.11.2009
  2. Extend9 AcuXDBC (32 bit) | 9.02.05.00 | Micro Focus (IP) Ltd. | ACUXDBC.DLL | 6.03.2015

I have configured System DSN for both driver version

Both have the same configuration:

But when I try to connect to the database within SQLdbx

I am getting an error: Error Translate: “ DLLLOAD: acuxdbc03, Modul could not be found. Error -1. SQLSTATE S1000. Drivers SQLSetConnectAttr failed. Driver does not support the ODBC  behavior that is needed by the application. .. “

 

How can I fix this problem.

 

Thanks

 

Yours sincerely

 

Timuçin ÇAKIRGİL