Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
完了php.iniphp_mysql.dll前面的分号去掉了,文件也考到WINDOWS下面去了
httpd.conf文件里也加了LoadFile c:\php\ntwdblib.dll
怎么我用PHP连接mssql连不上。。
老是报这个错误。。<?php
$ser ="220.*.*.*";
$db ='db';
$user="***";
$pass="*****";
$conn=odbc_connect("Driver={SQL Server};Server=$ser;Database=$db",$user,$pass) OR die("完了");
if($conn) printf ("Connected successfully");
$sql="select * from city ";
$result=odbc_do($conn,$sql)or die("query failed");
$row=odbc_num_rows($result);
$fetch = odbc_fetch_array($result);
print_r($fetch);
?>
完了php.iniphp_mysql.dll前面的分号去掉了,文件也考到WINDOWS下面去了
httpd.conf文件里也加了LoadFile c:\php\ntwdblib.dll
怎么我用PHP连接mssql连不上。。
老是报这个错误。。<?php
$ser ="220.*.*.*";
$db ='db';
$user="***";
$pass="*****";
$conn=odbc_connect("Driver={SQL Server};Server=$ser;Database=$db",$user,$pass) OR die("完了");
if($conn) printf ("Connected successfully");
$sql="select * from city ";
$result=odbc_do($conn,$sql)or die("query failed");
$row=odbc_num_rows($result);
$fetch = odbc_fetch_array($result);
print_r($fetch);
?>
$myServer = localhost; //主机
$myUser = sa; //用户名
$myPass = password; //密码
$myDB = Northwind; //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");
$myServer = localhost; //主机 报这行错误哦