我正在尝试使用 Microsoft Access 数据库进行演示项目,我正在考虑在 CodeIgniter 或 CakePHP 中进行该项目。忽略使用 Microsoft Access 可能存在的愚蠢行为,我无法准确地弄清楚连接字符串如何与框架的数据库设置相对应。在直接 PHP 中,我可以使用以下代码连接到 Access 数据库:
$db_connection = odbc_connect(
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\path\\to\\db.mdb",
"ADODB.Connection", "", "SQL_CUR_USE_ODBC"
);
这些字符串如何与 Code Igniter 数据库设置相对应?这似乎不太有效:
$db['access']['hostname'] = "{Microsoft Access Driver (*.mdb)}";
$db['access']['username'] = "ADODB.Connection";
$db['access']['password'] = "";
$db['access']['database'] = "\\path\\to\\db.mdb";
$db['access']['dbdriver'] = "odbc";
$db['access']['dbprefix'] = "";
$db['access']['pconnect'] = TRUE;
$db['access']['db_debug'] = TRUE;
$db['access']['cache_on'] = FALSE;
$db['access']['cachedir'] = "";
$db['access']['char_set'] = "utf8";
$db['access']['dbcollat'] = "utf8_general_ci";
尝试设置 DSN 并更改为以下内容:
$db['access']['hostname'] = "<dsn name>";
$db['access']['username'] = "";
$db['access']['password'] = "";
$db['access']['database'] = "<dsn name>";
CodeIgniter 文档中还有一个部分介绍了连接字符串:
http://codeigniter.com/user_guide/database/connecting.html http://codeigniter.com/user_guide/database/connecting.html
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)