Ubuntu server cant connect odbc Progress odbc 11

Posted by q1000 on 21-Dec-2017 07:17

[60][unixODBC][DataDirect][ODBC 20101 driver][20101]Access denied(Authorisation failed)

I keep getting above error message when trying to connect to progress. It work from my windows pc but from ubuntu server i keep getting this error.

odbc.ini

[ODBC Data Sources]
Progress=Progress_SQL92_Driver

[Progress]
Driver = /usr/dlc/odbc/lib/pgoe27.so
DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={LD_LIBRARY_PATH=/usr/dlc/odbc/lib:/usr/dlc/lib}
DatabaseName = irtlivmip
PortNumber = 21258
HostName = 192.168.1.9
LogonID = ext_ods
Password = ********

odbcinst.ini

[ODBC]
Trace = no
TraceFile = /tmp/odbctrace.out
TraceDll = /usr/dlc/odbc/lib/pgtrc27.so

[ODBC Drivers]
Description = Progress driver
[Progress OpenEdge 11 Driver]
Driver=/usr/dlc/odbc/lib/pgoe27.so
FileUsage = 1

Please help

All Replies

Posted by Brian K. Maher on 24-Jan-2018 07:00

Can you connect when using JDBC (i.e. the sqlexp command line tool)?

Posted by Akshay Guleria on 25-Jan-2018 03:27

Double check if you are missing something using this -> knowledgebase.progress.com/.../P21252

This thread is closed