[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

[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);

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 =

[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

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

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 Aug

[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?

[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 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

[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 error

RE: [PHP-DB] DB2 Performance issue

2001-10-02 Thread Andrew Hill
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 This was posted on the newsgroup a couple of months ago

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

2001-10-02 Thread Mark Newnham
: [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 our real problem was: After playing a little bit with the php-scripts that try to connect

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

2001-10-02 Thread John Lim
to using a 3rd party odbc driver. Shucks.. Regards Mark -Original Message- From: Mark Newnham [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 3:33 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] DB2 Performance issue This was posted on the newsgroup

[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

[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

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

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 or

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