I have a more complicated solution (VB progamming) - but am wondering if this CF solution will work.
The scenario - I have a SQL table that needs to be replicated (changed data only) to a remote client's db every 5 minutes. (The data is credit applications.) At the same time, I need to check to see if they have new data for me (approvals, etc) and GET that. The simple thing would be SQL replication using a VPN, but they're insisting on using SSL for the transmission security. I don't know how to make SQL use SSL, so here's my thought: We load a CF page into our browser on our server. They open a session connection with this page on theirs, also using a browser. We refresh the page every 5 minutes - many ways to program that (CF, JS, etc). Functions of the page: 1) run a query for new data 2) use CFHTTP to POST any new data to a form or CGI script on their end 3) use CFHTTP to GET any new data on their end and return to our DB If we run the browsers continuously, we can maintain an open session.....and we only have to re-establish the connection when one of the servers is re-started. Does this make sense, is it feasible, and am I overlooking something critical? TIA!! ~D ************************ Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

