extension_dir= not working! HELP

Anon

In my php.ini file..I have this;

extension_dir=c:\php\extensions

And the extension I'm trying to use is;

extension=php_mssql.dll

I get an error when trying to access a php page:

Unable to load dynamic library 'c:\php\extensions/php_mssql.dll' - The specified module could not be found.

I've played around with that path a bit, and copied the .dll all over my HD in hopes of getting it in the right path.

What am I doing wrong here.

BTW, the \ and / slashes in the error message is not a typo. That's exactly how it's displayed to me.

Anon

I was having the same problem yesterday.

But i solve it.

I use Php-4.0.6-win32.zip (4.8M😎extract it and put it to C:\php.
I copy php.ini-dist to C:\windows and rename it to php.ini

Then make the changes :
doc_root = c:\Inetpub\wwwroot
extension_dir = c:\php\extensions
extension=php_gd.dll

And everything was OK.
Try it with php_gd.dll and not with
php_mssql.dll just to check it

Anon

Well that worked. The gd.dll didn't spit up any errors, but when I tried the mssql.dll, I get the same error I did before..pluse this I forgot to mention that is actually on the web page (the first message was in a pop up window)

PHP Warning: Unable to load dynamic library 'c:\php\extensions/php_mssql.dll' - The specified module could not be found. in Unknown on line 0

The file is there. I doubled checked it. Could there be somethign wrong with it? Do I have all the libaries to use mssql functions?

Anon

Try this Link

http://www.php.net/manual/hu/ref.mssql.php

Go to User Contributed Notes they have same problems with some solutions like :

used the odbc calls
People seeling the mssql dll should be advised that php4 ships with
php_mssql70.dll

php_mssql70.dll works and is included with v4.01p2.
All you have to do is set the php.ini setting about the MS SQL extension as
follows:

[MSSQL]
extension=php_mssql70.dll ;
mssql.allow_persistent = On ;
allow or prevent persistent link

mssql.max_persistent = -1 ; maximum number of persistent links. -1 means
no limit

and make sure you have the extension dir pointed to your dir where your dll
files are. Then it should work...mine does.

ScottK wrote:

PHP Warning: Unable to load dynamic library 'c:\php\extensions/php_mssql.dll' - The specified module could not be found. in Unknown on line 0

The file is there. I doubled checked it. Could there be somethign wrong with it? Do I have all the libaries to use mssql functions?

Anon

The ODBC calls worked. For the life of me I could not get the mssql.dll to load. Oh well, all is well. Thanks for the help.

Anon

Hi Everybody,

I was also facing similar problem as ScottK. I tried the suggestions given by Zois but now if I set the value of doc_root = c:\Inetpub\wwwroot I am getting a CGI Error (The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are🙂 then if I comment it the mssql_xxx functions are not working and program is not throwing any error even.

My aim is to execute SQL Server 2000 Stored procedures from PHP.

Configration details:
1) OS is windows 2000 Advanced server running MS SQL Server 2000.
2) PHP running on machine where OS is windows 98 and web server is PWS.

Please help me.

Thanks in advance.

Regards,
Fiyaz.