Newbies enaim254 Posted May 16, 2006 Newbies Share Posted May 16, 2006 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 More sharing options...
Wim Decorte Posted May 17, 2006 Share Posted May 17, 2006 "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 More sharing options...
Newbies enaim254 Posted May 17, 2006 Author Newbies Share Posted May 17, 2006 Thanks for the info, now to write the software... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6554 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 accountSign in
Already have an account? Sign in here.
Sign In Now