Apache Friends Support Forum

Hello everyone, I need to know how do I run the SQL Server functions in php, just as it works on XAMPP.
Just install PHP and I can not run the extension php_mssql.php.
please help me.
sorry for broken English.

Open C:\xampp\php\php.ini and look for this line:

Code: Select all

;extension=php_mssql.dll

Remove the semicolon at the beginning and restart Apache

glitzi

thanks buddy for the reply, however, already tried that and still not resolved.
there must be some setting in xampp that causes the mssql functions.

hi friends,
I've installed xamp in windows for joomla. I've apache running. But mySql is not runinning. Its giving an error like, MySql started [Port 3306] Busy.... what could be reason for this. Pls tell me. I need to built a website.

@chanduramse
Your post is off topic in this MSSQL thread which is often referred to as hijacking - please open a new topic with your question about MySQL.
Thanks.

Hi all

I'm experiencing same problems

What I have done:

Enabled options in \xampp\php\php.ini:
extension=php_mssql.dll
extension=php_pdo_mssql.dll

Downloaded corresponding dll files from http:/*/www.dlldll.com and put them to \xampp\php\ext\ directory.

Problem: when I try to start Appache, I get following errors:





Finally, after clicking all those OK's, Apache and PHP works, but without MSSQL support..

After first error, I tried downloading and putting to the same directory file php4ts.dll, unfortunately this didn't solve the problem

ANY IDEAS?

I believe the existing MS SQL driver has been superseded by the following one:
http://www.microsoft.com/sqlserver/2005/en/us/php-driver.aspx
(The PHP.net MS SQL page for PDO references this link as well: http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx)

And in the latest version of XAMPP for Windows (1.7.4) I'm not noticing any MSSQL extensions whatsoever so hopefully the XAMPP folks have already noticed this and are trying to include the new SQLSRV driver (normal and PDO) for XAMPP 1.7.5+.

The PHP.net PDO page seems to be a little out of date regarding this since there is no page at the moment documenting the driver or anything (it seems to be all on Microsoft's website), including the API reference:
http://msdn.microsoft.com/en-us/library/cc296152(v=sql.90).aspx

Hopefully this might help somebody on the more recent versions of XAMPP .

hi! i have a same problem...
i already download from orware's

I believe the existing MS SQL driver has been superseded by the following one:
http://www.microsoft.com/sqlserver/2005/en/us/php-driver.aspx
(The PHP.net MS SQL page for PDO references this link as well: http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx)

And in the latest version of XAMPP for Windows (1.7.4) I'm not noticing any MSSQL extensions whatsoever so hopefully the XAMPP folks have already noticed this and are trying to include the new SQLSRV driver (normal and PDO) for XAMPP 1.7.5+.

The PHP.net PDO page seems to be a little out of date regarding this since there is no page at the moment documenting the driver or anything (it seems to be all on Microsoft's website), including the API reference:
http://msdn.microsoft.com/en-us/library/cc296152(v=sql.90).aspx

Hopefully this might help somebody on the more recent versions of XAMPP .

i already download the dlls and copy it into my '\xampp\php\ext'...
i already edit and add the extensions at php.ini file..

but when i want to use mssql server functions, apache still don't recognize it and still outputting :

Code: Select all

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\mssql\lib\SQLServer.php on line 5


if I check at the phpinfo(), the configure command says

cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--disable-isapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=D:\php-sdk\oracle\instantclient11\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet" "--with-mcrypt=static"

is it effecting connectivity to mssql??if so, how to change this configure command??

could anyone help me???:D

*sorry for my bad English...