Hi,
I have tried to connect php to "SQL Server 2005 CTP" on Windows 2000 without success:
<?
$server="localhost,1126";
$username="sa";
$password="kuba12tv";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("test",$sqlconnect);
$sqlquery="SELECT * FROM test;";
$results= mssql_query($sqlquery);
while ($row=mssql_fetch_array($results)){
echo $row['t_name']."<br>\n";}
mssql_close($sqlconnect);
?>
<?
$sqlconnect=odbc_connect("sqlncWin");
$sqlquery="SELECT t_name FROM test;";
$process=odbc_exec($sqlconnect, $sqlquery);
$result = odbc_result($process,"t_name");
echo $result;
}
?>
No error messages, nothing. The "SQL Server 2005 CTP" install checks out OK from its end.
Any thoughts?
Thanks
Tom Lawson