I want to connect to my MS Access Database (.mdb/.accdb files) via PHP (7.2.10), SLE 12.3. I started with libmdbodbc.so.1 driver which comes with package libmdbodbc1 0.7-3.1 (Source: mdbtools-0.7-3.1). With this I got an error "Allowed memory size of 2097152 bytes exhausted (tried to allocate 140 Tbytes)" Stack question. So I got advised to use the new ODBC driver from the IBM i Access Client Solutions Linux Application Package Stack question.
I installed ibm-iaccess-1.1.0.10-1.0.x86_64.rpm. But how to set an access database as source? Still tried "Driver={IBM i Access ODBC Driver 64-bit};Data Source=%s;System=localhost" (%s is replaced by path to .mdb/.accdb-File) and other parameters (System, Server, Servername, Database, ...), but always got an error and cannot establish connection to database or
"Communication link failure. comm rc=10061 - CWBCO1049 - The IBM i server application is not started, or the connection was blocked by a firewall"
But the database file is local, so there is no firewall. And when using libmdbodbc.so.1 I can connect to this database. I think I have to got the correct parameters to set the database file.
So how to setup configuration for MS Access Database file with ODBC driver IBM i Access Client?
Thank you for your response and best!
