View Full Version : PHP and MS SQL help needed.
08-27-2009, 08:41 PM
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?
NOTE: This is a fresh WAMP installation, newly downloaded and installed, and running PHP 5.3.
08-27-2009, 08:49 PM
That's the official PHP download, the php_mssql.dll is in the ext folder
08-27-2009, 08:53 PM
Did you read these notes?
08-27-2009, 08:58 PM
EDIT: No-such-luck, see next post.
08-27-2009, 09:40 PM
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?
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?
08-28-2009, 06:32 PM
Previous posts edited for clarity. Please review.
08-31-2009, 05:37 PM
PLEASE HELP !
08-31-2009, 05:56 PM
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).
08-31-2009, 06:58 PM
ew is right.
(I do already have it all written.)
Are there any other suggestions ??
With fingers crossed,
08-31-2009, 09:39 PM
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.
09-01-2009, 05:54 PM
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).
... you have copied ntwdblib.dll into your PHP install folder...
... At this point, I'd have to sit down at your keyboard.
I'll make the coffee :D
But seriously, thanks a bunch.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.