Stack Overflow
Stack Overflow

Questions tagged [mdbtools]

Read Microsoft's Access databases on *nix

57 questions
1
vote
2 answers

Working with dates in SQL query using MDB-Tools

I have been working on a project where I have to fetch data from MS-Access database. I am using mdb-sql tool for running sql queries into that database. But the problem occurs when I try to put where clause on a datetime column. It always throws a…
user1685501
  • 11
  • 1
  • 2
1
vote
2 answers

LAMP (PHP) accessing Access Database with ODBC with MDBTools Driver

Can anyone tell me if there is limited SQL support using unixODBC drivers on Ubuntu with PHP? I've setup a basic lamp server on Ubuntu 11.10, and I'm trying to query an Access database. I've installed php5-odbc and MDB Tools. Here is some sample…
Tim S
  • 5,023
  • 1
  • 34
  • 34
0
votes
1 answer

CodeIgniter - Active Record returning empty results with Access ODBC

I'm connecting to an Access DB via mdbtools on a Linux system and on running any query via Active Record it returns an empty result. No errors or anything to show in the logs. Any ideas ? It connects to the database without a hitch and I have no…
user300285
0
votes
1 answer

How to change pdo_odbc.ini extension setting to libodbc.so

Installed LAMP on an offline Ubuntu 22.04 box to test odbc-mdbtools setup ready for an online server which needs to read and write to MS Access for sending/accepting with Microsoft-based tablets (before anyone says why do such a thing). Put unixODBC…
Emulite
  • 102
  • 8
0
votes
0 answers

Exporting from Access Database (.mdb) via Python to Pandas Dataframe

I'm looking for a method to programmatically access an access database file (.mdb) using python in an Ubuntu environment (hosted on a Windows 10 machine) to export tables to pandas dataframes. I've attempted the solutions previously posted, such as…
kfob
  • 1
0
votes
0 answers

How to connect to MDB file using C# but without any installation

I am developing using C#, and want to open mdb files and query their tables. But I don't want to use any additional installations (MS Access Software or MS Access Engine). Is there any way to do that. However, It is very necessary to run the…
AmD
  • 33
  • 1
  • 6
0
votes
1 answer

Mac R work with mdbtools works with macport install not home-brew install

I am using R to access a .mdb file. library("Hmisc") mdb.get("NCSS_Lab_Data_Mart_09142018.mdb", tables=TRUE) Before to use this r code, I need to install home-brew for m1 Mac. Then I installed the mdbtools with: brew install mdbtools. however, my…
zzw0034
  • 21
  • 2
0
votes
0 answers

Are there exist any alternatives for mdbtools which doesn't use Java?

So I am tried to work with MsAccess DB file at Linux systems (Ubuntu 20.04 and CentOs 8) using Python and SqlAlchemy. And can't get to work mdbtools driver even with the simpliest query. At my home Ubuntu I installed latest sqlalchemy_access,…
Yuri
  • 135
  • 10
0
votes
1 answer

How do I install mdbtools on an EC2 instance?

To install mdbtools on an EC2 instance I entered the following: curl http://download-ib01.fedoraproject.org/pub/epel/7/x86_64/Packages/m/mdbtools-0.7.1-3.el7.x86_64.rpm > mdbtools-0.7.1-3.el7.x86_64.rpm rpm -Uvh mdbtools-0.7.1-3.el7.x86_64.rpm yum…
David P. Chassin
  • 41
  • 4
0
votes
0 answers

unixODBC on Mac OS X (via brew) and PHP

I'm trying to work with ODBC on a Mac OS X 10.14 comp. My devel env have a nginx webserver and php 7.3.10. After following some guides, I've installed mdbtools with odbc support. I can read my access database with isql, via odbc name or…
Sakura Kinomoto
  • 1,784
  • 2
  • 21
  • 30
0
votes
1 answer

Connecting from Python on Linux to MS Access

I am trying to connect to an access .mdb file in a linux environment. Until now, I have done this in windows like this: import pyodbc DRIVER="{Microsoft Access Driver (*.mdb, *.accdb)}" def connect(): PATH = '...file.mdb' con =…
SpeedOfRound
  • 1,210
  • 11
  • 26
0
votes
1 answer

Allowed memory size exhausted with odbc_exec libmdb mdbtools

I want to connect to my MS Access Database via PHP (7.2.10), SLE 12.3. For this I'm using the libmdbodbc.so.1 driver which comes with package libmdbodbc1 0.7-3.1 (Source: mdbtools-0.7-3.1). Setup is done in unixODBC…
user2625247
  • 361
  • 1
  • 4
  • 15
0
votes
0 answers

Query for Access mdb can't be run in Python on Linux

I want to read a *.mdb database in odoo and import some data to odoo but I cannot read some fields. In *.mdb I have 2 tables first table is USERINFO with fields: SSN, Name, USERID second table is CHECKINOUT with fields: USERID, CHECKTIME,…
niyuzuku
  • 11
  • 2
0
votes
0 answers

Converting table-relations from mdb file to JSON

I want to extract the table relationships and data from mdb file and convert it to JSON. I have tried using external tools like mdb-schema from mdbtools,accessdb but I am only able to generate the data and not the table relations. Can someone…
charul
  • 1
0
votes
0 answers

Import MS Access data on a Meteor Galaxy server

I need to parse a MS Access database on a Meteor server hosted on Galaxy. Specifically it's a .accdb file. If I were able to install mdbtools on Galaxy, the npm package mdb would serve this purpose- but I'm fairly certain I can't install anything…
Aaron Olinger
  • 1
  • 3
1 2
3
4