php - 警告 : odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Question

我已将 Ms Access 数据库连接到 PHP 文件。 PHP文件报错

"Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager]

Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\wamp\www\PI\Connection.php on line 3".

连接.php

<?php
$con = odbc_connect("PIInstitute","","");
if($con){
    echo "Connected";
}else{
    echo "Failed";
}
?>

Answer 1

调用 odbc_connect() 时需要指定驱动程序，如下所示:

$conn =  odbc_connect ( "Driver={SQL Server};Server=$servername;Database=$dbname;", $username, $password ) or die ( "Connection failed: " . $conn );

您可以在此处找到有关 odbc_connect() 的更多信息:http://php.net/manual/en/function.odbc-connect.php