Bug #15532: Fails to connect to MSSQL server

From: Date: Wed, 13 Feb 2002 01:20:45 +0000
Subject: Bug #15532: Fails to connect to MSSQL server
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-218@lists.php.net to get a copy of this message
From:             brett@infopop.com
Operating system: Win2k Server
PHP version:      4.1.1
PHP Bug Type:     Compile Failure
Bug description:  Fails to connect to MSSQL server

<?
$hostname = "servername";
$username = "Threads";
$password = "Threads";
$dbName = "Threads";

mssql_connect($hostname,$username,$password) or DIE("DATABASE FAILED TO
RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");

$query = "SELECT * FROM users";

$result = MSSQL_QUERY($query);

$number = MSSQL_NUM_ROWS($result);

$i=0;

if ($number == 0) :
	print "No data?";
elseif ($number > 0) :
	print "Data:";
	while ($i < $number) :
		$name = mssql_result($result,$i,"Name");
		print $name;
		print "";
		$i++;
	endwhile;
endif;
?>

Effectively this script fails to connect to the database:

Fatal error: Call to undefined function: mssql_connect() in
e:\apache\apache\htdocs\mssql_connect.php on line 7

The php_mssql.dll has been placed in both the includes and the
WINNT\system32 directories and those lines have been uncommented to
include those files.

the php.ini file has had it's included path altered correctly for DOS
pathing

Apache has been stopped and restarted between changes.

Thank you!
-- 
Edit bug report at http://bugs.php.net/?id=15532&edit=1
-- 
Fixed in CVS:        http://bugs.php.net/fix.php?id=15532&r=fixedcvs
Fixed in release:    http://bugs.php.net/fix.php?id=15532&r=alreadyfixed
Need backtrace:      http://bugs.php.net/fix.php?id=15532&r=needtrace
Try newer version:   http://bugs.php.net/fix.php?id=15532&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=15532&r=support
Expected behavior:   http://bugs.php.net/fix.php?id=15532&r=notwrong
Not enough info:     http://bugs.php.net/fix.php?id=15532&r=notenoughinfo
Submitted twice:     http://bugs.php.net/fix.php?id=15532&r=submittedtwice



Thread (2 messages)

« previous php.bugs (#218) next »