none
Error "Call to Undefined Function sqlsrv_Connect"

    질문

  • I have installed Microsoft drivers for MSSQL for connecting through php, Places the php_sqlsrv_53_ts_vc9.dll in the php extensions directory, Also have checked it from thr php extensions. But when i execute the following code, it gives error "Call to undefined function sqlsrv_Connect".

    <?php
    $serverName = "(local)";
    $connectionInfo = array( "Database"=>"test");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);

    if( $conn )
    {
         echo "Connection established.\n";
    }
    else
    {
         echo "Connection could not be established.\n";
         die( print_r( sqlsrv_errors(), true));
    }
    sqlsrv_close( $conn);
    ?>

    I am using Windows 7, Wamp Server 2.2d, and php 5.3.10

    Please any body help.


    madeeha


    2012년 3월 2일 금요일 오후 4:05

답변

  • That's interesting. The windows.php.net site says specifically that you should use the VC6 version of PHP with Apache. I'm not sure why the VC9 version of PHP is being installed with WAMP.

    The compiler version for PHP should match that of the driver. I would suggest manually installing PHP and manually configuring Apache or IIS. That way, you can make sure you have the right version of everything you need.

    -Brian


    This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan

    2012년 3월 2일 금요일 오후 7:51
    중재자

모든 응답

  • Madeeha-

    With Apache, you should be using the VC6 build of the driver. So try installing/enabling php_sqlsrv_53_ts_vc6.dll and let us know what happens.

    -Brian


    This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan

    2012년 3월 2일 금요일 오후 6:44
    중재자
  • Same Error, "Call to undefined function sqlsrv_connect"

    madeeha

    2012년 3월 2일 금요일 오후 7:18
  • OK. Have you enabled the driver in your php.ini file?

    extension = php_sqlsrv_53_ts_vc6.dll

    And, you are using a thread-safe version of PHP, right?

    -Brian


    This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan

    2012년 3월 2일 금요일 오후 7:21
    중재자
  • yes i have enabled the extension in php.ini file..

    And really i dont know if i m using a thread safe or non thread safe, i m using Wamp server 2.2d, php 5.3.10, and apache 2.2.21


    madeeha

    2012년 3월 2일 금요일 오후 7:25
  • Look at the output of phpinfo. The Thread Safety property (enabled/disabled) will tell you about thread safety. If the sqlsrv extension is loading correclty, there should also be a section that shows configuration information. If that section isn't in the output, you'll need to check your PHP error log to get more detail about why the extension isn't loading.

    Hope that helps.

    -Brian


    This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan


    2012년 3월 2일 금요일 오후 7:33
    중재자
  • Thread Safety is enabled, And there is no section for msSqlsrv...

    And the Visual C++ 8.0 compiler , MSVC9  

    Should i use vc9 or vc6


    madeeha

    2012년 3월 2일 금요일 오후 7:39
  • That's interesting. The windows.php.net site says specifically that you should use the VC6 version of PHP with Apache. I'm not sure why the VC9 version of PHP is being installed with WAMP.

    The compiler version for PHP should match that of the driver. I would suggest manually installing PHP and manually configuring Apache or IIS. That way, you can make sure you have the right version of everything you need.

    -Brian


    This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/brian_swan

    2012년 3월 2일 금요일 오후 7:51
    중재자
  • There is a VC9 version of Apache available, I use it myself.  The WAMP people have probably built their own.

    • Please check whether you have installed WAMP 64 bit.  You need to install WAMP 32 bit, not WAMP 64 bit.

    If you need more help, please post the following information:

    • The top panels of your phpinfo, up to and including "apache2handler" section
    • The extensions section of php.ini


    Rob

    2012년 3월 6일 화요일 오후 3:48