$odbc = true;
$hostname = "(local)";
$dbuser = "sa";
$dbpasswd = "sa";
$dbname = "Northwind";if(!$odbc){
//使用mssql库,连接sql server数据库
$conn = @mssql_connect($hostname,$dbuser,$dbpasswd) or die( "无法连接数据库服务器! ");
$db = @mssql_select_db( $dbname, $conn) or die( "无法连接数据库! "); $sql = "select * from Employees";
$result = @mssql_query($sql, $conn);
while($row = @mssql_fetch_array($result)){
echo $row['FirstName']."<br>";
}
@mssql_free_result();
@mssql_close();
}else{
//使用ODBC连接sql server数据库
$connstr = "Driver={SQL Server};Server=$hostname;Database=$dbname";
if ( !odbc_connect($connstr,$dbuser,$dbpasswd,SQL_CUR_USE_ODBC)){
echo "Couldn't connect to SQL Server on $hostname";
}else{
echo "Connect successfully!<br>";
}
}使用mssql库,连接sql server数据库连接失败, 使用odbc连接成功.
php.ini里面设置了 extension=php_mssql.dll
php_mssql.dll 也在 extension_dir 指定的目录中.
请问这是什么原因导致的?
$hostname = "(local)";
$dbuser = "sa";
$dbpasswd = "sa";
$dbname = "Northwind";if(!$odbc){
//使用mssql库,连接sql server数据库
$conn = @mssql_connect($hostname,$dbuser,$dbpasswd) or die( "无法连接数据库服务器! ");
$db = @mssql_select_db( $dbname, $conn) or die( "无法连接数据库! "); $sql = "select * from Employees";
$result = @mssql_query($sql, $conn);
while($row = @mssql_fetch_array($result)){
echo $row['FirstName']."<br>";
}
@mssql_free_result();
@mssql_close();
}else{
//使用ODBC连接sql server数据库
$connstr = "Driver={SQL Server};Server=$hostname;Database=$dbname";
if ( !odbc_connect($connstr,$dbuser,$dbpasswd,SQL_CUR_USE_ODBC)){
echo "Couldn't connect to SQL Server on $hostname";
}else{
echo "Connect successfully!<br>";
}
}使用mssql库,连接sql server数据库连接失败, 使用odbc连接成功.
php.ini里面设置了 extension=php_mssql.dll
php_mssql.dll 也在 extension_dir 指定的目录中.
请问这是什么原因导致的?
微软的sql-server要去微软的网站上下一个他们自己搞的php扩展。PHP自带的基本是没什么用了。
$odbc = true;
$hostname = "localhost\SQLEXPRESS"; // 主机名改为localhost + 数据库实例名
$dbuser = "sa";
$dbpasswd = "sa";
$dbname = "Northwind";
//使用mssql库,连接sql server数据库
$conn = mssql_connect($hostname,$dbuser,$dbpasswd) or die( "无法连接数据库服务器! ");
$db = mssql_select_db( $dbname, $conn) or die( "无法连接数据库! ");$sql = "select * from Employees";
$result = mssql_query($sql, $conn);
while($row = mssql_fetch_array($result)){
echo $row['FirstName']."<br>";
}
mssql_free_result();
mssql_close();
?>
无法连接数据库服务器!
http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx
http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx