enable unixodbc gui

Asked by Goksu

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:
Last query:
Last reply:
Revision history for this message
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.

Revision history for this message
Best marcobra (Marco Braida) (marcobra) said :
#2

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

Revision history for this message
Goksu (gun-goksu) said :
#3

Thanks marcobra, that solved my question.

Revision history for this message
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.

Revision history for this message
marcobra (Marco Braida) (marcobra) said :
#5

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