Re: Problems with System DSN
| From: | Frank M. Kromann | Date: | Tue, 26 Jun 2001 19:03:48 +0000 |
| Subject: | Re: Problems with System DSN | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-8061@lists.php.net to get a copy of this message | ||
Hi Thomas,
The problem you are seeing has to do with access to the remote directory. The webserver is normally
running as user IUSR_<machine name> and that user does not have access to the remote
directory.
- Frank
> Hello...
>
> I'm running an ApacheWebserver 1.3.20 with mod_ssl/2.8.4, OpenSSL/0.9.6a and
> PHP 4.0.6.
>
> My PHP scripts gets data from a Paradox 5.0 database currently placed on the
> same pc as the Webserver. I'm using a System DSN called "MXPROCESSDB" - and
> all works fine... But if I move the database to a different machine, and
> makes a remote directory to the database (using the same system DSN as
> before) I get the following error message when I try to connect..
>
> Warning: SQL error: [Microsoft][ODBC Paradox Driver] Unexpected error from
> external database driver (11270)., SQL state S1000 in SQLExecDirect in
> F:\TH-Web\inc\DB_Functions.php on line 11
>
> So the question is : Do I have to do something special on the file server
> like installing paradox drivers or where is it it goes wrong...
>
> Both machines are NT4 Workstations so maybe the problem could be user
> authentication problems - I do not know.
>
> Has anyone experienced the same problems ??
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>