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 | > _________________________| 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