Hi Mark, It was pretty straightforward, I defined the ODBC data source under Win XP and connected to it from the database query builder (Rev Enterprise 2.8.1) with no problem. I attached the query to a field table object and was able to read and update records without error.
Usually I use the reOpenDatabase, revExecuteSQL etc, but for the sake of the experiment just went for the simple approach. Mind you I haven't tried this on a network yet, it was a local ODBC data source. I haven't explored how flexible the ODBC interface is but will have to get to that soon. The product I am building abstracts the presentation layer away from any particular brand of SQL (or ODBC) and will handle the mapping between multiple host database types. Regards John <DIV><FONT face=Verdana size=2> </FONT></DIV> <p style="font-family: Arial;">Technology Director <br>Debraneys <br>+61 (0) 2 9529 0007 Office <br>+61 (0) 4 3050 6980 Mobile <br>www.debraneys.com</p> >-----Original Message----- >From: Mark Schonewille [mailto:[EMAIL PROTECTED] >Sent: Tuesday, October 2, 2007 08:42 AM >To: 'How to use Revolution' >Subject: Re: Filemaker through ODBC > >Hi John, > >Thanks for the reply. Was it an easy thing to do, or did you >encounter many problems before you were able to establish the >connection? > >Best regards, > >Mark Schonewille > >-- > >Economy-x-Talk Consulting and Software Engineering >http://economy-x-talk.com >http://www.salery.biz > >Quickly extract data from your HyperCard stacks with DIFfersifier. >http://differsifier.economy-x-talk.com > > >Op 2-okt-2007, om 0:40 heeft John Tregea het volgende geschreven: > >> Np Mark, >> >> I do have the FmPro <> ODBC <> Rev connection working but haven't >> pounded on it to see what the performance is like. >> >> Regards >> >> JOhn > >_______________________________________________ >use-revolution mailing list >use-revolution@lists.runrev.com >Please visit this url to subscribe, unsubscribe and manage your subscription >preferences: >http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution