Thanks for your help. My SQLServer version is Enterprise, there is no connection limit.
MDAC2.7 have no help as you said :( 您在 Wed, 13 Nov 2002 11:57:19 -0000 的来信中提到: > > 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. > > Just a thought - are you using the developer (ie MSDN subscription) version > of SQLServer? That limits connections to 10 - and since mssql_pconnect will > leave the connection open between hits you might be running out. > > mssql_connect issues - very strange. Profiler (from MSSQL client tools) is > your friend - you can actually see what the db thinks is going on. > > MDAC 2.7 probably won't change anything. The mssql_* functions are built on > top of the ancient dblib. That dates from the days when MSSQL was Sybase, > and hasn't changed since. It has it's own set of quirks and bugs that will > never now be fixed (limits on length of varchar, weirdness with > ansi_nulls... search the newsgroups) :( > > I now always use odbc_* functions (Win2K, PHP4.2.2, IIS) - just don't try to > open more than one result set at a time :-| > > Matt > -- Welcome to http://www.soff.net -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
