Installation of Vembu on linux 16.04 - DB error - psqlodbcw.so missing

Login to console fails with message: SGDB1001:: Error while connecting to database '/home/vembubdr/Vembu/VembuBDR/data/sgserver.db' with error '01000 : Failed to connect to datasource: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/psqlodbcw.so' : file not found in database ::/home/vembubdr/Vembu/VembuBDR/data/sgserver.db')

Followed these steps as proposed by Ashar from another question with the same error: "It seems, UnixODBC is already installed in your machine and when we type 'obdcinst -j' command, it looks like that system search the odbc.ini file inside the /etc location. And there is no content in the /etc/odbc.ini file. During Vembu BDR installation, we have created the odbc.ini file inside /usr/local/etc/ location. Since, /etc/odbc.ini file is empty, you faced the db connection issue in your machine. So we have created a soft link for odbc.ini in your machine by running the following command, ln -s /usr/local/etc/odbc.ini /etc/odbc.ini Now, Vembu BDR is running and the db connection issue resolved. We will handle this case in our installer in our next update v3.8"

Generated output of "odbcinst -j /usr/local/etc/odbc.ini" and "isql -v PostGreDBConnection"

Determined that psqlodbcw.so is missing from missing from /usr/local/lib

Can this file be created as it does not appear to be in the zip file? I suspect it is generated through "make" command during the installation process.

Thanks.

edit retag flag offensive close merge delete