The data source needs to be configured on the server that you are doing the
queries from. I would just automate configuring the datasource to the other
server and make sure that cf has permissions to that server.
Regards,
Howie
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 28, 2000 12:05 AM
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
