Jorge, >From the FM9 Training Series manual, a few quick comments about the >differences between ODBC and ESS:
FileMaker can connect to any ODBC datasource for which there is a driver availiable. You can import data from the ODBC data source into FileMaker but cannot modify* the data in the source itself with ODBC. ODBC must be setup on each user machine individually. *Modifying the parent data source requires use the Execute SQL script step--which may be difficult to implement. ESS currently works with a couple flavors of Oracle, MySql and Sequel Server, permitting two-way linking much like that between tables inside filemaker. It only needs to be setup one time on the FM Server itself. FileMaker website has information about which versions are supported. -- Steve Gerow FileMaker 9/8/7 Certified Developer President Abrazos Data Consulting, Inc. Pasadena, California Member FileMaker Bus. Alliance > -------Original Message------- > From: Jorge Biquez <[email protected]> > Subject: FileMaker and ODBC > Sent: Dec 12 '08 16:33 > > Hello all. > > I have a client that wants a small application that works on a LAN > (FMS solves that) but that at the same that exchange information with > its existent application developed with VB6 and VB 8 (Net?). All the > information is running with SQL Server and under Oracle (VB6-SQLSvr, > VB8-Oracle). > > I thought that one way to solve is to use the ODBC connection of FM > and that some programs of VB do that. > > Do you think that is a good approach? Client of course wants to > continue using the existen application but is greatly impressed of > what he has seen that can be done with FM. Mainly the faster development . > > Any comments based on experience are very welcomed. > > Thanks in advance > > LSCA Jorge Biquez >
