Stack Overflow
Stack Overflow

Questions tagged [mdbtools]

Read Microsoft's Access databases on *nix

57 questions
2
votes
3 answers

Can I make a DSN-less connection using pyodbc and mdbtools?

I've tried the following: >>> import pyodbc >>> cnxn = pyodbc.connect(Driver="MDB", database="SohabeD51.mdb") pyodbc.Error: ('08001', '[08001] [unixODBC]Could not find DSN in connect string (1) (SQLDriverConnectW)') Connecting to a…
Georg Schölly
  • 124,188
  • 49
  • 220
  • 267
1
vote
0 answers

SQL Queries on Access DB return null or empty results using mdbtools

If I use any condition apart from SELECT * whilst querying an Access DB with ODBC I get the following error: No tuples available at this result index Any ideas ? Here's the particular GROUP BY query: $result = odbc_exec($this->connection, "SELECT *…
user300285
1
vote
0 answers

Get ODBC Driver Name with PDO

Here is my connection string (set elsewhere): $dns = "odbc:Driver=MDBTools;DBQ=/home/mbi-admin/scripts/RE/ConstituentData.MDB;" Here is my code function InitializeDB($dsn, $user, $pass) { echo "************** \n"; //$dsn =…
Cade
  • 123
  • 1
  • 10
1
vote
1 answer

Do Microsoft Access backup files have a proprietary format?

A client of mine somehow had his site lost/hacked/destroyed by gnomes and I have the "fun" job of restoring it for him from a backup. It uses a combination of ColdFusion and Microsoft Access (yuck!). I set up a Railo server on my computer, however…
Mike
  • 23,542
  • 14
  • 76
  • 87
1
vote
0 answers

MDBTools: all queries fail

I'm moving a project to a Ubuntu server which connects to a Windows Server for a MS Access database via a shared folder which is mounted. I have installed MDBTools as driver, but currently all my queries seem to fail where on Windows they work fine.…
vespino
  • 1,714
  • 3
  • 15
  • 28
1
vote
0 answers

PHP PDO Connection returns SQLSTATE[00000] (Works on terminal but not on web)

I am trying to run a php(7.2) query into a Microsoft Access Database over my network in a linux(Ubuntu 18.04) environment. I am using Nginx as my webserver and MDBTools as my driver. I set up an odbc.ini and odbcinst.ini DSN and have tried multiple…
Thomas M
  • 192
  • 1
  • 1
  • 10
1
vote
1 answer

Access Access Design View field descriptions

I have an Access database with field descriptions that (theoretically) are visible in Design View. I don't have a copy of access. I can export the data and schema using mdbtools, but those don't come with the descriptions. Are there ways to…
Matt Hampel
  • 5,088
  • 12
  • 52
  • 78
1
vote
0 answers

PHP PDO, Ubuntu, MDBTools Problems connecting to Access Database

I am having trouble debugging a connection to an MSAccess 2010 .accdb file. I'm running a Scotch Box Vagrant vm (v3.5) and have installed the MDBTools odbc driver via sudo apt-get install mdbtools. My /etc/odbcinst.ini file looks like this: # To…
juliolopez78
  • 261
  • 1
  • 6
1
vote
1 answer

Converting access db to sql using mdbtools

While I was trying to import my .accdb to sql database by using command mdb-schema IPEDS201617.accdb | mysql -u root -p IPED201617 It is throwing an error which says ERROR 1064 (42000) at line 11: You have an error in your SQL syntax; check the…
SNishant
  • 103
  • 11
1
vote
0 answers

Unreliable Query results from an Access DB with a PHP PDO odbc connection using the MDBTools driver

I'm on a Ubuntu 16.04 box, and have connected to an MS Access database via PHP PDO. I am using the MDBTools odbc driver. To prepare for this, I ran the following commands in the terminal: sudo apt install php7.0-odbc sudo apt install…
Brian Gottier
  • 4,522
  • 3
  • 21
  • 37
1
vote
1 answer

Why is my inner join throwing syntax errors?

Why is my sql string throwing syntax errors? Answer: MDBTools does not support JOIN or ORDER BY or other SEE http://github.com/brianb/mdbtools/blob/master/src/sql/lexer.l This code does not work (syntax error near .): $db = "access.mdb"; $conn =…
Frank
  • 31
  • 8
1
vote
0 answers

segmentation fault (core dumped) - Pyodbc & mdbtool

I have to connect the mdb file by using pyodbc , the connection should be established, When i fetch data from the cursor by using cusor.fetchall(),i get error for Segmentation fault (core dumped) con = pyodbc.connect('DSN=CHN') csr =…
Paul
  • 13
  • 4
1
vote
1 answer

Accessing MDB file with PHP on CentOS machine

I am trying to access a MDB file using PHP on a CentOS machine, preferably using PDO. I have installed the ODBC and pdo_odbc modules in PHP and restarted the the web server (Apache). I also installed mdbtools and unixODBC.…
user2395126
  • 526
  • 1
  • 7
  • 20
1
vote
1 answer

PDO connection using MDBtool linux

hello everyone just wondering why its not working, im trying to INSERT data to MS access file (.MDB) OS is GNU-Unix/Linux, in my odbcinst.ini [mdb] Description = MDB Tools ODBC Driver = /ble/blee/libmdbodbc.so.0 Setup = FileUsage = CPTimeout…
CodeCrisis
  • 85
  • 7
1
vote
1 answer

Segmentation fault with large tables using MDBTools

I am getting a segmentation fault when using MDBTools with large Microsoft Access tables within a database. Querying small tables works fine, but anything large (Have tables with roughly 80,000 rows) causes a segmentation fault. I am using CentOS…
user1871245
1
2
3 4