Re: IBM DB2 and DSN

Can you please show us your code? -- Regards, Tyson Lloyd Thwaites I.T&e eCommerce Division Adelaide www.ite.com.au "Yasuhide OMORI" <omori@m-t.com> wrote in message news:20001226180922.A2834@omori.m-t.com... > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >