Expert: Jean-Pierre Zuate - 2/26/2008

Question
Hi,
I am new to Ingres and I am just installing ingres2006-9.0.4-104-NPTL-gpl-pc-linux-i386.tgz in RedHat9. Then here comes two questions confusing me.

The first is when I use usr:"ingres" login, cd "/opt/Ingres/IngresII/ingres" to execute the version.rel, "permission denied" popup.
And the second (the most important one) is I really don't know how to import *.mdb files to ingres DB in Linux. Could you tell me how to do this or there's another file I have to
install?

Thanks in advance
Beck

Answer
Hello,

You do not have to execute the file version.rel. This file contain the version of Ingres (a litteral). Why do you want to execute it ?

MDB files are Access files. Without a third party tool (as an ETL) to read data from mdb file and to write it onto Ingres or export each table from access to csv file and recreate them in ingres, no solution here.

To import data in Ingres via csv file you must use the Ingres Import Assistant. This is a graphical tool. It come with Ingres on WIndows only (this part of Ingres is not open source but still free).

If you are new to Ingres you can have a look at this page : http://docs.ingres.com/ and check for some guides like :
- getting started guide
- quick start guide for windows (and linux)
- Ingres for linux getting started

You'll find here some helpful informations about Ingres on these platform and tools assiciate to Ingres.

Hope this help,
Kind regards.
Jean-Pierre ZUATE
http://lafageconseil.fr