enable unixodbc gui

Asked by Goksu on 2008-10-27

hi,

I have installed unixODBC onto my ubuntu hardy. because no gui appeared,
I have also installed all of the packages I could find where odbc and gui are listed in synaptic.

but I cant find or start the gui to do the settings.

obviously I am very new to linux and have a hard time setting things up.

where is the odbc config gui?

thank you.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu unixodbc Edit question
Assignee:
No assignee Edit question
Solved by:
marcobra (Marco Braida)
Solved:
2008-10-30
Last query:
2008-10-30
Last reply:
2008-10-30
Goksu (gun-goksu) said : #1

Actually, I go to this trouble only to be able to connect to by MSAccess databases through php/apache.
moving them to mysql will take a very long time as I dont know how to use mysql under linux properly.

http://www.nabble.com/Connecting-to-a-remote-Microsoft-Access-database-from-Linux-to11803125.html
 http://www.unixodbc.org

Open a terminal and type:

sudo apt-get update
sudo apt-get install mdbtools libmdbodbc libmdbtools mdbtools-gmdb

then create or edit the:

sudo gedit /etc/odbcinst.ini

add

[MDBToolsODBC]
Description = MDBToolsODBCdrivers
Driver = /usr/lib/libmdbodbc.so.0
Usage = 1
FileUsage = 1

sudo gedit /etc/odbc.ini

add a connection

[test_conn]
Description = Test Sample Database
Driver = /usr/lib/libmdbodbc.so.0
Database = /home/yourusername/Documents/test.mdb

Then test it from terminal type:

isql test_conn

Hope this helps

Goksu (gun-goksu) said : #3

Thanks marcobra, that solved my question.

Goksu (gun-goksu) said : #4

thank you very much. :) it worked like a charm.
I imagine this connection can be used to connect web pages to these mdb files too.

thank you also for the links. I'll read through them.

Please also take a look at the previous installed mdbtools http://mdbtools.sourceforge.net/install/

mdbtools package provide command lines tools for read mdb http://mdbtools.sourceforge.net/install/x53.htm

mdb-array mdb-header mdb-parsecsv mdb-schema mdb-tables
mdb-export mdb-hexdump mdb-prop mdb-sql mdb-ver

and under Applications → Office → MDB Viewer you will have the gui interface

There is also: odbcinst - a command line tool for ODBC configuration

The "man odbcinst" command will give you all options

There is also the odbctest terminal command

Hope this helps

Related to database connection take a look also to jdbc