Re: [Qgis-user] "Normal" mdb support possible for "normal" people? (now - mdbtools for Mac OS X and Linux - working)
On 9/26/12, Even Rouault wrote: > >> I also had problems compiling the old version (at sourceforge), but I >> think >> it was something in the CLI tools, which I didn't need for ODBC. I made >> a >> custom makefile to get the ODBC driver, but it never worked. Maybe I'll >> try again with the new version (though it's low priority for me, no >> need). >> >> There is a commercial OS X ODBC driver (Actual Tech) that I thought was >> based on mdbtools, but that can't be right since they don't distribute >> their source code. I could not get theirs to works, problem skipping >> bytes in blobs (which is where the coordinate data is stored), they could >> not fix it. > > I've just tried with the GIT version of https://github.com/brianb/mdbtools > > and with UnixODBC 2.3.1. > > Like last time I tried, I got compilation errors to compile odbc.c (the > implementation of the ODBC driver) from mdbtools due to 64bit > incompatibilities. I fixed them to the point where it compiles, but the MDB > > ODBC driver still misbehaves. > > However, I tried the mdb-export tool that just uses the libmdb API and it > seemed to read correctly a Personal Geodatabase MDB (whereas the old version > > that ships with my Ubuntu 10.04 crashes), so it should perhaps be possible > for > someone to write a driver that used the libmdb API directly, or alter the > OGR > MDB driver to use libmdb instead of Jackess (the Java part of the driver is > > quite isolated, so libmdb and Jackess could be 2 backends used indifferently > by > the driver). I just like to inform the list that mdbtools (library and odbc.c) work (compile and install) in Mac OS X now. I have not tested yet. Posted these 2 issues in github and it is all fixed. https://github.com/brianb/mdbtools/issues/18 https://github.com/brianb/mdbtools/issues/17 For linux users, please test and report any issues. Thanks. Noli ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
> I also had problems compiling the old version (at sourceforge), but I think > it was something in the CLI tools, which I didn't need for ODBC. I made a > custom makefile to get the ODBC driver, but it never worked. Maybe I'll > try again with the new version (though it's low priority for me, no need). > > There is a commercial OS X ODBC driver (Actual Tech) that I thought was > based on mdbtools, but that can't be right since they don't distribute > their source code. I could not get theirs to works, problem skipping > bytes in blobs (which is where the coordinate data is stored), they could > not fix it. I've just tried with the GIT version of https://github.com/brianb/mdbtools and with UnixODBC 2.3.1. Like last time I tried, I got compilation errors to compile odbc.c (the implementation of the ODBC driver) from mdbtools due to 64bit incompatibilities. I fixed them to the point where it compiles, but the MDB ODBC driver still misbehaves. However, I tried the mdb-export tool that just uses the libmdb API and it seemed to read correctly a Personal Geodatabase MDB (whereas the old version that ships with my Ubuntu 10.04 crashes), so it should perhaps be possible for someone to write a driver that used the libmdb API directly, or alter the OGR MDB driver to use libmdb instead of Jackess (the Java part of the driver is quite isolated, so libmdb and Jackess could be 2 backends used indifferently by the driver). > > - > William Kyngesburye > http://www.kyngchaos.com/ > > The equator is so long, it could encircle the earth completely once. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
On Sep 25, 2012, at 2:54 AM, Noli Sicad wrote: > On 9/25/12, Even Rouault wrote: >> Yes. But there would be no problems to make it work on Linux too, like it is done in the PGeo driver, but personnaly I don't see the interest in doing so, since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux (particularly 64bit) is too broken to be usefull >>> >>> Does this apply for the new 0.7 version of mdbtools? It seems to have a >>> low >>> profile because it is on github instead of sourceforge... >>> http://sourceforge.net/mailarchive/message.php?msg_id=29472144 >> >> That's interesting news. I was refering to the (quite old) mdbtools that >> ship >> with Linux distro. Perhaps 0.7 includes interesting fixes. >> > > Hopefully, it will work in Mac OS X as well. > > It is not working at the moment. I filed a report bug. > https://github.com/brianb/mdbtools/issues/17 I also had problems compiling the old version (at sourceforge), but I think it was something in the CLI tools, which I didn't need for ODBC. I made a custom makefile to get the ODBC driver, but it never worked. Maybe I'll try again with the new version (though it's low priority for me, no need). There is a commercial OS X ODBC driver (Actual Tech) that I thought was based on mdbtools, but that can't be right since they don't distribute their source code. I could not get theirs to works, problem skipping bytes in blobs (which is where the coordinate data is stored), they could not fix it. - William Kyngesburye http://www.kyngchaos.com/ The equator is so long, it could encircle the earth completely once. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
On 9/25/12, Even Rouault wrote: > >> > Yes. But there would be no problems to make it work on Linux too, like >> > it >> > is >> > done in the PGeo driver, but personnaly I don't see the interest in >> > doing >> > so, >> > since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux >> > (particularly 64bit) is too broken to be usefull >> >> Does this apply for the new 0.7 version of mdbtools? It seems to have a >> low >> profile because it is on github instead of sourceforge... >> http://sourceforge.net/mailarchive/message.php?msg_id=29472144 > > That's interesting news. I was refering to the (quite old) mdbtools that > ship > with Linux distro. Perhaps 0.7 includes interesting fixes. > Hopefully, it will work in Mac OS X as well. It is not working at the moment. I filed a report bug. https://github.com/brianb/mdbtools/issues/17 Noli ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
> > Yes. But there would be no problems to make it work on Linux too, like it > > is > > done in the PGeo driver, but personnaly I don't see the interest in doing > > so, > > since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux > > (particularly 64bit) is too broken to be usefull > > Does this apply for the new 0.7 version of mdbtools? It seems to have a low > profile because it is on github instead of sourceforge... > http://sourceforge.net/mailarchive/message.php?msg_id=29472144 That's interesting news. I was refering to the (quite old) mdbtools that ship with Linux distro. Perhaps 0.7 includes interesting fixes. > > Alister > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Maybe I think about and extend my online GeoConverter with SQlite and Personal or File Geodatabases some time... But that's not suited to huge file sizes. Do you think that could still help? Yours, S. 2012/9/25 Alister Hood : > Hi, > >> Date: Mon, 24 Sep 2012 09:14:29 +0200 >> From: Even Rouault >> To: Etienne Tourigny >> Cc: qgis-user@lists.osgeo.org >> Subject: Re: [Qgis-user] "Normal" mdb support possible for "normal" >> people? >> Message-ID: <1348470869.5060085548...@imp.free.fr> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> Selon Etienne Tourigny : >> >> > On Sun, Sep 23, 2012 at 5:15 PM, Even Rouault >> > wrote: >> > > Le dimanche 23 septembre 2012 21:58:30, Etienne Tourigny a ?crit : >> > >> Hi Even, >> > >> >> > >> can you comment on using the java jackcess library? It's probably the >> > >> only cross-platform solution. Does it support normal mdb files, and >> if >> > >> not, can it benefit from your recent additions? >> > >> >> > >> http://www.gdal.org/ogr/drv_mdb.html >> > >> http://jackcess.sourceforge.net/ >> > > >> > > The MDB driver (with Jackcess library) indeed already supports normal >> MDB >> > > files. But it is a bit of a pain to use (needs linking GDAL with a JVM >> and >> > the >> > > Jackess .jar), so the latest improvement to the ODBC driver should >> make it >> > > easier. >> > >> > But your improvements are only supported in windows, right? >> >> Yes. But there would be no problems to make it work on Linux too, like it >> is >> done in the PGeo driver, but personnaly I don't see the interest in doing >> so, >> since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux >> (particularly 64bit) is too broken to be usefull > > Does this apply for the new 0.7 version of mdbtools? It seems to have a low > profile because it is on github instead of sourceforge... > http://sourceforge.net/mailarchive/message.php?msg_id=29472144 > > Alister > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Hi, > Date: Mon, 24 Sep 2012 09:14:29 +0200 > From: Even Rouault > To: Etienne Tourigny > Cc: qgis-user@lists.osgeo.org > Subject: Re: [Qgis-user] "Normal" mdb support possible for "normal" > people? > Message-ID: <1348470869.5060085548...@imp.free.fr> > Content-Type: text/plain; charset=ISO-8859-1 > > Selon Etienne Tourigny : > > > On Sun, Sep 23, 2012 at 5:15 PM, Even Rouault > > wrote: > > > Le dimanche 23 septembre 2012 21:58:30, Etienne Tourigny a ?crit : > > >> Hi Even, > > >> > > >> can you comment on using the java jackcess library? It's probably the > > >> only cross-platform solution. Does it support normal mdb files, and > if > > >> not, can it benefit from your recent additions? > > >> > > >> http://www.gdal.org/ogr/drv_mdb.html > > >> http://jackcess.sourceforge.net/ > > > > > > The MDB driver (with Jackcess library) indeed already supports normal > MDB > > > files. But it is a bit of a pain to use (needs linking GDAL with a JVM > and > > the > > > Jackess .jar), so the latest improvement to the ODBC driver should > make it > > > easier. > > > > But your improvements are only supported in windows, right? > > Yes. But there would be no problems to make it work on Linux too, like it > is > done in the PGeo driver, but personnaly I don't see the interest in doing > so, > since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux > (particularly 64bit) is too broken to be usefull Does this apply for the new 0.7 version of mdbtools? It seems to have a low profile because it is on github instead of sourceforge... http://sourceforge.net/mailarchive/message.php?msg_id=29472144 Alister ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Selon Etienne Tourigny : > On Sun, Sep 23, 2012 at 5:15 PM, Even Rouault > wrote: > > Le dimanche 23 septembre 2012 21:58:30, Etienne Tourigny a écrit : > >> Hi Even, > >> > >> can you comment on using the java jackcess library? It's probably the > >> only cross-platform solution. Does it support normal mdb files, and if > >> not, can it benefit from your recent additions? > >> > >> http://www.gdal.org/ogr/drv_mdb.html > >> http://jackcess.sourceforge.net/ > > > > The MDB driver (with Jackcess library) indeed already supports normal MDB > > files. But it is a bit of a pain to use (needs linking GDAL with a JVM and > the > > Jackess .jar), so the latest improvement to the ODBC driver should make it > > easier. > > But your improvements are only supported in windows, right? Yes. But there would be no problems to make it work on Linux too, like it is done in the PGeo driver, but personnaly I don't see the interest in doing so, since in my experience, MDBTools, the Unix MDB ODBC driver, under Linux (particularly 64bit) is too broken to be usefull > Jackcess is the only solution for linux (and mac) platforms, or are there > other(s)? This is the one I found. There are perhaps others I'm not aware of > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
On Sun, Sep 23, 2012 at 5:15 PM, Even Rouault wrote: > Le dimanche 23 septembre 2012 21:58:30, Etienne Tourigny a écrit : >> Hi Even, >> >> can you comment on using the java jackcess library? It's probably the >> only cross-platform solution. Does it support normal mdb files, and if >> not, can it benefit from your recent additions? >> >> http://www.gdal.org/ogr/drv_mdb.html >> http://jackcess.sourceforge.net/ > > The MDB driver (with Jackcess library) indeed already supports normal MDB > files. But it is a bit of a pain to use (needs linking GDAL with a JVM and the > Jackess .jar), so the latest improvement to the ODBC driver should make it > easier. But your improvements are only supported in windows, right? Jackcess is the only solution for linux (and mac) platforms, or are there other(s)? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Le dimanche 23 septembre 2012 21:58:30, Etienne Tourigny a écrit : > Hi Even, > > can you comment on using the java jackcess library? It's probably the > only cross-platform solution. Does it support normal mdb files, and if > not, can it benefit from your recent additions? > > http://www.gdal.org/ogr/drv_mdb.html > http://jackcess.sourceforge.net/ The MDB driver (with Jackcess library) indeed already supports normal MDB files. But it is a bit of a pain to use (needs linking GDAL with a JVM and the Jackess .jar), so the latest improvement to the ODBC driver should make it easier. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
yeah, i'm really passionate with that stuff! ;) ok, so that means that there is something in the pipeline and will be available sooner or later (and from my experience with the great development of qgis in the past hopefully sooner than later) Many thanx Bernd Am 23.09.2012, 21:01 Uhr, schrieb Even Rouault : Le dimanche 23 septembre 2012 20:54:06, Bernd Vogelgesang a écrit : > I've just added some magic to the OGR ODBC driver in GDAL trunk (GDAL > 2.0dev) > so that it can open directly non-spatial MDB databases on Windows. > > Note: this is just a shortcut for the "normal" syntax that should work > currently : > > ogrinfo ODBC:DRIVER=Microsoft Access Driver (*.mdb);DBQ=filename.mdb > > Now : ogrinfo filename.mdb > > Best regards, > > Even Hi Even, ermm ... and what does that mean for ... me ? Can't really do anything with this info but say "wow" for example, but it leaves me quite clueless. Any more info possible how this is affecting my live or qgis? Wow, I don't expect such a stuff to affect your life that much ;-) It means that once you have a QGIS version that uses GDAL trunk, it should be able to open a non-spatial MDB. In practice, it can mean that you have to wait for GDAL 2.0 to be released (don't ask me when it will be) to be distributed with QGIS. Or you can perhaps find someone that makes a custom build for you if you cannot wait. Thanx Bernd -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Le dimanche 23 septembre 2012 20:54:06, Bernd Vogelgesang a écrit : > > I've just added some magic to the OGR ODBC driver in GDAL trunk (GDAL > > 2.0dev) > > so that it can open directly non-spatial MDB databases on Windows. > > > > Note: this is just a shortcut for the "normal" syntax that should work > > currently : > > > > ogrinfo ODBC:DRIVER=Microsoft Access Driver (*.mdb);DBQ=filename.mdb > > > > Now : ogrinfo filename.mdb > > > > Best regards, > > > > Even > > Hi Even, > > ermm ... and what does that mean for ... me ? > Can't really do anything with this info but say "wow" for example, but it > leaves me quite clueless. > > Any more info possible how this is affecting my live or qgis? Wow, I don't expect such a stuff to affect your life that much ;-) It means that once you have a QGIS version that uses GDAL trunk, it should be able to open a non-spatial MDB. In practice, it can mean that you have to wait for GDAL 2.0 to be released (don't ask me when it will be) to be distributed with QGIS. Or you can perhaps find someone that makes a custom build for you if you cannot wait. > > Thanx > Bernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
I've just added some magic to the OGR ODBC driver in GDAL trunk (GDAL 2.0dev) so that it can open directly non-spatial MDB databases on Windows. Note: this is just a shortcut for the "normal" syntax that should work currently : ogrinfo ODBC:DRIVER=Microsoft Access Driver (*.mdb);DBQ=filename.mdb Now : ogrinfo filename.mdb Best regards, Even Hi Even, ermm ... and what does that mean for ... me ? Can't really do anything with this info but say "wow" for example, but it leaves me quite clueless. Any more info possible how this is affecting my live or qgis? Thanx Bernd -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
Le samedi 22 septembre 2012 00:59:43, Bernd Vogelgesang a écrit : > Hi there, > from a talk at the German User Meeting today in Kassel (thanx to Claas for > the organization), i got the impression that ONE important thing in qgis > is still missing: > Direct support for normal access databases! > > Personal geodatabases work like a charm now (many thanx for this!), but i > was told, that a lot of people who would be the perfect target group for > qgis, still work on a completely gis-free level, dealing with their data > in normal access databases or even worse formats. > > To catch those people and show them the light, it seems to me to be > crucial, that qgis would be able to add/join/edit normal tables from > normal access database as well without having to do such odbc-magic apprx. > 99% of the world population have never heard of. > > Here > http://osgeo-org.1560.n6.nabble.com/direct-mdb-read-in-QGis-td4637313.html > i found a "solution" for geeks, but how about those people like me or john > doe, who have no idea about how to compile gdal with other stuff but are > merely able to do some gis work? > > I couldn'd find a feature request on the hub on this matter, so i wonder > if this would be a good feature request, or whether there are technical, > legal or "political" constraints preventing such a support so far. > > As far as i understand ESRI personal geodatabases are just some pimped > access databases, so the impossibility to just load such in qgis is a > mystery to me. > > Can anybody shed some light on this issue? I've just added some magic to the OGR ODBC driver in GDAL trunk (GDAL 2.0dev) so that it can open directly non-spatial MDB databases on Windows. Note: this is just a shortcut for the "normal" syntax that should work currently : ogrinfo ODBC:DRIVER=Microsoft Access Driver (*.mdb);DBQ=filename.mdb Now : ogrinfo filename.mdb Best regards, Even ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "Normal" mdb support possible for "normal" people?
HiBernd, apart from the solution you mention, MS Access database tables can also be accessed via the evis plugin. But this is only a one-way-importer. It should be possible to connect to MDBs the same way as postgis and spatialite databases. I think the problem comes with database synchronisation and parallel working on the same database. In such cases, the ultimate answer is: "You can have what you want, if you pay a developer for it." Greetings, André Joost Am 22.09.2012 00:59, schrieb Bernd Vogelgesang: Hi there, from a talk at the German User Meeting today in Kassel (thanx to Claas for the organization), i got the impression that ONE important thing in qgis is still missing: Direct support for normal access databases! Personal geodatabases work like a charm now (many thanx for this!), but i was told, that a lot of people who would be the perfect target group for qgis, still work on a completely gis-free level, dealing with their data in normal access databases or even worse formats. To catch those people and show them the light, it seems to me to be crucial, that qgis would be able to add/join/edit normal tables from normal access database as well without having to do such odbc-magic apprx. 99% of the world population have never heard of. Here http://osgeo-org.1560.n6.nabble.com/direct-mdb-read-in-QGis-td4637313.html i found a "solution" for geeks, but how about those people like me or john doe, who have no idea about how to compile gdal with other stuff but are merely able to do some gis work? I couldn'd find a feature request on the hub on this matter, so i wonder if this would be a good feature request, or whether there are technical, legal or "political" constraints preventing such a support so far. As far as i understand ESRI personal geodatabases are just some pimped access databases, so the impossibility to just load such in qgis is a mystery to me. Can anybody shed some light on this issue? ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] "Normal" mdb support possible for "normal" people?
Hi there, from a talk at the German User Meeting today in Kassel (thanx to Claas for the organization), i got the impression that ONE important thing in qgis is still missing: Direct support for normal access databases! Personal geodatabases work like a charm now (many thanx for this!), but i was told, that a lot of people who would be the perfect target group for qgis, still work on a completely gis-free level, dealing with their data in normal access databases or even worse formats. To catch those people and show them the light, it seems to me to be crucial, that qgis would be able to add/join/edit normal tables from normal access database as well without having to do such odbc-magic apprx. 99% of the world population have never heard of. Here http://osgeo-org.1560.n6.nabble.com/direct-mdb-read-in-QGis-td4637313.html i found a "solution" for geeks, but how about those people like me or john doe, who have no idea about how to compile gdal with other stuff but are merely able to do some gis work? I couldn'd find a feature request on the hub on this matter, so i wonder if this would be a good feature request, or whether there are technical, legal or "political" constraints preventing such a support so far. As far as i understand ESRI personal geodatabases are just some pimped access databases, so the impossibility to just load such in qgis is a mystery to me. Can anybody shed some light on this issue? -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
