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
//mssql.secure_connection = On
// Need to upload ntwdblib.dll from net
$myServer = “ISM\SQLEXPRESS”; // host/instance_name
$myUser = “sa”; // username
$myPass = “xoxoxo&#8243;; // password
$myDB = “dbtest”; // database name
// connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die(“Couldn’t connect to SQL Server on $myServer”);
// select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die(“Couldn’t open database $myDB”);
echo “You are connected to the ” . $myDB . ” database on the ” . $myServer . “.”;
?>

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…

    Where is the php.ini file located? Did you add the 'PHPRC' environment variable to point to this location?

    If you do a phpinfo(), can you verify that PHP is loading this php.ini file?

      Write a Reply...