douliang2935 2017-04-05 19:11
浏览 61

如何在PHP Web应用程序中连接远程ms访问数据库

i want to connect remote ms access db from codeigniter framework. i tried it with odbc connection but it's not connecting. remote pc is server and have windows server 2012.

connection string i used:

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Server=192.168.0.1;Dbq=C:\_Database\_Backend\MasterBE.mdb;Uid=sa;pwd=sa;

codeigniter db connection:

$db['accessdb']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};Server=192.168.0.1;Dbq=C:\_Database\_Backend\MasterBE.mdb;Uid=sa;pwd=sa;';
$db['accessdb']['username'] = 'sa';
$db['accessdb']['password'] = 'sa';
$db['accessdb']['database'] = 'C:\_Database\_Backend\MasterBE.mdb';
$db['accessdb']['dbdriver'] = 'odbc';
$db['accessdb']['dbprefix'] = '';
$db['accessdb']['pconnect'] = TRUE;
$db['accessdb']['db_debug'] = TRUE;
$db['accessdb']['cache_on'] = FALSE;
$db['accessdb']['cachedir'] = '';
$db['accessdb']['char_set'] = 'utf8';
$db['accessdb']['dbcollat'] = 'utf8_general_ci';
$db['accessdb']['swap_pre'] = '';
$db['accessdb']['autoinit'] = TRUE;
$db['accessdb']['stricton'] = FALSE;

Please help me,

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计