[PHP] ODBC Problem

[Kiswa]

Hi.
I have a problem, Been writing a site in php that uses ODBC systemlink to a
Access DB
The server is apache

The problem is that the final server is win2000 IIS and the thing doesent
work.
It seems that the odbc connect doesent output any info.
It works fine on apache
cant figure out what the difference is.




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP ODBC Problem

[Mike]

Hi,

I've installed PHP 4.3.0 on a Win2k (SP3) IIS 5 server, as we were moving
the site to another server (old server was also win2k, php 4.3.0), and ODBC
calls no longer function correctly when served from the webserver, however
they work perfectly when called from the command line.

So http://site/odbc_test.php hanged, while 'php odbc_test.php' in cmd.exe
worked perfectly. The ODBC drivers and settings are the same as what was on
the previous server.

Tracked down the problem to the ODBC_Connect line. If I specified an invalid
DSN, e.g. odbc_connect(wrong, ,) or die (); the script would
terminate with the correct error message. However, if I specified a valid
DSN then PHP would simply hang. No error message. Nothing in the Event
Viewier.

At first I was using the ISAPI version of PHP for IIS, but then after I saw
ODBC work using PHP from the command line, I changed IIS over to use
php.exe, but with no success.

Any ideas?

Oh, and I did end up setting the security permissions for the ODBC database
directory to give System  Everyone  IUSER_ full access.

Mike C.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php