Filemaker through ODBC

[John Tregea]

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:m.schonewille at economy-x-talk.com]
>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 at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution
>