Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Using a Microsoft Access database under Linux (RE: [udig-devel] Re: Geowidgets?)

Hello Matthias,

I'm posting to you directly because the subject is not very udig anymore.

Using a Microsoft Access database under Linux is possible but will give you
some troubles.

The preferred method is to import the data into a 'more native' Linux
database like MySQL or PostgreSQL.

If however you want to use Access under Linux way you'll need the MDBTools
(http://mdbtools.sourceforge.net).

A nice article on using this tool can be found at
http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-
linux-and-php/

Looks like MDBTools is not under development any longer but it might suit
your needs.

Use MDBTools to setup an ODBC data source in your Linux box and then use the
JDBC-ODBC Bridge (? I'm not very comfortable with Java, have used Access
under Linux with PHP).

Regards,

Emil Zegers


-----Original Message-----
From: udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx]On Behalf Of Matthias
Basler
Sent: vrijdag 29 april 2005 11:52
To: udig-devel@xxxxxxxxxxxxxxxxxxxxx
Subject: [udig-devel] Re: Geowidgets?


Hi developers

My geowidgets initiative makes good progress. Until now I have managed to
build
an API(interfaces + implementation) for
- creating CRS-related objects ( + GeoTools implementation)
- lookoing up CRS-related objects (- EPSG via ODBC implementation)
- CRS widget implementations for Swing.

They are working (e.g. producing GeographicCRS objects), but need some more
additions and testing. Also I want to expand the current concept to
Projected
CRS and 3D CRS versions.

Currently I had some idea that I'd love to see implemented in uDig: AFAIK
every
data layer has a CRS attached if it is georeferenced. My idea is that some
view
(e.g. the legend view) shows the CRS name as a child entry of the layer, and
when the user clicks on it the CRS entry, the CRS' properties are shown in
the
properties view (not as WKT string as currently, but as separate properties
each). The user could there select Geodetic datum, ellipsoid, projection
a.s.o.
from dropdowns using the geowidgets API for the "behind the scenes" logic.
I've already tried to figure out to create own propertysheet entries. I
guess
you know how to do it, since you are already using the properties view.

P.S. Does anybody know how to install the EPSG_v65.mdb MS Access database
under
linux and access if from Java there, if that's possible at all?

Matthias Basler
c9bama@xxxxxxxxxxx

----------------------------------------------------------------
This mail was sent through http://webmail.uni-jena.de
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel



Back to the top