This is true for the Win32 version of the mssql ext, which uses the unsupported DB-Library. On Linux, the mssql ext (it is actually the sybase ext) use FreeTDS. However, you should use FreeTDS version 0.61. Unfortunately all of these solutions have issues that may or may not give you problems. For example, only the DB-Library mssql ext supports stored procedures, but you cannot use it to read real, ntext or varchar(>255) data fields. The FreeTDS mssql ext returns NULL data as empty strings, and cannot read uniqueidentifier and sql_variant data fields. While the odbc ext's function set is the same on all platforms, this is not hhe case for the mssql ext. The DB-Library and FreeTDS mssql ext's are not completely compatible. The odbc ext on Linux requires you to install an ODBC driver manager and an ODBC driver for MS SQL Server. Since Microsoft does not make such software for Linux, you will have to acquire a third party open source or commercial solution. On Linux I would use mssql, and on Windows the choice depends on the type of data you need to access. In regards to the latter, you probably should use IIS/.NET for this purpose and not PHP. -- bob On Tue, 20 May 2003, Ingmar Schumann wrote: > but mssql functions can't handle all MSSQL Server datatypes! > mssql error severity 16 - is what you can get sometimes > > > ingmar > > ----- Original Message ----- > From: "Peter Misun" <misun@microstep-mis.com> > To: <php-db@lists.php.net>; "Muammer Yuzuguldu" <myuzuguldu@hotmail.com> > Sent: Tuesday, May 20, 2003 3:28 PM > Subject: Re: MSQL OR ODBC > > > > > > i'm using php on win > > difference is clear - using mssql functions is much more faster than using > odbc functions - odbc is really slow when manipulating lots of data > > so, don't use odbc, if there is any other way > > > > 5o > > > > > > Muammer Yuzuguldu wrote: > > > > > I am programmin MS SQL Server 2000 with php. What is the advantages of > using > > > MSSQL functions or odbc functions while programming MS SQL Server with > > > php?(php running at Linux server) > > > > > > _________________________________________________________________ > > > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > > > http://join.msn.com/?page=features/junkmail > > > > -- > > > > Mgr. Peter Misun > > MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia > > tel: +421/ 2/ 602 00 127, 111, fax: +421/ 2/ 602 00 180 > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
