Sorry for the late reply to this, but if you were to move to MS SQL I'd 
highly recommend using FreeTDS ( to access the database 
from PHP. Due to the lack of an MS SQL client library in Mac OS X I have 
to use FreeTDS to contact another MS SQL server ( I use MySQL myself ). 
Setup was very easy, you just build FreeTDS and then configure PHP using 
--with-sybase-ct=/path/to/freetds. Then you can use the mssql_* group of 
functions to access the database.

Or you could use ODBC... but I was never able to get that to work 
correctly, and the general consensus seems to be that ODBC is slow.

On Saturday, January 12, 2002, at 03:24 PM, Boaz Yahav wrote:

> Hi
> I'm planning to move my site (Very successful / high traffic Auctions
> site) from MySQL to MSSQL Server 2000.
> I was wondering if anyone has done this move and if there are any pit
> falls to notice.
> 1. Is ODBC the only way to work from a Solaris / Apache / PHP 4 machine
> to a Win2K / SQL Server 2000?
> 2. What could be the performance cost (if any).
> 3. Are there any special points that need to be taken into consideration
> on either side?

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to