One solution possible is to use a WDDX stub program as follows:
Local Server Remote Server
====================== ==========================
Application Program
--------------------
.
.
.
Compose SQL Query
WDDX Serialize Query
URL Encode Query
CFHTTP POST WDDX Packet --------> WDDX Stub Program
------------------
Deserialize WDDX Packet
Issue SQL Query
Receive CFHTTP.FileContent <--------- Serialize Query Results
Deserialize Query Results
.
.
.
Process Query Results as normal
.
.
.
The application program does everything, except it harvests the SQL
Query results from the remote server.
The WDDX stub receives a (serialized) SQL request and returns a (serialized)
SQL Query record set.
The WDDX Stub can be written in any programming language which
supports WDDX (CF, ASP, Perl, etc.)
Using WDDX packets avoids any problems with special data formats or content
HTH
Dick
At 11:14 PM -0800 12/27/00, Warrick, Mark wrote:
>The file uploading and transfering to another site can be handled with CFFTP.
>
>The querying of a remote datasource could be handled with XML, WDDX,
>and possibly CFHTTP if you can load a script onto the remote server
>with CFFTP (or whatever).
>
>---mark
>
>--------------------------------------------------------------
>Mark Warrick
>Phone: (714) 547-5386
>Efax.com Fax: (801) 730-7289
>Personal Email: [EMAIL PROTECTED]
>Personal URL: http://www.warrick.net
>Business Email: [EMAIL PROTECTED]
>Business URL: http://www.fusioneers.com
>ICQ: 346566
>--------------------------------------------------------------
>
>
>> -----Original Message-----
>> From: ibtoad [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, December 27, 2000 9:05 PM
>> To: CF-Talk
>> Subject: RE: Repeat Question still needing help
>>
>>
>> I want to upload files at a particular website but store them at
>> a seperate
>> server where we have additional storage space. We would also like to be
>> able to query that database through our main site. So how can write a
>> query to a datasource that is on a seperate server?
>>
>> Rich
>>
>> -----Original Message-----
>> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, December 27, 2000 6:16 PM
>> To: CF-Talk
>> Subject: RE: Repeat Question still needing help
>>
>>
>> I'm curious. What does CFFILE have to do with a remote database?
>>
>> Perhaps you could explain the problem in more detail?
>>
>> Maybe you've even got a technical spec? (crosses his fingers)
>>
>> ---mark
>>
>> --------------------------------------------------------------
>> Mark Warrick
>> Phone: (714) 547-5386
>> Efax.com Fax: (801) 730-7289
>> Personal Email: [EMAIL PROTECTED]
>> Personal URL: http://www.warrick.net
>> Business Email: [EMAIL PROTECTED]
>> Business URL: http://www.fusioneers.com
>> ICQ: 346566
>> --------------------------------------------------------------
>>
>>
>> > -----Original Message-----
>> > From: ibtoad [mailto:[EMAIL PROTECTED]]
>> > Sent: Wednesday, December 27, 2000 12:50 PM
>> > To: CF-Talk
>> > Subject: RE: Repeat Question still needing help
>> >
>> >
>> > Access Database. I want to be able to upload files using cffile on our
>> > website and store them on a seperate server.
>> >
>> > Rich
>> >
>> > -----Original Message-----
>> > From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
>> > Sent: Wednesday, December 27, 2000 3:22 PM
>> > To: CF-Talk
>> > Subject: Re: Repeat Question still needing help
>> >
>> >
>> > What kind of database? In general you can access a desktop or
>> > SQL database
>> > if you configure it properly in ODBC. For desktop DBs I'm pretty
>> > sure that
>> > the ColdFusion service needs to be logged in as a user with
>> rights to the
>> > other server.
>> >
>> > Regards,
>> >
>> > Howie
>> >
>> > ----- Original Message -----
>> > From: "ibtoad" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
>> > Sent: Wednesday, December 27, 2000 3:05 PM
>> > Subject: Repeat Question still needing help
>> >
>> >
>> > > Can I query a database from a different
>> > > server if I have the datasource name and the full server root?
>> > >
>> > > Any suggestions would be great,
>> > > Rich
>> > >
>> > >
>> >
>>
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup
from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit
SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
