CaelC Posted March 26, 2003 Share Posted March 26, 2003 I have a remote MS-SQL DB I am trying to "hook up to". I have an SQL person helping me as I am clueless here. We got a DSN assigned and I have scripted a series of imports from ODBC data source to bring data down from the web server via TCP-IP (I'm still having some trouble bringing in data from his stored procedures and/or join fields however). Apparently in Access, it is also easy to have the local DB act as an interface for the remote data source, even allowing UPDATING of data on the remote server. For example...I change a field value locally and it automatically changes on the server to match. 1. Is this possible in FileMaker? 2. Is it rocket science or can a competent FileMaker person do it without knowledge of SQL??? Please help! Thanks, Cael. Link to comment Share on other sites More sharing options...
cjaeger Posted March 26, 2003 Share Posted March 26, 2003 >I change a field value locally and it automatically changes on the server to match Don't do it. this really places a heavy load on the network and on the database. alsways work with submit buttons and possibly scripts to transfer several records/values at once. I use a closing script which transfers records that have changed since opening the file using global open/datetime fileds and local modification date/time. As for the rocket science: since you already have set up your dsn. the hard part is already done. Link to comment Share on other sites More sharing options...
CaelC Posted March 26, 2003 Author Share Posted March 26, 2003 Thanks. Do you just run a script with an Execute SQL step in there? What does the SQL step have to do? Does it replace all data in the remote records, or just changes to certain fields? Thanks, the help is appreciated! Cael. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7867 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