#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Location
    SA, Centurion
    Posts
    355
    Rep Power
    12

    PHP Version 5.4.0 and MSSQL


    HI,

    I've upgraded from PHP version 5.2 to PHP version 5.4 and are not able to load / find mssql extension ?

    How do I use MSSQL in version 5.4 ??

    Is MSSQL not supported in this version or am I (hopingly) missing something ???

    Regards
    Dieter
    :P
  2. #2
  3. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,245
    Rep Power
    9400
    It's not "mssql" anymore. You have to find the SQLSRV extension (as published by Microsoft) but I'm not sure if it works for 5.4 yet.
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Location
    SA, Centurion
    Posts
    355
    Rep Power
    12
    Originally Posted by requinix
    It's not "mssql" anymore. You have to find the SQLSRV extension (as published by Microsoft) but I'm not sure if it works for 5.4 yet.
    Thanks, will go back to version 5.2
    :P
  6. #4
  7. Mad Scientist
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2007
    Location
    North Yorkshire, UK
    Posts
    3,661
    Rep Power
    4124
    I said I didn't like ORM!!! <?php $this->model->update($this->request->resources[0])->set($this->request->getData())->getData('count'); ?>

    PDO vs mysql_* functions: Find a Migration Guide Here

    [ Xeneco - T'interweb Development ] - [ Are you a Help Vampire? ] - [ Read The manual! ] - [ W3 methods - GET, POST, etc ] - [ Web Design Hell ]
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    3
    Rep Power
    0
    Originally Posted by Dieter
    HI,

    I've upgraded from PHP version 5.2 to PHP version 5.4 and are not able to load / find mssql extension ?

    How do I use MSSQL in version 5.4 ??

    Is MSSQL not supported in this version or am I (hopingly) missing something ???

    Regards
    Dieter
    You need use FreeTDS library. Its simple. Reffer link: ht tp://docs.moodle.org/24/en/Installing_MSSQL_for_PHP
    But library php_dblib.dll for php 5.4 I not found.

    I compiled it. You may download it here: ht tp://inethub.olvi.net.ua/ftp/pub/soft/programming/php/ms%20sql%20driver%20for%20%20php%205.4.10/
    Its compiled with VC9 with nts.
  10. #6
  11. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,245
    Rep Power
    9400
    I checked: SQLSRV 3.0.1 (released a bit before this thread was started) supports PHP 5.4 so I myself would just go with that.
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    3
    Rep Power
    0
    But! You need install Microsoft Native Client, and other people says: 3.0 drivers work ONLY with MS SQL 2012. Its true?
  14. #8
  15. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,245
    Rep Power
    9400
    True. Meanwhile (as far as I can tell) FreeTDS requires the .NET Framework 1.1.

    But it does support SQL Server <2008 and does work on Linux so there's that in its favor.
  16. #9
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    3
    Rep Power
    0
    No. Its work on Windows too. And work with MS SQL 2012 EXPRESS EDITION for me. I use PHP 5.4.10.

    ADD: And its don't need rewrite mssql_* functions to sqlsrv_*.

IMN logo majestic logo threadwatch logo seochat tools logo