Posted by Alvaro G. Vicario on 07/05/07 17:56

*** google@thefifthimperium.com escribió/wrote (Thu, 05 Jul 2007 10:21:35
-0700):
> I'm running PHP v4.4.0 on a Windows 2000 Server (SP4) running IIS
> v5. A simple script I'm using is generating ODBC errors (not finding
> my tables) when I run the script through a web browser connected to
> the IIS server.
>
> If I then run the unchanged script locally, from a Windows console
> window, the PHP script connects to the database and I can dump the
> table listing and access a particular table fine - I see the database
> contents scrolling by.

Are you using a system-wide DSN or a user DSN? When you run a script from
the command line it uses your user credentials, but when you run it through
a web server it uses the credentials of whatever user the web server runs
as (typically "LocalSystem").

--
-+ http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
++ Mi sitio sobre programación web: http://bits.demogracia.com
+- Mi web de humor con rayos UVA: http://www.demogracia.com
--

[Back to original message]