[BNM] [bnm] SQL Server and other conundra

[paul perrin]

Like you say - hard to diagnose without good info...

As it does connect sometimes, syntax and security seem to be ruled out as
problems.

First thing to work out is whether it is PHP not asking for the connection,
or SQL not providing it. I'd start by looking at the log files on the SQL
server for clues (if you can see lots of failed connections the reason may
be obvious); if you can only see good connections then it maybe the PHP side
of things, or the network itself (any chance you are flooding the network?).

To check the network I would be thinking about running a packet sniffer
(there are some good 'free trials' out there), if that doesn't give an
answer, but points at PHP (i.e. connection requests not showing on the
network) then maybe think about a reinstall.

Maybe point the PHP to a different instance of SQL Server as another way of
checking where the problem is; and/or running the PHP on another box and
pointing that at the existing SQL Server - if things are different in any of
these cases, then you should have an indication of where you really need to
be looking.

Regards

Paul /)/+)

On 16/04/07, Nick Taylor <nick at tangerineworks.com> wrote:
>
>
>
>
> > Nick Taylor <nick at tangerineworks.com> wrote:
> >
> >> Ok, one for all you techie chaps out there...
> >>
> >>
> >> How come when I try to connect to a sql server db with PHP via IIS
> using
> >> this...
> >>
> >> $s=mssql_connect('localhost', 'user', 'pwd')  or die("Couldn't connect
> >> to SQL Server on ".'localhost');
> >>
> >> [...]
> >
> > What's the connection like with Management Studio? I don't know anything
> about
> > PHP but you can eliminate a few things with that.
>
> I think it's ok - if that's the thing that my client uses... I
> personally don't have access to anything except ftp and the relevent
> passwords etc.
>
> It's like trying to communicate with an alien via morse code. In the dark.
>
> --
>
> BNM Subscribe/Unsubscribe:
> http://lists.wessexnetworks.com/cgi-bin/mailman/options/bnmlist/
> BNM info/archives:
> http://www.brightonnewmedia.org/
>
> BNM archive search:
> http://www.roddis.org/bnm/search.php
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>