警告:sqlsrv_query(）要求参数1为resource，给定字符串

设置

MS IIS服务器

MSSQL数据库服务器

PHP

错误

Warning: sqlsrv_query() expects parameter 1 to be resource, string given in C:'inetpub'wwwroot'creating_new_table.php on line 36
Table creation failed with error:'n
Fatal error: Call to undefined function sqlsrv_get_last_message() in C:'inetpub'wwwroot'creating_new_table.php on line 39

代码

$serverName ="NAME'SQLEXPRESS";
$usr="sa";
$pwd="pasw";
$db="DBNAME";
$connectionInfo = array("UID" => $usr, "PWD" => $pwd, "Database" => $db);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if( $conn )
{
    echo "Connected";
}
else
{
    echo "Error";
    die( print_r( sqlsrv_errors(), true));
}
$sql = "CREATE TABLE fyi_links ("
    . " id INT NOT NULL VARCHAR (6)" 
    . ", url VARCHAR(80) NOT NULL"
    . ", notes VARCHAR(1024)"
    . ", counts INT"
    . ", time DATETIME"
    . ")";
$res = sqlsrv_query($sql,$conn);
if (!$res) {
    print('Table creation failed with error:'n');
    print("   ".sqlsrv_get_last_message()."'n");
}
else {
    print("Table fyi_links created.'n");
}  
mssql_close( $conn);

连接很好，但我的创建表脚本出现了问题。