使用PHP和PDO进行Microsoft访问 [英] Microsoft access with PHP and PDO

问题描述

我正在尝试连接到我的访问数据库，但是不能.我在带有IIS 7的Microsoft服务器2008上.我一直收到此错误消息. SQLSTATE [IM002] SQLDriverConnect:0 [Microsoft] [ODBC驱动程序管理器]找不到数据源名称，也未指定默认驱动程序.不确定我在做什么错.任何想法都会有所帮助.

I am trying to connect to my access database but cannot. I have on my Microsoft server 2008 with IIS 7. I keep getting this error message. SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Not Sure what I am doing wrong. Any ideas would help.

<?php
try {

 $conn = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\\staffing.mdb;Uid=Admin");

}
catch (PDOException $e) {
  echo $e->getMessage();
}
?>

推荐答案

如下所示编写连接对象并保存字符大小写.

Write the connection object like the following and save characters case.

$dbName = "E:\\path\\to\\db.mdb";
 $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};charset=UTF-8; DBQ=$dbName; Uid=; Pwd=;");

这篇关于使用PHP和PDO进行Microsoft访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！