The way 8 and 9 can work with SQL sources is pretty different.
With 7 + 8 you have to import the data from the SQL source, using an
ODBC connection. This can be slow for large data sets. You then have a
copy of the data in a FM table.
With 9 you have the option to use ESS which is a nearly live connection
to the SQL source. Your ODBC setup can be done on the server, which
simplifies things. But the new ESS only works with a few data sources.
Whereas the ODBC import can work with far more data sources -- basically
on source you have an ODBC driver for.
One of the tricker parts of the whole process is getting the ODBC
connection to work -- so you can practice this with 8 and presumably
mySQL on Linux -- but the details may well be different on your clients
setup.
In 9 once you have the ODBC connection, it is easy, but slightly counter
intuitive to setup an ESS table. You first make an external data
connection, then add the table to the relationship chart, then a FM
table is automatically created for you. Then it is normal FM.
Hope this helps somewhat
Forbes
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]] On Behalf Of Colm
Sent: Tuesday, July 31, 2007 1:39 PM
To: Filemaker Experts
Subject: beginners odbc question
Hi Experts
I am running OS 10.4.10 and FMPA 8.0 on my iBook G4, which is
networked to an Ubuntu Linux server box.
I have a potential client who are currently using FMP 6 and FMP
Server 6, but wish to upgrade to 9. They have an SQL database (don't
yet know more details of flavour or OS) which they wish to query from
FMP 9. (As far as I am so far aware, they only want to import data
into the FMP database, and not export.)
I am somewhat out of my depth here!
Is it worth my setting up a trial run of this using FMP 8 and Ubuntu
at home, or do 8 and 9 act so differently that it wouldn't be of any
use? And would it very different again if, say, they were using
Windows instead of Linux?
I've read what I could find on FMP 7 ODBC access in the two books I
have (FMPro 7 Bible and Special Edition Using FileMaker 7), but this
has only given me a very basic overview. Are there any sources of
information on the web for this, or will I need to buy a book?
If so, could I get away with buying a book for FMP 8, or would I
really need the 9 version (which wouldn't be so much use to me
personally until I buy FMPA 9)? I suppose, if it clearly marks what
is new in 9, then a 9 book would be just as useful to me even before
I buy a copy of FMPA 9.
TIA
Colm
--
To unsubscribe: send an email to <
[hidden email]>
Archives:
http://www.nabble.com/FMPExperts-f735.htmlFMPexperts is hosted by Ironclad Networks <
http://www.ironclad.net.au/>
--
********************************************************************************
The information in this email and any files transmitted with it is confidential
and may be legally privileged. It is intended solely for the addressee and
others authorised to receive it.
If you are not the intended recipient,, any disclosure, copying, distribution or
action taken in reliance on its contents is prohibited and may be unlawful.
Prospects Services Limited is a limited company registered in England and Wales.
Reg No: 3042176
Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1 1LT.
If you have received this email in error please notify:
[hidden email]
http://www.prospects.co.ukThis footnote also confirms that this email message has been swept for the
presence of computer viruses
********************************************************************************
--
To unsubscribe: send an email to <
[hidden email]>
Archives:
http://www.nabble.com/FMPExperts-f735.htmlFMPexperts is hosted by Ironclad Networks <
http://www.ironclad.net.au/>