php – 使用ms访问数据库的Codeigniter
发布时间:2020-12-13 16:35:35 所属栏目:PHP教程 来源:网络整理
导读:所以我使用访问数据库(* mdb). 这个我的代码和成功连接: $db['test']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:blabla.mdb';$db['test']['username'] = '';$db['test']['password'] = '';$db['test']['database'] = 'Driver={Micro
所以我使用访问数据库(* mdb).
这个我的代码和成功连接: $db['test']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:blabla.mdb'; $db['test']['username'] = ''; $db['test']['password'] = ''; $db['test']['database'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:blabla.mdb'; $db['test']['dbdriver'] = 'odbc'; $db['test']['dbprefix'] = ''; $db['test']['pconnect'] = TRUE; $db['test']['db_debug'] = TRUE; $db['test']['cache_on'] = FALSE; $db['test']['cachedir'] = ''; $db['test']['char_set'] = 'utf8'; $db['test']['dbcollat'] = 'utf8_general_ci'; $db['test']['swap_pre'] = ''; $db['test']['autoinit'] = TRUE; $db['test']['stricton'] = FALSE; 现在我想从其他电脑使用accessdb. 所以我改变了主机名和数据库,但它失败了: $db['test']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=Z:blabla.mdb'; $db['test']['database'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=Z:blabla.mdb'; 我尝试这样做: $db['test']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=10.0.0.107shareblabla.mdb'; $db['test']['database'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=10.0.0.107shareblabla.mdb'; 但它仍然错误: Unable to connect to your database server using the provided settings. Filename: D:folderfoldersystemdatabaseDB_driver.php Line Number: 124 甚至我尝试连接php
问题是默认IIS IUSER无法通过网络共享访问文件.
解决方法在这里详细说明: http://support.microsoft.com/kb/207671. 我强烈建议使用SQL Server(如果没有别的),而不是访问文件 – 您将获得一个更好的体验,您将能够更容易迁移,随着站点扩展,如果需要. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |