note 23121 rejected from function.mssql-connect by spic
| From: | spic@php.net | Date: | Mon, 16 Sep 2002 07:51:17 +0000 |
| Subject: | note 23121 rejected from function.mssql-connect by spic | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-36729@lists.php.net to get a copy of this message | ||
I have a problem, I already set up and copy all necessary .dll(s) in c:\winnt\systems32 directory
and still it didn't work.Is thier anything lacking in my php code?I downloaded and install
php-4.2.1-installer.exe from www.php.net. Also I already uncomment the extension=php_mssql.dll in
php.ini file and I copy already ntwdblib.dll in my systems file. Just take a look at my code below
and see if thiers something wrong.
<?
$hostname="clear"; //This is the localhost name
$username="ian"; //Real user name
$password="password"; //Sample password
$dbname="employee" //MS SQL server 7 Database Name
mssql_connect ($hostname,$username,$password);
mssql_select_db($dbName);
$query = "SELECT * FROM employee";
$result = MSSQL_QUERY($query);
?>
When I view it in the browser is gives an error meassage of
Fatal Error: Call to undefined function: mssql_connect()in c:\InetPub\wwwroot\php\phptest.php on
line 8
By the way, we are using IIS4 in winNT and we test it in the winNT server itself.