Re: Filemaker and pgsql - Mailing list pgsql-odbc

From charlie derr
Subject Re: Filemaker and pgsql
Date
Msg-id 3B5D80A6.22224776@simons-rock.edu
Whole thread Raw
In response to Filemaker and pgsql  (Randall Perry <rgp@systame.com>)
List pgsql-odbc
Thank you both for the helpful responses.  I did in fact succeed in
making an ODBC connection from filemaker pro on Windows to my postgresql
db on a linux box.  I was also able to successfully set up unixodbc on
the linux box and test it with isql (though this wasn't necessary for
the filemaker pro connection -- that involved using the win2k ODBC Data
Manager program on the Windows machine).

My next question is about going in the other direction, i.e. connecting
to a filemaker pro database from postgresql using ODBC.  Filemaker pro
5.5 does have  the ability to create a shared ODBC resource (using the
Win2k Data Manager -- but i doubt that drivers are available yet for
unixodbc and/or iodbc), but I can't figure out how I would access that
connection from my postgresql running on linux.  In fact, all the
documentation that I've come across only seems to address the other
direction.  Is there any way to get psql to read from an ODBC
connection?.  The two possibilities that come to mind would be to
somehow use "select * from fmpTable;" to populate a postgresql table, or
to do a pg_dump on the ODBC connection which could then be imported into
a true postgreSQL db.  As I think more about this though, I'm realizing
that probably the only solution would involve a scripting language such
as python opening up two connections (one to each db) and writing the
fields obtained from the filemaker pro connection into the postgresql
database.  Is there anything more elegant that anyone can suggest?

    thanx,
        ~c



Olivier Berger wrote:
>
> Hiroshi Inoue wrote:
> >
> > charlie derr wrote:
> > >
> > > Meanwhile, I have some simple questions about how to set things up on
> > > linux (where my postgresql is installed).  I have tried both iodbc and
> > > unixODBC, but so far haven't had any success yet.
> >
> > Please check the following if you'd like to use the driver
> > with iODBC.
> >
> > 1) Use ~/.odbc.ini(user DSN) for odbc.ini.
> > 2) Never insert tabs between keywords and '='.
> > 3) Keywords are case sensitive. i.e Servername, Database,
> >    Port, Username, Password, ReadOnly ...
> >
>
> You may test the connection on unix with the isql command from
> unixodbc...
>
> Hope this helps.
>
> --
> Olivier BERGER                          IDEALX S.A.S.
> Développeur senior                      15-17, av. de Ségur
> 01.44.42.00.00                          F-75007 PARIS
> 06.81.27.86.79                          http://IDEALX.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

pgsql-odbc by date:

Previous
From: Olivier Berger
Date:
Subject: Re: Filemaker and pgsql
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC PG error