duandaodao6951 2019-03-28 10:39
浏览 463

无法使用PHP连接到MS Access DB:SQLSTATE [IM002]

I am trying to get data from a MS Access DB (.mdb) but I'm getting:

échec de connexion: SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié.

English:

connection failure: SQLSTATE [IM002] SQLDriverConnect: 0 [Microsoft] [ODBC driver manager] data source not found and driver name unspecified.

I have : Office 365 Business 32-bit installed. Already installed the latest Access Database Engine 32-bit. Uncommented " extension=pdo_odbc " in php.ini. Added the "Microsoft Access Driver" to the list of drivers.

$dbName = 'C:\wamp64\www\Test\Workgroup.mdb';
if (!file_exists($dbName))
{
    die("Could not find database file.");
}
else
{
    try{
        //$dbName = 'Workgroup.mdb';
        $cnx = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; Dbq=$dbName; Uid=; Pwd=;");
        echo "connected successfully";
        return $cnx;
    }
    catch(Exception $e){
        die ("failed to connect: " . $e->getMessage());
    }
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Pwm双极模式H桥驱动控制电机
    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题