Jump to content

SQL ODBC dynamic connection


enaim254
 Share

This topic is 5681 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Is there any way filemaker can have a permanent connection through ODBC into sql. So that when new entries come into the SQL Server 2005 they automatically update in filemaker, without using the import function in filemaker. Also if anyone knows of a better way to do this I'm all ears.

Link to comment
Share on other sites

"automatically" implies event triggers (actions are taken based on events, like the creation of new entries in SQL). FM doesn't have events unless you use a plugin. With a plugin you'd still have to open a connection to the SQL db, check for new entries and get them in.

If I needed to do this I'd probably write a little piece of middleware that checks the SQL db on a schedule and when new entries are found, pushes them directly to FileMaker Server (Advanced, through either ODBC or the XML interface).

Using a plugin means that you'd need a FMP client machine doing the checking. The server based approach is more robust.

Link to comment
Share on other sites

This topic is 5681 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.