Arch Linux

PolishHurricane

Member

Registered: 2011-02-02

Posts: 47

Can't get unixodbc to work, various errors

I'm trying to install Progress OpenEdge ODBC drivers so I can access data in some database for some craptastic software we have at my workplace.  I'm currently playing with my odbc.ini file(s) and trying to get this working, but currently I have the following errors when I try to connect to the database.  This forum is my last hope.

[root@Crux etc]# isql -3 SUBS2A
[IM003][DataDirect][ODBC lib] Specified driver could not be loaded
[ISQL]ERROR: Could not SQLConnect
[root@Crux etc]# isql -v
[IM002][DataDirect][ODBC lib] Data source name not found and no default driver specified
[ISQL]ERROR: Could not SQLConnect
[root@Crux etc]# /usr/bin/odbcinst -j /usr/dlc/odbc/lib/pgoe1023.so
unixODBC 2.3.1
/usr/bin/odbcinst: symbol lookup error: /usr/bin/odbcinst: undefined symbol: odbcinst_system_file_name

Basically in the past few days, I grabbed the driver I needed, found it had some dependencies it needed, so I moved them around and then grabbed a file I needed "libstdc++-libc6.2-2.so.3" from some FTP mirror because I couldn't find a package that would load it, tried symlinking it originally, then I managed to get my driver to load.  I *think* everything is all 32-bit.  Whatever I could check looked like it was.  I posted a question on Stackoverflow here for more info: http://stackoverflow.com/questions/1031 … on-install

Here are the dependencies though after all is settled.

[root@Crux lib]# ldd pgoe1023.so
        linux-gate.so.1 =>  (0xb77d1000)
        libpthread.so.0 => /lib/libpthread.so.0 (0xb74a8000)
        librt.so.1 => /lib/librt.so.1 (0xb749f000)
        libpgicu23.so => /usr/dlc/odbc/lib/libpgicu23.so (0xb69a4000)
        libdl.so.2 => /lib/libdl.so.2 (0xb699f000)
        libstdc++-libc6.2-2.so.3 => /usr/dlc/odbc/lib/libstdc++-libc6.2-2.so.3 (0xb6959000)
        libm.so.6 => /lib/libm.so.6 (0xb692d000)
        libc.so.6 => /lib/libc.so.6 (0xb678b000)
        /lib/ld-linux.so.2 (0xb77d2000)
        libgcc_s.so.1 => /usr/lib/libgcc_s.so.1 (0xb676e000)

Then after that was settled I messed with it for another substantial amount of time and I had a ton of other issues, one being environment variable problems: http://stackoverflow.com/questions/1033 … ease-check

But I eventually rewrote my ini files so I'm at the current problems above.  I was also consulting this document on page 59: http://documentation.progress.com/outpu … /dmsdv.pdf

My current ini files look as follows:

/etc/odbcinst.ini

[ProgressOpenEdge]
Description = ODBC for Progress OpenEdge
Driver = /usr/dlc/odbc/lib/pgoe1023.so
;Setup = /usr/dlc/odbc/lib/pgoe1023.so
FileUsage = 1

/etc/odbc.ini

[SUBS2A]
Driver = ProgressOpenEdge
DatabaseName = SUBS
PortNumber = 4000
HostName = 192.168.1.2
LogonID = SYSPROGRESS
Password = SYSPROGRESS
APILevel = 1
ConnectFunctions = YYN
CPTimeout = 60
DriverODBCVer = 03.50
FileUsage = 0
SQLLevel = 0
UsageCount = 1
ArraySize = 50
DefaultLongDataBuffLen = 2048
DefaultIsolationLevel = REPEATABLE READ
StaticCursorLongColBuffLen = 4096
[ODBC]
InstallDir = /usr/dlc/odbc
Trace = 0
TraceFile = odbctrace.out
TraceDll = /usr/dlc/odbc/lib/odbctrac.so
UseCursorLib = 0

I have like 2/3 other configurations which are entirely different that I tried, but this one is the latest and most promising.  Do you know if I have to reinstall unixodbc or something?

No matter what I do, I hit brick walls.  Been trying to install this whole setup for almost 4 work days now.

Thanks

PolishHurricane

Member

Registered: 2011-02-02

Posts: 47

Re: Can't get unixodbc to work, various errors

Latest update: http://stackoverflow.com/questions/1038 … -be-loaded

There were recent updates to the package php-odbc and the extension I had working stopped working, do you think this could be related to my issue?

Last edited by PolishHurricane (2012-04-30 12:42:53)