unosoft

This (attached) is my IIS log from one of the affected sites. It looks OK, right? [attachment deleted by admin]

I didn't make any changes at all on the server when the problems started. I can't find anything in the event log indicating an error. Taks monitor looks fine, lots of free resources. It is a MSSQL database, running several other sites without problems. Maybe it is hardware related? What will you recommend, chkdsk maybe? And some RAM testing software?

I have also tried "output_buffering = on" - but the problem still persists... Working fine for 1-2 minutes after resetting IIS - then it gets VERY slow again...

About a week ago, all my PHP sites began to resolve extremely slow. It takes up to 10 minutes, to load a simple page! Plain HTML pages seems to run fine... It is a Win 2K3 server, IIS 6.0 and PHP 5. I read somewhere that it might would help to turn on output_buffering. But in my php.ini file output_buffering is set to 4096 - so it is turned on. I tried to set it to 16192, but the problem persists. It helps to restart the IIS Admin Service - but only for a few minutes. Does anyone have an idea what might be wrong?

I solved this problem, by using odbc_connect() instead of sqlsrv_connect().. Have no idea why sqlsrv failed, but as long as I have a connection, I’m happy! odbc_connect() has problems returning results from some of my stored procedures, but i can live with that for now. - Tank you for your time!

I can connect to the database in classic ASP, using this connection (same server, different name): I tried this info in PHP, didn't work either - same error. <% Set oConNews = Server.CreateObject("ADODB.Connection") oConNews.ConnectionString = "Provider=SQLOLEDB;Server=WebSQL;UID=xxx;PWD=xxx;Database=dbname" oConNews.Open %>

I installed (MDAC) 2.8 - does that include the latest ODBC? The problem persists, after installing MDAC.

But the access is fine, when testing the ODBC connection, and furthermore, i can access the database using ASP. I have tried both "10.0.0.10", "10.0.0.10:1001" and "Zeus" - same error over and over again.

Hmm just checked the ODBC version on the other server.. It is actuallyu older! The dev server is using ODBC driver 03.86.1830

Ok, i downloaded the package, but ODBC is still the same version. Do i need top upgrade it seperatly somehow?

I made a site using PHP, on my development server. But on the live server, I have problems getting a database connection. Error: Connection could not be established. Array ( [0] => Array ( [0] => IM002 [sqlSTATE] => IM002 [1] => 0 => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) ) I have set up ODBC, and testet the connection sucessfully! My ODBC is configured like this: Microsoft SQL Server ODBC Driver Version 03.86.3959 Data Source Name: Zeus Data Source Description: Server: Zeus Database: (Default) Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: No Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Data Encryption: No I'm using this PHP code: <?php function DB_Conn_Zeus ($dbname, $tsql) { $serverName = "10.0.0.10\Zeus,1001"; $uid = "xxx"; $pwd = "xxxxxx"; $connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>$dbname); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { //echo "Connection established.<br />"; } ...... Can anyone see where the problem is? I can ping the MSSQL server, and classic ASP seems to work just fine.