reccommendation for external data sources
I'm trying use my hosted FileMaker Database as a data sourcebut I only have FileMaker server 9, not advanced. I'm using FileMaker 9 pro advanced. I'm wondering if anyone has any suggestions as to what method/technology they use to make this happen. Looks like I'm limited to these options:
1) Using FileMaker Pro, I want to submit SQL queries or statements to an ODBC data source.
2) Using an ODBC client running on a local client, I want to submit SQL queries or statements to a FileMaker Pro database.
Any thoughts guys? Also, how much does the upgrade from FileMaker server 9 to either FMServer 9 Advanced or FMServer 10 advanced?