Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 11 of 11
  1. #1
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts

    PHP and MS SQL help needed.

    I'm trying to get PHP to connect to MSSQL, but to no avail. I think I've narrowed down the problem though:
    I cannot find a copy of php_mssql.dll anywhere on this machine.
    I searched Google for a reliable download source, but the search hasn't been very fruitful.

    Does anyone have a good source for that, or any other pointers?

    ~ Mo

    NOTE: This is a fresh WAMP installation, newly downloaded and installed, and running PHP 5.3.

  • #2
    Regular Coder
    Join Date
    May 2006
    Location
    Wales
    Posts
    820
    Thanks
    1
    Thanked 82 Times in 79 Posts
    http://uk.php.net/get/php-5.2.10-Win.../from/a/mirror

    That's the official PHP download, the php_mssql.dll is in the ext folder

  • #3
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts

  • #4
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    PERFECT.
    Thank you.


    EDIT: No-such-luck, see next post.
    Last edited by mOrloff; 08-28-2009 at 05:33 PM. Reason: More details have surfaced.

  • #5
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    As it turns out, the DLL from the link is actually a different version, and PHP's not liking that.
    (Wrong module # or something like that.
    API = 20060613 vs PHP's API = 20090626.)

    I then tried to find it in the PHP 5.3 tarball, but I'm not seeing the required DLL in there.

    Am I way off base here, or just missing something?
    PLEASE HELP!

    Thanks-a-bunch,
    ~ Mo

    Note To Fumigator:
    Yep, I read them. And to the best of my understanding, I still need a compatible copy of this lib.
    Please correct me if I'm wrong.
    Additionally, do I understand that FreeTDS is only needed with Linux, and therefor I don't have to worry about that on this Win machine?
    Last edited by mOrloff; 08-28-2009 at 05:16 PM.

  • #6
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    Previous posts edited for clarity. Please review.
    (bump)

    ~ Mo

  • #7
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    Anybody ???
    PLEASE HELP !

    (bump)

    ~ Mo

  • #8
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    You may want to just use an ODBC driver rather than try to connect directly to mssql. Of course if you have code already written to use PHP's mssql functions, this suggestion is worthless, unless you want to convert (ew).

  • #9
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    ew is right.
    (I do already have it all written.)

    Are there any other suggestions ??

    With fingers crossed,
    ~ Mo

  • #10
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    So you've got the MS SQL Client Tools installed on your web server, and you have copied ntwdblib.dll into your PHP install folder. At this point, I'd have to sit down at your keyboard.

  • #11
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts
    Quote Originally Posted by Fumigator View Post
    So you've got the MS SQL Client Tools installed on your web server...

    I think so. I didn't do the MS SQL install ion that machine (and I've never worked with MS SQL prior to this).

    Quote Originally Posted by Fumigator View Post
    ... you have copied ntwdblib.dll into your PHP install folder...

    Yup.

    Quote Originally Posted by Fumigator View Post
    ... At this point, I'd have to sit down at your keyboard.

    I'll make the coffee


    But seriously, thanks a bunch.
    ~ Mo


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •