Hi, if I'm not mistaking then it is useless for the Server which has the SSL certificate installed to open a browser, so there is no need for your client to open a browser on their server.
Perhaps the scheduler could be of assitance here. There shouldn't be any problems posting and getting data from the client server using CFHTTP over SSL (not that I know of anyways). Having the process depend on two browsers being open seems rather risky to me. Hope this helps, Greetings > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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

