IBM DB2 and DSN

From: Date: Tue, 26 Dec 2000 09:09:22 +0000
Subject: IBM DB2 and DSN
Groups: php.db 
Request: Send a blank email to php-db+get-5435@lists.php.net to get a copy of this message
Hi. I cannot find out how to connect IBM DB2 via odbc_connect. What I use are: Vine Linux 2.0 (derived from RedHat-6.1) apache-1.3.14 php-4.0.3pl1 (DSO) DB2 UDB V6.1 I confirmed DB2 actually work because 'db2' command worked and I can get result of 'SELECT' sentence and so on... phpinfo() works fine. 'Configure Command' is as follows './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-mod_charset=yes' '--with-gd' '--enable-jstring' '--with-mysql=/usr' '--with-xml' '--with-ibm-db2=/usr/IBMdb2/V6.1' '--with-zlib-dir=/usr' '--enable-sysvshm=yes' '--enable-sysvsem=yes' '--with-config-file-path=/etc' '--enable-mbregex' '--enable-safe-mode=yes' '--enable-track-vars=yes' '--enable-magic-quotes=yes' '--enable-debugger=yes' '--enable-bcmath=yes' '--enable-force-cgi-redirect=yes' '--enable-discard-path=yes' '--enable-memory-limit=yes' '--enable-i18n' '--with-gdbm' '--enable-versioning' But I cannot decide 'Data Source Name'. At first I just set IP address of the server but an error with broken charactors can be seen. Warning: SQL error: , SQL state N********** in SQLConnect in /home/omori/ public_html/IBMdb2.php on line 15 I set locale to 'C' but the result was all the same. How 'dsn' should be decided??? - - I send the same mail to php-general but there was no answer so I send now to php-db. Sorry if you read twice. Then I didn't wrote network stracture, now please see the following ascii art: +-------------+ +--------------+ | 192.168.1.5 +--+ 192.168.1.16 | +-------------+ +--------------+ Client Server Vine Linux 2.0 RedHat6.2J -- Yasuhide OMORI

« previous php.db (#5435) next »