FreeTDS

Anon

I'm expecting to move from ASP technology (Microsoft) to PHP ... good news. But, I don't want to move, in the same times, the databases and so I want to keep my MSSQL databases. The only solution at this time (exept ODBC which is too slow) is to use Free-TDS. But I don't trust at all this technology. So could someone give me his opinion concerning Free-TDS, TDS, or other technologies to connect MSSQL to PHP.
Thnaks a lot.

Eric

Anon

I use freetds here, to talk to MSSQL-2k - it works pretty well in most cases but it does seem to crash if you ask for extreme queries - i.e 1.5M rows all contaning over 64k data.

Most stuff is ok though, and it seems to be quite fast.

Can be a bit of a bugger to install though.

Anon

We have been using FreeTDS in a production
environment for 4 months with absolutely no
problems. Fast? You bet it is fast. I was
shocked at just how fast it would connect and
retrieve data.

We are using it with PHP 4.06 on RedHat linux.

lance

Anon

Thanks Danny.
I'm already working with it. Seems be te be very fast (too fast perhaps !). But I couldn't afford for my buisiness any crash or DB locking. So, it seems that FreeTDS is not the right solution for me.

You're right, it's a bit of bugger to install ...

Eric

Anon

Thanks Lance. As say to Danny, it seems very very fast (may be faster than ADO !) but when retrieve big data, it seems that FreeTDS crash often. May be I'll try Sybase TDS ...

Thanks ... Eric