Hi,
IE and Netscape works diffenntly when used on a LAN. IE can/will pass
along your user identification information (if you are validated on the
network) This information will be used when you are contacting the sql
server.
Netscape does not send this extra information from the client to the
server.
To avoid this you should make sure your IIS user (the user that runs the
server demon) has access to the SQL server or you should use SQL servers
internal authentication. This might require re-configuration of the sql
server.
- Frank
> PHP Warning: MS SQL error: Unable to connect: SQL Server is
> unavailable or does not exist. (severity 9) in pathtofile\test.php4 on
> line 5
> PHP Warning: MS SQL: Unable to connect to server: 192.168.168.168 in
> pathtofile\test.php4 on line 5
>
>
> Why would I get these errors when I access a php file with Netscape 7
> and not when I access the same file with IE 6. I can switch back and
> forth as fast as I can and every request from IE works and every
request
> from Netscape fails. So it isn't a timing issue where the SQL Server
is
> going away for a second.
>
> If I continue the file and try to run queries to test the connection,
> the queries verify the errors. IE They don't run when requested by
> Netscape 7 and they do when requested by IE 6
>
> This is my setup
>
> IIS 5.0
> -Virtual Site
> -Directory security: basic
> -Anonymous Access: Disallowed
> -PHP 4.2.3
>
> Database
> -MS SQL 2000
>
> Client Netscape 7.0
> Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.1)
Gecko/20020823
> Netscape/7.0
>
> <?
> $username = 'dbusername';
> $password = 'dbpassword';
>
> $connection = mssql_connect('192.168.168.168',$username,$password);
> ?>
>
>
>
> Thank you
> Charles Killmer
> Windows 2000 Server PHP 4.2.3 IIS 5.0
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
