Need help ODBC on Linux connecting to another Linux machine

[Auriferous]

[root@ftpsrv ~]# cd /usr/dlc/odbc/lib
[root@ftpsrv lib]# ldd*
bash: ldd*: command not found
[root@ftpsrv lib]# ldd *
libodbcinst.so:
linux-gate.so.1 => (0x001b3000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00580000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x00cc2000)
libm.so.6 => /lib/libm.so.6 (0x00d82000)
libc.so.6 => /lib/libc.so.6 (0x001b4000)
/lib/ld-linux.so.2 (0x004e4000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x0048b000)
libodbc.so:
linux-gate.so.1 => (0x0091d000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
libodbcinst.so => /usr/lib/libodbcinst.so (0x00243000)
libdl.so.2 => /lib/libdl.so.2 (0x0019f000)
libpgicu19.so => /usr/lib/libpgicu19.so (0x00e60000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x00bfb000)
libm.so.6 => /lib/libm.so.6 (0x00942000)
libc.so.6 => /lib/libc.so.6 (0x00248000)
/lib/ld-linux.so.2 (0x004e4000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00580000)
libpgicu19.so:
linux-gate.so.1 => (0x00ed5000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x005b2000)
libm.so.6 => /lib/libm.so.6 (0x00127000)
libc.so.6 => /lib/libc.so.6 (0x0014e000)
/lib/ld-linux.so.2 (0x004e4000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x003c0000)
libpgmback.so:
linux-gate.so.1 => (0x00879000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00fb1000)
libXm.so.2 => not found
libXt.so.6 => /usr/lib/libXt.so.6 (0x007d5000)
libX11.so.6 => /usr/lib/libX11.so.6 (0x00110000)
libXp.so.6 => not found
libXext.so.6 => /usr/lib/libXext.so.6 (0x00d65000)
libSM.so.6 => /usr/lib/libSM.so.6 (0x00b19000)
libICE.so.6 => /usr/lib/libICE.so.6 (0x00cad000)
libdl.so.2 => /lib/libdl.so.2 (0x008b9000)
libpgicu19.so => /usr/lib/libpgicu19.so (0x00fc8000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x0052f000)
libm.so.6 => /lib/libm.so.6 (0x00f03000)
libc.so.6 => /lib/libc.so.6 (0x00213000)
/lib/ld-linux.so.2 (0x004e4000)
libXau.so.6 => /usr/lib/libXau.so.6 (0x0088b000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0x00915000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00357000)
odbccurs.so:
linux-gate.so.1 => (0x00f27000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00237000)
libodbc.so => /usr/lib/libodbc.so (0x00110000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x00634000)
libm.so.6 => /lib/libm.so.6 (0x007ee000)
libc.so.6 => /lib/libc.so.6 (0x00c80000)
/lib/ld-linux.so.2 (0x004e4000)
libodbcinst.so => /usr/lib/libodbcinst.so (0x0024e000)
libdl.so.2 => /lib/libdl.so.2 (0x00253000)
libpgicu19.so => /usr/lib/libpgicu19.so (0x00f28000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00257000)
odbctrac.so:
linux-gate.so.1 => (0x0060f000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00d8e000)
libodbcinst.so => /usr/lib/libodbcinst.so (0x00a1f000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x00110000)
libm.so.6 => /lib/libm.so.6 (0x00f15000)
libc.so.6 => /lib/libc.so.6 (0x00152000)
/lib/ld-linux.so.2 (0x004e4000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00296000)
pgpro1019.so:
linux-gate.so.1 => (0x0075b000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00c2b000)
libdl.so.2 => /lib/libdl.so.2 (0x00803000)
libpgicu19.so => /usr/lib/libpgicu19.so (0x00c42000)
libprocli92.so => not found
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x00110000)
libm.so.6 => /lib/libm.so.6 (0x00152000)
libc.so.6 => /lib/libc.so.6 (0x00500000)
/lib/ld-linux.so.2 (0x004e4000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00856000)
vscnctdlg.so:
linux-gate.so.1 => (0x00af0000)
libpthread.so.0 => /lib/libpthread.so.0 (0x003a7000)
libX11.so.6 => /usr/lib/libX11.so.6 (0x00110000)
libXm.so.2 => not found
libXt.so.6 => /usr/lib/libXt.so.6 (0x0025a000)
libstdc++-libc6.1-1.so.2 => not found
libm.so.6 => /lib/libm.so.6 (0x00213000)
libc.so.6 => /lib/libc.so.6 (0x00500000)
/lib/ld-linux.so.2 (0x004e4000)
libXau.so.6 => /usr/lib/libXau.so.6 (0x00d8c000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0x0023a000)
libdl.so.2 => /lib/libdl.so.2 (0x00e72000)
libSM.so.6 => /usr/lib/libSM.so.6 (0x00409000)
libICE.so.6 => /usr/lib/libICE.so.6 (0x0048a000)
[root@ftpsrv lib]#

 

[Auriferous]

Any Ideas how to resolve these errors?

 

[Auriferous]

OK, After setting some environment variables I was able to get the error message to go away however now I'm getting errors in the apache log saying "odbc.ini cannot be found." I set ODBCINI and ODBCSYSINI but this doesn't seem to have helped..

 

[Auriferous]

GOT IT WORKING!! Finally after 3 days! Thanks for the help.. just enough direction to get me looking in the right places!

 

[Casper]

What was the solution?

Casper.

 

[Auriferous]

Well i'm not exactly sure but mostly just having the right variables exported properly. I actually ended up copying /usr/dlc from a redhat box and pasting into /usr/dlc on the Oracle Enterprise Linux Box. Then I exported the variables and it magically started working!

Still having some issures though. After several queries I start getting errors until eventually I cannot execute one without an error. To fix it I can restart apache and it works perfect for a few. I'm not sure if it has something to do with having too many connections as I think we have a limit. On a windows box I would often get an error of "exceeding permissable connections" if I quieried many times... especially if executing many queries with errors. Then to fix this issue I would restart coldfusion and it would work again.