Обсуждение: 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