[gdal-dev] odbc issue

[Carlo A. Bertelli (Charta s.r.l.)]

Dear Margherita,
what about increasing complexity and adding a true spatial database in the
middle?
You could use PostgreSQL as a shared database that works well with both. I
think both QGIS and FileMaker would benefit a lot by having an ORDBMS to
help them to manage data in a more efficient way. Using a database server
(any DBMS supported by both programs) would avoid lock-in and would open
other research groups to use the tool they prefer to handle their data.
c

On Fri, Sep 16, 2022 at 9:00 PM  Margherita Zannini (marghez9 at libero.it)
wrote:

>
> Date: Fri, 16 Sep 2022 12:59:07 +0200 (CEST)
> From: marghez9 at libero.it
> To: "gdal-dev at lists.osgeo.org" <gdal-dev at lists.osgeo.org>
> Subject: [gdal-dev] odbc issue
> Message-ID: <58699396.106601.1663325947952 at mail1.libero.it>
> Content-Type: text/plain; charset="utf-8"
>
>
>  Good morning,
>
>
>  I write because I?ve a big issue. I?m an italian archaeologist and I?m
> doing a PhD in an archaeological site in Spain. My project was based on
> doing a gis on this site, but after an year working on it, my Professor
> told me I need to create an automatic connection between Filemaker and
> QGIS, otherwise I won?t be allow to continue my Phd, that for me it?s kind
> of like life and death.
>
>
>  After some months of attempts I was able to connect the softwares through
> ODBC (but there are some bugs and it works only using some specific
> versions), but currently only filemaker can dialogue with QGIS but not vice
> versa. I think that the issue is that ODBC driver that filemaker use for
> connecting to QGIS is ?read only?. I did some attempts also between
> filemaker and LibreOffice and I?ve the same issue, so I doubt could be that
> filemaker doesn?t give the permission for driver ?writ?.
>
>
>  Anyway I read here (
> https://gdal.org/drivers/vector/odbc.html?fbclid=IwAR2mUiMTb9hsGLpDdSaSY_qnpny8DUTDKc49WVkPw4yvizBBnPB9JoOByX8#creation-issues)
> that could be also a QGIS issue, so I want to know what do you think about
> that and if this problem could be solved implementing that. My PhD is
> without scholarship (so I?m not paid for this), but I?m so desperate that
> I?m willing to pay for resolve this problem and, in this cane, I need to
> know how much would be.
>
>
>  Thank you so much.
>
>
>  Margherita Zannini
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220918/4d43cf59/attachment.htm>