[PHP-DB] db2

2001-02-11 Thread Chris Book
Hi, Will my db2 connection (using odbc_connect and the CLI driver) close when the script ends, or should I always call odbc_close? Thanks, Chris Book [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [PHP-DB] db2

2001-02-12 Thread Marios Moutzouris
>Will my db2 connection (using odbc_connect and the CLI driver) close >when the script >ends, or should I always call odbc_close? It should. otherwise if something goes wrong in the script, then connection still open. One of the disadvantages of pconnect. Ended up DOS'ing the AS400 ;-) marios

[PHP-DB] db2/db3 stability?

2002-05-27 Thread Ivan Voras
I encountered serious problems using (Berkeley) db2 & db3 support! 1) dba_open fails (!) when the "open flag" is set to "c" and the file exists ("c" flag means: create if not exist, open r/w otherwise). This error is reproducible with a simple php script started from a CGI version of php4. The er

[PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Javier Mestre
Any example how to use CLOB,BLOB fields with PHP under Windows and DB2 ? Thanks in advance Javier Mestre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] db2 with php

2001-02-04 Thread Chris Book
Hello, I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file o

[PHP-DB] DB2 Performance issue

2001-10-01 Thread Mark Newnham
This was posted on the newsgroup a couple of months ago: Christian Szardenings wrote: > > Hi Andrew, > > thanks a lot for your help. Today we discovered what > our real problem was: > > After "playing" a little bit with the php-scripts that try > to connect to the IBM DB2, we set the optional

Re: [PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Robert Twitty
The odbtp extension has be used quite successfully with DB2. You can get it at http://odbtp.sourceforge.net. I have not personnally used it with DB2, but there are posts on odbtp's help forum pertaining to DB2. -- bob On Tue, 3 Aug 2004, Javier Mestre wrote: > Any example how to use CLOB,BLOB f

Re: [PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Gerard Samuel
On Tuesday 03 August 2004 09:02 am, Robert Twitty wrote: > The odbtp extension has be used quite successfully with DB2. You can get > it at http://odbtp.sourceforge.net. I have not personnally used it with > DB2, but there are posts on odbtp's help forum pertaining to DB2. > > -- bob > > On Tue, 3

[PHP-DB] DB2 connection: Setting codepage

2010-01-21 Thread SomeDude
Hi all, I have some code that has to insert data into databases (DB2 AS400) coming from multilingual sources. The code on the Webserver is the same; that's why i can not use solution involving php configuration. For example: User 1 (English) logs into the application and submits some

Re: [PHP-DB] db2 with php

2001-02-04 Thread Wayne Bastow
Chris, Looks like libphp4.so need sto know where libdb2.so.1 is. I would look at two things: if db2 libraries are not in the standard location then you need to specify the location in --with-ibm-db2=/home/ (this is a guess). or look at ldconfig - you will probably need to specify the db2

Re: [PHP-DB] db2 with php

2001-02-04 Thread szii
Well, if it says that it's looking for it in /etc/httpd/modules then it's obviously not looking in /home/db2inst1/sqllib/lib, eh? Try a symlink... "ln -s /home/db2inst1/sqllib/lib/libdb2.so.1 /etc/httpd/modules/libphp4.so/libdb2.so.1" Or copy the library. Or I think you can add a line into /et

Re: [PHP-DB] db2 with php

2001-02-05 Thread fabrizio . ermini
> I've installed db2 and created the default instance at /home/db2inst1/. > PHP is compiled with the --with-ibm-db2 option, however when I try to start > apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into > server: libdb2.so.1: cannot open shared object file: No such file o

RE: [PHP-DB] DB2 Performance issue

2001-10-02 Thread Andrew Hill
Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Mark Newnham [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 5:33 PM > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] DB2 Performance issue > > > Thi

[PHP-DB] db2 as a module

2004-01-21 Thread Jason Keltz
Hi. We run PHP as a DSO through Apache with IBM DB2 support enabled. We want to be able to run the same PHP DSO module on a second machine that will not have support for DB2. How can I configure PHP via the configuration file such that DB2 support is enabled on one host, and not on another? Tha

[PHP-DB] DB2 - wrong number of parameters

2006-07-17 Thread Pablo Garay
Hi! I´m working with PHP 5 and using the DB2 database. I´m trying to update a jpg file, that´s save on the database. here´s the code: $fp = @fopen("$caminho/$nome_arquivo", 'r'); $content = fread($fp, filesize("$caminho/$nome_arquivo")); $content = bin2hex($content);

[PHP-DB] DB2 and php serialized data

2003-08-14 Thread Gerard Samuel
Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you offlist. Thanks for

Re: [PHP-DB] DB2 - wrong number of parameters

2006-07-17 Thread Chris
Pablo Garay wrote: Hi! I´m working with PHP 5 and using the DB2 database. I´m trying to update a jpg file, that´s save on the database. here´s the code: $fp = @fopen("$caminho/$nome_arquivo", 'r'); $content = fread($fp, filesize("$caminho/$nome_arquivo")); $content

RE: [PHP-DB] DB2 Performance issue - More Info

2001-10-02 Thread Mark Newnham
x27;[EMAIL PROTECTED]' > Subject: [PHP-DB] DB2 Performance issue > > > This was posted on the newsgroup a couple of months ago: > > > Christian Szardenings wrote: > > > > Hi Andrew, > > > > thanks a lot for your help. Today we discovered what > &

Re: [PHP-DB] DB2 Performance issue - More Info

2001-10-02 Thread John Lim
ry. > > So I guess this means the message below was related to using a 3rd party > odbc driver. > > Shucks.. > > > Regards > > Mark > > > > -Original Message- > > From: Mark Newnham [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 01,

Re: [PHP-DB] DB2 and php serialized data

2003-08-14 Thread Gerard Samuel
Gerard Samuel wrote: Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you

[PHP-DB] db2 (or any unified ODBC db), php, stored procedures, and OUT parameters

2001-06-26 Thread Alex Mikhail
I am trying to return an OUT or INOUT parameter from a stored procedure call to PHP via the Unified ODBC functions. I've RTFM and I don't see anything on this. I've tried to pass a variable to an INOUT parameter via the "parameters array" in odbc_execute. Is there any trick or hack to work a