I recommend anyone using ODBC to access MSSQL to use the php_mssql.dll. I have successfuly connected a test application and benchmarked with ab ( Apache Benchmar) 100000 hits without any errors !
-Mike On Thu, 14 Nov 2002, soff wrote: > Date: Thu, 14 Nov 2002 15:00:05 +0800 > From: soff <[EMAIL PROTECTED]> > To: David Elliott <[EMAIL PROTECTED]> > Cc: php-windows <[EMAIL PROTECTED]> > 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 的来信中提到: > > > 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 | > > _________________________| [EMAIL PROTECTED] | 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 > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
