PHP and MS SqlServer - help

[kark_1999]

I have found many references on this site and the web to this issue, and I believe that I have done what is required, yet I can't get this to work. I always get....
Fatal error: Call to undefined function: mssql_connect()

If I run the following....

if(extension_loaded("mssql")) {
echo "MSSQL Loaded";
}
else {
echo "MSSQL not loaded";
}

... it will return "MSSQL not loaded".

I have PHP Version 4.3.6, running on WinXP Pro and Apache Server.
I have done the following based on comments I have seen in related threads:

1) uncommented extension=php_mssql.dll in the php.ini file.
2) restarted Apache
3) copied the php_mssql.dll to my Windows/system32 folder
4) restarted Apache
5) restarted my pc

Still no luck. Does anyone have a suggestion?

Thanks

[kark_1999]

found this on php.net...
"To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS should be compiled using --enable-msdblib.
"

What the hell does that mean? Does it mean I need to reinstall PHP in some strange way? Can't find any real explanation of this.

Any help would be great!

[Bismuth]

i also encountered such problem but what i did is to find the php_mssql.dll that fits my php version. try download the php_mssql.dll in this link http://kromann.info/php4.php if that would not loaded again try upgrade your php to 4.3.7/8.

Hope this can help.

[hasin]

Most probably u dont have Mssql extension enabled in ur php.ini. Open php.ini , find extension section and uncomment this line as

Previous : ;extension=php_mssql.dll
make it to : extension=php_mssql.dll //remove the semi colon

Thnx

[kark_1999]

thanks. however, as you can see that was the first thing i tried...

1) uncommented extension=php_mssql.dll in the php.ini file.

i'm going to try to upgrade to 4.38

[lmurillo]

The same stuff happened to me. But i'm using PHP5 with IIS.

This could resolve your problem.

You should put the path to the extensions (happened that i had them in other partition than php instalation partition)
So, put this on the php.ini file.

extension_dir = c:\PHP\extensions

make sure you have uncommented this part
;extension=php_mssql.dll

remove the semi colon

And i changed the enviroment variable PATH, adding the path of PHP.

c:\PHP\;

YES, with the \ and with semicolon (😉

[kark_1999]

thanks man. Actually I just finished installing PHP 4.38, and after much tweaking, it appears to be working.