唉,我说temp只是一个例子,我的库名是C-Test,表名是exercise_C, 错误提示是:“unable to connect to ***(我的sql server)”接着是unable to select object exercise_C. 我加上mssql_select_db()后出现unable to select db "C",而不是“C-Test“
如果是下述: $linkid=mssql_connect($servername,"","");//16 $selectID=mssql_select_db("C-Test");//17 $query="select * from exercise_C";//18 $result=mssql_query($query,$linkid);//19 错误提示: Warning: MS SQL message: Could not locate entry in sysdatabases for database 'C'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in f:\wwwroot\1.php on line 17Warning: MS SQL: Unable to select database: C-Test in f:\wwwroot\1.php on line 17Warning: MS SQL message: Invalid object name 'exercise_C'. (severity 16) in f:\wwwroot\1.php on line 19
如果去掉17行的选择数据库,则只有 Warning: MS SQL message: Invalid object name 'exercise_C'. (severity 16) in f:\wwwroot\1.php on line 18
还有我配置sql server数据源时,只能用with winnt authentication using the network login ID ,而不能用with sql server authentication using a login ID and password entered by user,当我选择这一项时,用sa登陆或者administrator登陆时,说 connection failed SQLState:'28000' SQL Server Error:18456 [microsoft][odbc sql server driver][sql server]login failed for user 'sa'
错误提示是:“unable to connect to ***(我的sql server)”接着是unable to select object exercise_C.
我加上mssql_select_db()后出现unable to select db "C",而不是“C-Test“
<?php
$servername=; //MSSQL server服务器名
$username=; //数据库用户帐号,
$password=; //帐号口令
$dbname=; //数据库名,要求上面那个帐号对该库有SELECT权限
$strSql="select * from......";
$conn=mssql_connect("$servername","$username","$password");
mssql_select_db("$dbname", $conn);
$result=mssql_query($strSql); $row=mssql_fetch_array($result)
echo $row[1];
?>
$linkid=mssql_connect($servername,"","");//16
$selectID=mssql_select_db("C-Test");//17
$query="select * from exercise_C";//18
$result=mssql_query($query,$linkid);//19
错误提示:
Warning: MS SQL message: Could not locate entry in sysdatabases for database 'C'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in f:\wwwroot\1.php on line 17Warning: MS SQL: Unable to select database: C-Test in f:\wwwroot\1.php on line 17Warning: MS SQL message: Invalid object name 'exercise_C'. (severity 16) in f:\wwwroot\1.php on line 19
Warning: MS SQL message: Invalid object name 'exercise_C'. (severity 16) in f:\wwwroot\1.php on line 18
connection failed
SQLState:'28000'
SQL Server Error:18456
[microsoft][odbc sql server driver][sql server]login failed for user 'sa'