General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
connection from php to mssql
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
//mssql.secure_connection = On
// Need to upload ntwdblib.dll from net
$myServer = ?ISM\SQLEXPRESS?; // host/instance_name
$myUser = ?sa?; // username
$myPass = ?xoxoxo″; // 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 . ?.?;
?>
[/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?