Re: Re: MSQL OR ODBC

yes, you are rigth, I forgot to write that ingmar ps: please excuse my english.... ----- Original Message ----- From: "Robert Twitty" <rtwitty@neutron.ushmm.org> To: "Ingmar Schumann" <office@buddelflink.de> Cc: <php-db@lists.php.net> Sent: Tuesday, May 20, 2003 5:12 PM Subject: Re: [PHP-DB] Re: MSQL OR ODBC > 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: [PHP-DB] 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 > >