Re: dynamic lib ignored even after found in install_driver(Oracle) failed: Can't load... cgi problem

2007-08-31 Thread Charles Jardine
On 30/08/07 22:51, Bruce Sears wrote: the last lines in red show the dreaded install_driver(Oracle) failed: Can't load error, but further up, you can see in the first highlighted line that libclntsh.so.10.1 was actually searched for at the location it exists (and where it was found when the

Problems connecting to Oracle DB on SLES

2007-08-31 Thread Thorsten Harms
Hi, I have a quite annoying problem concerning the NLS_LANG parameter. If set to german_germany.we8iso8859p1 as necessary, connecting to database fails. If NLS_LANG is not set, all runs fine, but german umlauts are, of course, not correctly displayed. I ran the testing part as described in

Re: Problems connecting to Oracle DB on SLES

2007-08-31 Thread Peter J. Holzer
On 2007-08-31 09:37:51 +0200, Thorsten Harms wrote: I have a quite annoying problem concerning the NLS_LANG parameter. If set to german_germany.we8iso8859p1 as necessary, connecting to database fails. If NLS_LANG is not set, all runs fine, but german umlauts are, of course, not correctly

Re: DBI ODBC select statement length

2007-08-31 Thread Christopher Sarnowski
Since no one else seems to have answered I'll jump in with a few questions that might be helpful. Does it make any difference if there is an embedded newline in the statement? Is there a way to query the server to find out what query it thinks it's gotten? I've never worked with MSSQL so

Re: DBI ODBC select statement length

2007-08-31 Thread Brian Johnson
I just thought the problem was so obscure nobody had ideas! Hehe. Anyway, to answer your questions: We are parsing out all newlines from the select statement. As for finding out what the server thinks it's getting...we'll have to dig into that. We don't have direct access to the server, only

Re: DBI ODBC select statement length

2007-08-31 Thread Christopher Sarnowski
On Aug 31, 2007, at 1:34 PM, Brian Johnson wrote: I just thought the problem was so obscure nobody had ideas! Hehe. Anyway, to answer your questions: We are parsing out all newlines from the select statement. What happens if you leave the newlines in? I'm thinking there may be some

Re: dynamic lib ignored even after found in install_driver(Oracle) failed: Can't load... cgi problem

2007-08-31 Thread Bruce Sears
thanks for the input tim (and charles), i have checked all the permissions, and these should be fine for access by the apache user. and when i ran as myself (not root), the command line execution did fine, too. -rwxrwxr-x 1 root root 18825267 Nov 15 2006

Re: dynamic lib ignored even after found in install_driver(Oracle) failed: Can't load... cgi problem

2007-08-31 Thread Bruce Sears
ahhh... we are getting closer (?) after running strace -fFo trace_file /usr/sbin/httpd -X it looks like it is some sort of permissions problem after all (?) . . . 6177 open(/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so, O_RDONLY) = 3 6177 read(3,

Re: DBI::Informix and DBD::Informix

2007-08-31 Thread Martin Gainty
Hi Brian Is there a URL where I can download the driver? for some reason I could'nt get ahold of any of the other supposedly working DLLs.. Thanks! Martin This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email