PHP FreeTDS MSSQL连接出错,提供的参数不是有效的链接


Error in PHP FreeTDS MSSQL Connection, supplied argument is not a valid link

我正在使用PHP远程连接到我的MSSQL数据库,MSSQL和FreeTDS通过CentOS cPanel Hosting。

我遇到了这个错误,尝试了几个小时后无法修复。。。

Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in /home/mrcskncn/public_html/process.php on line 71
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in /home/mrcskncn/public_html/process.php on line 72

交易如下:

$dbc = mssql_connect($datasource, $datauser, $datapass) or die('Dam server!');
$selected = mssql_select_db($database, $dbc) or die('Dam db!');
$query_verify_account = "SELECT * FROM USER WHERE AccountID = '$Account'";
$qry = mssql_query($dbc, $query_verify_account);
$line = mssql_fetch_array($qry);
if (isset($line["AccountID"])) {
    echo "This username is not available.";
}

我该怎么办?

感谢

您需要在对mssql_query()的调用中切换参数

$qry = mssql_query($query_verify_account, $dbc);