odbc connection to as/400 db2

From: Date: Wed, 30 Apr 2003 10:55:00 +0000
Subject: odbc connection to as/400 db2
Groups: php.windows 
Request: Send a blank email to php-windows+get-19730@lists.php.net to get a copy of this message
Hello list, I've searched the lists and the internet but failed to get an answer to my problem. regarding a connection with an ibm db2 database using php on a windows 2000 webserver. I use php 4.2.3 and apache 2.0.39 on a windows 2000 server. I have created a DSN with the ODBC drivers (32 bit) and the odbc works as I can browse the database using MSAccess or Winsql using a user that has select rights. But when i use the PHP odbc connect function nothing happens, the browser keeps loading the page and does not time out. So this is even before I start executing a query. I saw a listitem regarding NT4 that told me to assign a username to the apache server and let that user be allowed to log on as a service. That did result in a succesfull connection but all my queries are returning SQL7973 . This has got to do something with packets creation but I know almost nothing of DB2 itself. I only like to get some records through odbc...... Has anybody has some answers? Is it really so hard getting this odbc connection to work? With regards, Wim Blanken GIS Consultant The Netherlands

« previous php.windows (#19730) next »