Welcome to the most active Linux Forum on the web.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 12-29-2005, 01:18 AM   #1
Registered: Nov 2005
Location: Italy
Posts: 36

Rep: Reputation: 15
Lightbulb wxwidgets + mdb files

buon giorno

Is there any way to open/read mdb files ( microsoft Access files)
I read about wxDb - can I use this class which handles ODBC ?
Does ODBC is the same as ADO
If there is an example of using ....

grazie infinite
Old 12-29-2005, 01:46 AM   #2
LQ Guru
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

I'm not aware of any way to read and write Microsoft Access (.mdb) files under Linux. The problem is two-fold:

1. .mdb files are a closed, proprietary format (Microsoft's closed proprietary format)

2. You need runtime support from the OS in order to access an .mdb file. Specifically, you need Microsoft's "Jet Engine", which only runs under MS Windows.

Here is one Linux solution that might allow you to at least read an .mdb file:

MDB Tools:

And no, ODBC and ADO are not the same thing. ODBC is a procedural (e.g. C-language) API for accessing databases. It's database-neutral (with the right ODBC drivers, you can talk to Oracle, MS-SQL; to MS-Access, or even to Excel spreadsheets or CSV text files). ADO is also a database-neutral API for database access. Unlike ODBC, it's "object oriented" (or more specifically: VB-oriented). And unlike ODBC, ADO is pretty much limited to Microsoft clients and Microsoft tools (there's no such thing as ADO for any Linux programming languages, AFAIK). Neither of them would help you here. Even if you had an ODBC-compliant library for Linux (there are plenty of them), it still wouldn't be able to read your .mdb file on Linux ... unless you had something like MDB Tools. Which, as it happens, has an ODBC interface.

So check out the links above. Depending on your requirements, MDB Tools *might* be a good solution for you.

Your .. PSM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mdb files wmoti Programming 4 10-27-2005 08:56 AM
mdb Peter Shepard Red Hat 4 04-21-2005 09:36 PM
Need advice on editing mdb files bruno buys Linux - Software 1 03-28-2005 06:52 PM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 02:53 PM
MDB files in Linux? shassouneh Linux - Newbie 2 04-11-2002 02:08 PM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 11:45 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration