FMP7 Pointer to SQL Server

[chrisL8work]

I need to establish a connection/pointer from FileMakerPro 7/FMP Server to SQL Server. I would like to have a FMP front end where users may utilize FMP but all updates will be reflected in the SQL Server, as well as any updates in SQL Server will be updated in FMP.

 

[lebisol]

updates will be reflected in the SQL Server"

as in all data will be stored in SQL?

look into ODBC connection...but most of the script will not apply..u would have to still execute SQL from FM.
Look under Scripts--Misc.--Execute SQL
You could designate some fields in FM file that will hold your SQL querries and statements and then run your sql like so.
Other option is exporting from FM and then importing into MSSQL server.
All the best!

:--------------------------------------------------------------------------:

All around in my home town,
They tryin' to track me down...

 

[chrisL8work]

Thanks for all the help. I'm going to give it a shot.