Need help with MSSQL drupal on php 5.3.8 [Answered]RSS

2 replies

Last post Oct 12, 2011 12:36 AM by HCamper

  • Need help with MSSQL drupal on php 5.3.8

    Oct 03, 2011 01:02 PM|xxrsdsdk209|LINK

    I'm trying to setup Drupal to use MS SQL server 2005 using PHP 5.3.8 on Windows Server 2008 R2 64.

     

    After typing in the information into the form for connection details I get the following PHP error:

    Fatal error: Undefined class constant 'SQLSRV_ATTR_DIRECT_QUERY' in E:\inetpub\wwwroot\xx\dev\includes\database\sqlsrv\database.inc on line 59

     

    Any thoughts?

     

    Thanks

  • Re: Need help with MSSQL drupal on php 5.3.8

    Oct 03, 2011 10:18 PM|HCamper|LINK

    Hello,

    Start with http://learn.iis.net/page.aspx/765/improve-php-error-messages-in-iis-7/ use the guide to improve the PHP error messages.

    Since you have not posted PHP code causing the error at line 59 it could be many causes.

    Have you tried the Examples that came with the PHP SQL Driver ?

    You might check Brian Swans IIS team Blog

    The SQL Server Driver for PHP Forums 

     http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/3b38a360-047c-4b31-8531-6978d328f73d . May help.

     

    Martin

     

     

    Windows and Linux work Together IT-Pros
    Community Member Award 2011
  • Re: Need help with MSSQL drupal on php 5.3.8

    Oct 12, 2011 12:36 AM|HCamper|LINK

    Hello,

    Did you see this information for Drupal recently post:

    <div class=ForumPostContentText>The answer is a bug in the Drupal Sql Server driver that sits on top of Drupal's PDO implementation and Microsoft's Sql Server driver.</div> <div class=ForumPostContentText> Sending an empty command to sql server, </div> <div class=ForumPostContentText>which happens when the transaction savepoint functionality is called by Drupal, causes the fault. </div> <div class=ForumPostContentText>Details are here: </div> <div class=ForumPostContentText>http://social.technet.microsoft.com/Forums/en-US/sqldriverforphp/thread/2429f26b-287e-474e-8472-2c40f2a6ba10 </div> <div class=ForumPostContentText>thanks everybody for the ideas and help. </div>

    You stiil should post the php code and includes or list.

    Martin

     

     

    Windows and Linux work Together IT-Pros
    Community Member Award 2011