I am trying to connect to SQL2000 from 2003Server-Web Edition. I am able to connect using ISQL and TCP/IP. I have configured the client network. I am using the same code that runs very successfully on Win 2000 Server.
There have been no problems bringing up the Win2003 Web Edition server using ISAPI, PHP4.3.4 and ODBC, except that performance is not what would expect if using mssql. Specifically, there are 2 odbc_fetch_array calls that take 2-3 SECONDS to execute. Usual page response is less than .1 seconds on the servers Win 2000 server (PHP and SQL2000). Any ideas?
