Jump to content

unosoft

Members
 View Profile  See their activity

  • Posts

    11

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by unosoft

    PHP pages resolving extremely slow!

    in PHP Installation and Configuration

    Posted

    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?

     

    PHP pages resolving extremely slow!

    in PHP Installation and Configuration

    Posted

    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?

    Problems connecting to MSSQL (ODBC?)

    in Microsoft SQL - MSSQL

    Posted

    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

    %>

    Problems connecting to MSSQL (ODBC?)

    in Microsoft SQL - MSSQL

    Posted

    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.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.