> 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
