Here is the answer to this question (regarding use of the ODBC driver for FileMaker ESS):
1. if using FileMaker client and not FileMaker server, I need to install the driver on EACH client machine; if need for 5 different clients, I need to purchase the up to 5 connections driver and install it on each machine.
2. if using FIleMaker server I need to only install the driver Server Edition - for FileMaker Server and web servers on the FIleMaker Server machine
3. if I want to be able to see my SQL database via FileMaker ESS from my iPad FileMaker Go - I need to have the driver installed on FileMaker server
FM looks for the driver and DSN on the machine where the FM database is hosted. When the FM database is hosted on FM Server, FM Server will make connections to the SQL database on behalf of the connected FMP or Go clients.
PointInSpace.com allows ESS connections to locally hosted MySQL databases on their shared hosting accounts. If you need to connect to a 3rd party datasource, then you would need a virtual dedicated server to do so.
On May 8, 2014, at 6:00 PM, FMPRO-L automatic digest system <[log in to unmask]> wrote:
> There is 1 message totaling 61 lines in this issue.
>
> Topics of the day:
>
> 1. Having FileMaker Go 13 see SQL database fields via ESS
>
> ----------------------------------------------------------------------
>
> Date: Thu, 8 May 2014 08:38:55 -0700
> From: John Weinshel <[log in to unmask]>
> Subject: Re: Having FileMaker Go 13 see SQL database fields via ESS
>
> Most providers offer dedicated servers, at higher rates than their
> fractional services, that allow you fairly full access to the machine,
> including installing and deploying ODBC drivers. Check with the provider.
>
> If the providers are using Windows servers, you'd use the driver provided
> by the SQL vendor.
>
> John Weinshel
>
>
>
> On 5/6/14, 1:52 PM, "Tami Williams" <[log in to unmask]> wrote:
>
>> Trying to get confirmation that this is only possible if use the
>> ActualTech ODBC driver installed on FileMaker Server.
>>
>> Is that correct? Or is there some other way for FileMaker Go 13 to see
>> SQL database fields?
>>
>> Do any FileMaker hosting providers allow the ActualTech ODBC driver to be
>> installed on FM server?
>>
>> Thanks in advance.
>>
>>
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> "It's better to burn out than to fade away."
>>
>> Tami Williams
>> Creative Computing
>> Let us help you make frustrating, costly, and inefficient processes more
>> efficient, less costly and scalable.
>> Lasso, MySQL and FileMaker specialists.
>>
>> Tel/Fax: 770.457.3221
>> E-Mail: [log in to unmask]
>> Web: http://www.asktami.com/
>> LinkedIn: http://www.linkedin.com/in/asktami
>> Twitter: http://twitter.com/asktami
>> iChat/AIM/Skype: tamiwilliamsusa
>>
>> FileMaker Business Alliance Member | Lasso Professional Alliance Member |
>> Certified Lasso Developer | FileMaker 11 & 12 Certified Developer
>>
>> ------
>>
>> If you want to receive sporadic email from Creative Computing regarding
>> news at the company and announcements about upcoming Lasso webinars and
>> online classes, please opt-in at http://tinyurl.com/yj7eqlg
>
> ------------------------------
>
> End of FMPRO-L Digest - 6 May 2014 to 8 May 2014 (#2014-17)
> ***********************************************************
|
