Обсуждение: Filemaker and pgsql
Anyone out there had experience using Filemaker Pro with PostgreSQL (with it's native ODBC driver or any third-party driver)? Is it doable, or is MS Access an easier solution? -- Randy Perry sysTame Mac Consulting/Sales phn 561.589.6449 mobile email help@systame.com
I'm very much interested in the same thing (accessing a postgresql
database with a filemaker pro front end via odbc), but I'm very new to
this ODBC stuff, so not much help yet.
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. I assume that I'm
supposed to use libpsqlodbc.so as my driver, but iodbc just seems to
crash when i try to use that for a driver, and unixODBC gives me a
"Could not construct a property list" error when i try to add a UserDSN
or a SystemDSN. Also I notice that both iodbc and unixODBC have a
field for a "setup" file for the driver. Does postgresql have such a
setup file?
Any advice as to what I might be missing or pointers to clear
documentation on these topics aimed at ODBC newbies would be greatly
appreciated.
thanx so much in advance,
~c
Randall Perry wrote:
>
> Anyone out there had experience using Filemaker Pro with PostgreSQL (with
> it's native ODBC driver or any third-party driver)?
>
> Is it doable, or is MS Access an easier solution?
>
> --
> Randy Perry
> sysTame
> Mac Consulting/Sales
>
> phn 561.589.6449
> mobile email help@systame.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
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. unixODBC has its own driver for PostgreSQL and the name is libodbcpsql.so. Probably you could get the library automatically when you install unixODBC. > I assume that I'm > supposed to use libpsqlodbc.so as my driver, but iodbc just seems to > crash when i try to use that for a driver, 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 ... regards, Hiroshi Inoue
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/
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