CODEWITHSUNDEEP
phpsql-server
Dean-O
Dean-O

Reputation: 1153

how to get mssql_connect to work on windows 7

I have mssql_* functions working on my Ubuntu installation and want to duplicate this on my windows 7 box. I have installed wamp on the win7 box, but I cannot get it to see the mssql_* functions. I have read many posts about nothing is working. I have the ext directory properly set. I have extension=php_mssql.dll do not see the mssql section in phpinfo, but I do see sqlsrv section. I would like my prod and test environment to match.

Thanks in advance for any assistance Dean-O

Upvotes: 0

Views: 901

Answers (1)

Filippos Karapetis
Filippos Karapetis

Reputation: 5204

I just checked my local wampserver 2.1 installation, and although there's an option to enable the php_mssql extension, it's missing from the extensions directory.

You can try the FreeTDS extension, which supposedly works fine under both *nix and Windows.

The Moodle wiki specifies that the Microsoft SQL Server driver has "known problems":

WARNING: This driver has known problems and is therefore not suitable for any Moodle production servers.

and recommends the use of FreeTDS instead (by installing the php_dblib extension). Moodle is a known user of MSSQL, and a respected project, but they don't really specify what they mean by "known problems", so you can take this with a grain of salt...

http://docs.moodle.org/24/en/Installing_MSSQL_for_PHP

If FreeTDS doesn't work for you, you can try installing the official Microsoft drivers:

http://www.microsoft.com/en-us/download/details.aspx?id=20098

Upvotes: 2

Related Questions