[FX.php List] Is FMPSA 9 better than 8 for OBDC to mySQL?

[Anders Monsen]

Jonathan,

Sorry, forgot to mention the location and name of the Mac connector  
( thanks, Andy!).

Also, there are three options when you buy. If I remember correctly,  
there's a single license, a five or ten pack, and a server license for  
250 users. Price varies from ca. $30 to $400 for the different  
versions (we bought the server license as we have 20+ users for this  
solution).

Installation is fairly straightforward. You will need the host name or  
IP address of the MySQL server, the database name, and the username  
and password you plan to use to access that MySQL server. The first  
step is to create the access through the ODBC connector. Once this is  
done, you open the database and create a reference through your  
External Data Sources. You then will be able to pull the tables into  
your Relationships Graph. FileMaker will create new layouts for each  
external table that you add.

Anders

On Nov 12, 2008, at 8:48 AM, Andy Gaunt wrote:

> Jonathan,
>
> Anders is correct in that for Mac Servers you will need the Actual  
> Technologies ODBC Connector - http://www.actualtechnologies.com/
>
> Windows servers you can use the free ODBC connector.
>
> Cheers
>
> Andy Gaunt
> T: 321-206-3658
> andy at fmpug.com
> http://www.fmpug.com
>
> FMPug.com: A Developer's best Friend!
>
> FindFileMakerDevelopers.com -
> The #1 listings engine for FileMaker Professionals
>
>
>
>
>
>
> On Nov 12, 2008, at 9:41 AM, Jonathan Schwartz wrote:
>
>> Purchase ODBC connector?
>>
>> J
>>
>>
>> At 8:31 AM -0600 11/12/08, Anders Monsen wrote:
>>> We use ESS to sync up a FileMaker db with Joomla, and it works  
>>> quite well. For Mac users you will need to purchase an ODBC  
>>> connector, while on Windows you just need to configure a built in  
>>> connector.
>>>
>>> Just remember to not change the MySQL database name if you move  
>>> your database from one server to another server (ie. from test to  
>>> production).
>>>
>>> Anders
>>>
>>> On Nov 11, 2008, at 7:13 PM, Jonathan Schwartz wrote:
>>>
>>>> Looks like I need to sync up a user table in FMP 9 file with a  
>>>> Joomla CMS system (It uses mySQL).
>>>>
>>>> Am using FMPSA 8 and it looks like there is support for mySQL via  
>>>> ODBC, but support in FMPSA 9 appears to new and improved.
>>>>
>>>> Comments?
>>>>
>>>> Thanks.
>>>>
>>>> Jonathan
>>>> --
>>>> Jonathan Schwartz
>>>> Exit 445 Group
>>>> jonathan at exit445.com
>>>> http://www.exit445.com
>>>> 415-370-5011
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> -- 
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> http://www.exit445.com
>> 415-370-5011
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>