Skip to Content.
Sympa Menu

freetds - Re: PHP, FreeTDS & Microsoft SQL Server 7, best methods?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP, FreeTDS & Microsoft SQL Server 7, best methods?
  • Date: Fri, 3 Sep 1999 09:27:32 -0400 (EDT)




On Fri, 3 Sep 1999, Karl Pielorz wrote:

> Brian Bruns wrote:
>
> > --with-sybase will link with dblib, you may also try --with-sybase-ct (I
> > think) which is ctlib. I have not personally spent much time on it, but
> > much more activity has gone into ctlib as of late than dblib, so it may be
> > working better. Also what version of PHP are you using, we've had reports
> > of the 4.0betas having problems (which is on the todo list).
>
> Good point, I should have supplied more details... I'm running PHP 3.0.12,
> on
> FreeBSD 2.2.7.
>
> > ctlib will also avoid the name-space clash
>
> That would be handy...
>
Now, I make no claims to the reliability of that set up since I haven't
tried it myself beyond a simple select-type script. But, I've had reports
that it is working, so take it for what it's worth.

> > Yes, it's very beta at the moment, but we've made some good progress
> > lately. What version of FreeTDS are you using? It may be wise to grab a
> > recent snapshot.
>
> I think I've got 0.46, I'll double check, and with the above suggestion I'll
> also try switching to ctlib as well...
>
> > I will test PHP persistant connects this weekend and see what I can find.
> > Version information and a PHP script that replicates the problem would be
> > most helpful.
>
> I think I may have improved this situation somewhat... It looks like there
> were a lot of very stale connections on the server, which has recently been
> shutdown and started up again... It looks like with 2 servers it's now
> holding it's own (i.e. I have 2 logged in users on the MS Side as well, not
> seven like last time :)...
>
> I would have thought that all the connections, so long as their coming from
> the same machine, with the same username and password - should count as 1
> 'licensed' connection on the MS side, but obviously not... (What a
> suprise!) -
> This may be where we've been screwing up... [I have 2 httpd's running, and 2
> logins from that machine now showing on the MS Console].
>

Connections are persistant within a process. One would imagine that when
apache goes to a thread model they will be persistant across the the
server, but that'll take some thread-safing within freetds and presumably
some work on PHPs part too. So, two apache children -> two processes ->
two connections.

> Thanks once again for your reply, when I first found FreeTDS there was some
> talk of it's support being a somewhat 'isolated', I've been reading the list
> for a while, and after our results here - I think it's worth us sticking
> with
> it...
>
> Regards,
>
> Karl
>

Cheers

Brian






Archive powered by MHonArc 2.6.24.

Top of Page