Re: DBD::DB2, Apache and mod_perl

2004-11-09 Thread Martin J. Evans
I'm not that familiar with iODBC but the error is indicating it can't find your data source. What I don't understand is that if you are using ODBC (and it looks as though you are given the error) then how is that 'dbi:DB2:as400tes - shouldn't it have been 'dbi:ODBC:as400tes'? How do you get an

Re: DBD::DB2, Apache and mod_perl

2004-11-09 Thread Miroslav Lauš
Hey! Read again what I wrote ;-) I'm using the __DB2__ and the DSN is correct! What I don't understand I'm getting error from iODBC (yes, i found this message in libiodbc.so library, which is also installed on the system). But I want native DB2 connections from mod_perl application, so I'm

Re: DBD::DB2, Apache and mod_perl

2004-11-09 Thread Miroslav Laus
Heureka! The problem lies in the mod_php4 which is compiled with ODBC support, and somehow it turns out to load the ODBC driver instead of the DB2 one. Weird. I'm using mod_php 4.3.3 on SuSE 9.0 Anyway, thanks to all who tried to help me. Miroslav On 08. Nov v 15:17, Miroslav Lau wrote: Hi

DBD::DB2, Apache and mod_perl

2004-11-08 Thread Miroslav Lauš
Hi all! I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've managed it to work from command line. But when trying to connect to remote database from a mod_perl application the $DBI::errstr is set to this: [iODBC][Driver Manager]Data source name not found and no default

Re: DBD::DB2, Apache and mod_perl

2004-11-08 Thread Dan Scott
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav Lau [EMAIL PROTECTED] wrote: Hi all! I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've managed it to work from command line. But when trying to connect to remote database from a mod_perl application the $DBI::errstr is

Re: DBD::DB2, Apache and mod_perl

2004-11-08 Thread Miroslav Lauš
As you can see, I'm not setting them, I'm printing them out. They are set in the httpd.conf via the SetEnv directive and they are kept correctly in the mod_perl environment. Miroslav On 08. Nov v 19:06, Dan Scott wrote: On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav Lau [EMAIL PROTECTED] wrote: