CFHTTP, esentially simulates a browser with a program (your program).
So, if you can communicate with both sites with a browser, then you can
do it with a CF program using CFHTTP.
To solve your particular problem, you could write a stub program for
each of the target sites (one in Perl and one in VBS).
The stubs would receive SQL Statements and data from your CF site (Form
post of a WDDX packet)
The stub would
1. deserialize the WDDX packet
2. issue the db request
3. serialize the results
4. return the results WDDX packet to the originator
I have used this technique with great success in populating and
synchronizing remote databases where I did not have admin privileges.
HTH
Dick
On Tuesday, June 25, 2002, at 08:33 AM, Yager, Brian T Contractor/NCCIM
wrote:
> I have not used this tag at all. But in an effort to get CF used where
> I work,
> I told them I could do what I'm about to ask. Please tell me if this
> can be
> done.
>
> There are two seperate systems in different states. On is an ASP/SQL
> Server and
> the other Perl/Oracle (Unix). There is a firewall in front of the Unix
> machine.
> We need to get feeds from each to the other to populate/sync up each
> database.
> Can CFHTTP do this? I also recommended XML (WDDX) but we don't have the
> expertise yet. If CFHTTP can work, can some one please describe how it
> works so
> I can discuss it in my next meeting?
>
> Thanks all,
>
> Brian Yager
> President - North AL Cold Fusion Users Group
> http://www.nacfug.com
> Sr. Systems Analyst
> Sverdrup/CIC
> [EMAIL PROTECTED]
> (256) 842-8342
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
