Yes filemaker can use ODBC but not as a live data source as you would use access as a frontend. You can use ODBC to import the data to a Filemaker database and display/edit it there and then export back through ODBC. If they use Filemaker to enter all the data (none is entered from the web site) then you can setup a script to export the data through ODBC to update the website. Either one record at a time after it is entered or as a batch one or more times a day. If information is entered into the website then you will also need a script to import the data from the website database. On 18/9/2006 11:58, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > brew@xxxxxxxxxxx writes: >> ... My biggest concern is the existing FileMakerPro clients. How much work >> would it be to connect the existing FMP clients to the postgreSQL database >> using ODBC? Is this a viable temporary step or could it be permanent? > > If they can speak ODBC, then in theory you can easily connect them to PG > that way. There's a fair-size gap between theory and practice, however > --- for example, the clients might be depending on some nonstandard SQL > syntax. The only way to really check this out is to test the clients > against PG and see what comes up. See the pgsql-odbc list archives for > some examples of gotchas. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Shane Ambler Postgres@xxxxxxxxxxxxxxxx Get Sheeky @ http://Sheeky.Biz
