Good day!
I?m here again posting about my problem in the connection of mssql to php.
I have a problem in my connection in mssql to php. I tried my best to fix my problem. Here is some data I could give for better understanding.
I used:
SQL Server 2005 Express
SQL Server Management Studio Express
IIS 6.0
php 5.2.4
I configure my php.ini
I uncommented the following:
cgi.force_redirect = 0
doc_root = ?C:\Inetpub\wwwroot?
extension=php_mssql.dll
mssql.secure_connection = On
I change my ntwdlib.dll version from 2000.2.8.0 to 2000.80.194.0 because I found out that my older version of ntwdblib.dll was not work in sql server 2005 so I search for a ntwdblib.dll version that work on sql server 2005. So I deleted the old version and I put the new version of ntwdblib.dll in Windows/System32, php folder, and in php/ext folder.
And this is my information in my SQL Server:
Server Type: Database Engine
Server name: ISM\SQLEXPRESS
Authentication: Windows Authentication
Username: MR\Administrator —-This username was hiding
Password: —-Password was hiding
I have a big question in my mind and it is what username and password I could use in php to connect in mssql if the username and password is hiding. I try to use the sa and its password, but I don?t know if it is right. And also I try the MR\Administrator as username and the password is blank, but sad to say still I can?t connect.
Here is my code:
[php]
[/php]
After I run this code, the result is:
Fatal error:Call to undefined function mssql_connect() in C:\Inetpub\wwwroot\testconn.php on line 11
I don?t know what the problem is and what the configurations I need to do are.
I hope somebody can suggest or help me to fix my problem, because I really need to fix it.
Thank you in advance?