dongping5230 2018-12-13 11:13
浏览 43

如何写入动态创建的mdb文件?

I have a web application written in PHP 5.6 and based on CodeIgniter 3 that creates a mdb file for every user that requests it. When a requests is made, a copy of a template mdb file is made into a folder created at runtime.

Here is my problem:

I have to write some data in such file, but I can't open a connection with it. I've tried the following:

odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$file", '', '');

and:

$odbc_con = new COM("ADODB.Connection");
$constr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$file;";
$odbc_con->open($constr);

and also:

new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$file; Uid=; Pwd=;");

and other similar way found online, but no matter what I try, I always get the error:

[Microsoft][Driver Manager ODBC] Data source name not found and default driver not specified.

I also tried to create a system DSN for mdb files with no database selected, since it is created dynamically, but I keep getting this error.

Am I missing something?

PS: this mdb file is needed for an existing application and I cannot use another format, like for example SQLite without modify that application.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥85 maple软件,solve求反函数,出现rootof怎么办?
    • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
    • ¥65 汇编语言除法溢出问题
    • ¥15 Visual Studio问题
    • ¥20 求一个html代码,有偿
    • ¥100 关于使用MATLAB中copularnd函数的问题