MSSQL SQLSERVER & XAMPP

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MSSQL SQLSERVER & XAMPP

Postby diego.araujo » 21. February 2011 19:58

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.
diego.araujo
 
Posts: 2
Joined: 21. February 2011 17:34

Re: MSSQL SQLSERVER & XAMPP

Postby glitzi85 » 06. March 2011 15:13

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: MSSQL SQLSERVER & XAMPP

Postby diego.araujo » 15. March 2011 20:24

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.
diego.araujo
 
Posts: 2
Joined: 21. February 2011 17:34

Re: MSSQL SQLSERVER & XAMPP

Postby chanduramse » 16. March 2011 10:56

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
 
Posts: 1
Joined: 16. March 2011 10:48

Re: MSSQL SQLSERVER & XAMPP

Postby Sharley » 16. March 2011 11:06

@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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: MSSQL SQLSERVER & XAMPP

Postby NareZ » 05. April 2011 22:23

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:

Image
Image
Image

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?
NareZ
 
Posts: 2
Joined: 28. June 2007 14:40

Re: MSSQL SQLSERVER & XAMPP

Postby orware » 12. April 2011 01:54

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 :-).
orware
 
Posts: 4
Joined: 01. July 2008 18:22

Re: MSSQL SQLSERVER & XAMPP

Postby moo.tensai » 18. December 2011 14:31

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...:D
moo.tensai
 
Posts: 1
Joined: 18. December 2011 14:24
Operating System: Win 7 Ultimate x86 (32 bit)


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 131 guests