RE: [PHP-WIN] Re: php with mssql

PEAR::DB - time abstracting is never wasted!! Either that or rewrite the mssql_* functions to use FreeTDS (www.freetds.org) instead of dblib. (Just kidding - used freetds+mssql under Linux and it works extremely well, but not even sure it compiles under windows! It _would_ be nice to see better mssql support though...) Matt > -----Original Message----- > From: soff [mailto:soff@263.net] > Sent: 14 November 2002 07:00 > To: David Elliott > Cc: php-windows > Subject: [PHP-WIN] Re: php with mssql > > > Hello, > > I think changing to ODBC may cost lots of time :( > > ?ú?ú Wed, 13 Nov 2002 17:19:31 +0000 μ?à′D??Dìáμ1/2: > > > Hail soff > > > > On 13 November 2002 at 14:56:19 +0800 (which was 06:56 > where I live) soff > > rearranged electrons to get > > > > > I am trying to connect mssql with php, when I use > mssql_pconnect(), It > > > will fail to connect when the amount of visitors becomes > large. But, > > > when I use mssql_connect(), I can only run SELECT quern, while the > > > INSERT/UPDATE staments doesn't work. Can somebody tell me > why? thanks > > > and sorry for my poor English :P > > > > mssql_* uses the same library as used in mssql 6.5 (And > sybase however I > > could be wrong with this one) to say it is flaky is an > understatement. > > > > The following give problems. > > > > (1) access the mssql library and then do a header location > sometimes gives a > > CGI error. > > > > (2) Multi line SQL statements don't work. > > > > I suggest you either use ODBC or access the mssql interface > with a COM object > > (like ASP) > > > > -- > > Thank you for your time, > _______________________________________________ > > David | David Elliott | > Software Engineer | > > _________________________| list@elliott.uk.com | PGP Key > ID 0x650F4534 | > > | ..then Lancelot, Robin and I will jump out of the Rabbit. > | > > > > -- > Welcome to http://www.soff.net > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >