...

View Full Version : PHP and MS SQL help needed.



mOrloff
08-27-2009, 07: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?

~ Mo

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

Mwnciau
08-27-2009, 07:49 PM
http://uk.php.net/get/php-5.2.10-Win32.zip/from/a/mirror

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

Fumigator
08-27-2009, 07:53 PM
Did you read these notes?

http://us3.php.net/manual/en/mssql.installation.php

mOrloff
08-27-2009, 07:58 PM
PERFECT.
Thank you.

EDIT: No-such-luck, see next post.

mOrloff
08-27-2009, 08: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?
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?

mOrloff
08-28-2009, 05:32 PM
Previous posts edited for clarity. Please review.
(bump)

~ Mo

mOrloff
08-31-2009, 04:37 PM
Anybody ???
PLEASE HELP !

(bump)

~ Mo

Fumigator
08-31-2009, 04: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).

mOrloff
08-31-2009, 05:58 PM
ew is right.
(I do already have it all written.)

Are there any other suggestions ??

With fingers crossed,
~ Mo

Fumigator
08-31-2009, 08: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.

mOrloff
09-01-2009, 04: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...
Yup.


... At this point, I'd have to sit down at your keyboard.
I'll make the coffee :D


But seriously, thanks a bunch.
~ Mo



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum