One way is to put a stub program on A. The stub program receives a WDDX packet containing the SQL Statements from your program on B,
The stub program issues the SQL commands against its db and returns the result set through another WDDX packet. I do this all the time to setup/manipulate client dbs where I don't have admin privileges to the client's site and db. server B: Serialize SQL Commands server B: cfhttp post WDDX to stub on server A server A Stub: Invoked by cfhttp post server A Stub: Deserialize WDDX SQL statements server A Stub: Issue SQL statements against server A db server A Stub: Serialize and return SQL result set to cfhttp request server B: deserialize SQL result set returned from cfhttp request server B: process result set as if normal query HTH Dick At 11:16 AM -0500 12/15/01, Joe Tartaglia wrote: >Here is my problem: > >The code for my main site resides on Web Server A. >This server is running ColdFusion 4.5. > >Some payment forms need to be on a secure server (Server B). >Server B is running ColdFusion 4.0 > >Questions: >1. How can I access a CF datasource that is set up on > Server A from the code on Server B? > >2. What problems might I expect due to the fact that > Server A and B are running different versions of CF. > (My code is very generic and was originally written > and functions under CF Ver. 4.0) > >Thanks in advance. > >Joe Tartaglia >High Caliber Systems >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
