Ik probeer via PHP een MS SQL database te benaderen. Ik gebruik hiervoor:
<?
$hostname = "127.0.0.1:1433";
$username = "William de Kreek";
$password = "";
$dbName = "Northwind";
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.") ;
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "SELECT * FROM Categories";
$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;
?>
Ik krijg DATABASE FAILED TO RESPOND en
Warning: MS SQL message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in c:\www/index.php on line 39
The user is bekend in SQL Server en heeft rechten op Northwind..
Bovendien kan ik maar weinig docu vinden over PHP in samenwerking met SQL Server helaas
<?
$hostname = "127.0.0.1:1433";
$username = "William de Kreek";
$password = "";
$dbName = "Northwind";
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.") ;
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "SELECT * FROM Categories";
$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;
?>
Ik krijg DATABASE FAILED TO RESPOND en
Warning: MS SQL message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in c:\www/index.php on line 39
The user is bekend in SQL Server en heeft rechten op Northwind..
Bovendien kan ik maar weinig docu vinden over PHP in samenwerking met SQL Server helaas
:strip_exif()/u/14220/tweakers_na_rotate.gif?f=community)
/u/1830/acm.png?f=community)
Dit topic is gesloten.