LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 12-29-2005, 12:18 AM   #1
bianchi
Member
 
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, 12:46 AM   #2
paulsm4
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:
http://mdbtools.sourceforge.net/
http://bryanmills.net:8086/archives/000099.html

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
 
  


Reply


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 07:56 AM
mdb Peter Shepard Red Hat 4 04-21-2005 08:36 PM
Need advice on editing mdb files bruno buys Linux - Software 1 03-28-2005 05:52 PM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 01:53 PM
MDB files in Linux? shassouneh Linux - Newbie 2 04-11-2002 01:08 PM


All times are GMT -5. The time now is 01:28 PM.

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