arning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序, SQL state IM002 in SQLConnect in D:\webcome\renrenup.com\newfile.php on line 18
调试欢乐多
$myUser = wyz_newgou; //用户名
$myPass = wyz_168168; //密码
$myDB = netsales; //MSSQL库名
$s = @mssql_connect($myServer,$myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
$d = @mssql_select_db($myDB, $s) or die("Couldnt open database $myDB");
问题:不能连接mssql
2、你#2给出的代码不符合 php 语法约定(字符串应以引号括起)和屏蔽了错误信息(@),请修改并测试后再行提问
undefined function mssql_connect() 是因为你没有加载 php_mssql 扩展
Loaded Configuration File
$connection_string = 'DRIVER={SQL Server};SERVER=localhost,1433;DATABASE=netsales';
$user = 'wyz_newgou';
$pass = 'wyz_168168';
$connection = odbc_connect( $connection_string, $user, $pass ) OR die("??");
if($connection) printf ("Connected successfully"); $sql="select * from W_Member";
$result=mysql_query($sql); while ($row = mysql_fetch_assoc($result)){
echo "$row[M_id]";
}
?>
数据库连接成功(打印出Connected successfully)
但是,执行下面的语句时候出现以下错误:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\webcome\renrenup.com\newfile.php on line 31Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\webcome\renrenup.com\newfile.php on line 31Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\webcome\renrenup.com\newfile.php on line 33
求解!!!!!!!!!!!!!!!!!!
可以吗?
1.查询之前选择数据库: mssql_select_db('yourDB',$connection_string);
2.mysql_query 换成 mssql_query 试试.
....其他问题类似
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\webcome\renrenup.com\newfile.php on line 311)首先你要保证你链接sqlserver的方式正确,比如,连接地址,用户名,密码,数据库。Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\webcome\renrenup.com\newfile.php on line 312)检查你的mssql的配置Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\webcome\renrenup.com\newfile.php on line 333)检查连接数据库信息
怎么又用 mssql 函数操作呢?
....
$sql = "select yop 10 * from W_Member";
$result = odbc_exec($connection, $sql);
while ($row = odbc_fetch_array($result)){
print_r($row);
}
odbc有点复杂 操作数据库也有点问题!
如果你php.ini加载正确,如果你的mssql扩展已经开启并已经重启服务,还是如此,那么你可以试一试在apache配置文件末尾加入一段:
LoadFile "xxx/xxx.dll"
并重启服务试一试