[BNM] [bnm] SQL Server and other conundra

[paul perrin]

Ok... caching, threads, leaks...

Is there a pattern in the success/failure -- specifically does the first
call (after a reboot/restart) always work (or always fail)? or is it random?
If it always works first time, then it may be that PHP is keeping the
connection (and returning it later) but it has become corrupted in some
way, or MSSQL might have closed it for some reason. I don't know how/where
PHP caches these connectios so can't actually suggest a solution for that...

Maybe change the 'die' to open with 'newlink' set to true, and only die if
that fails too? Or keep _pconnect as a permanent solution...

Regards

Paul /)/+)

On 16/04/07, Nick Taylor <nick at tangerineworks.com> wrote:
>
>
>
> hmm... mssql_pconnect seems to work fairly reliably.
>
>
>
> > 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
> >>
> --
>
> 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
>