As said below, this has nothing to do with a query. It has to do w/ DSN setup.
Setting up the DSN will depend
upon the type of database you are using. I've done this a lot for SQL Server,
although don't want to go through
the trials of explaining it if youu aren't using it.
ibtoad wrote:
> Can you write me a sample query?
> Rich
>
> -----Original Message-----
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 11:32 AM
> To: CF-Talk
> Subject: RE: Query Question
>
> sure. you can make a DSN on machine 1 for a database on machine 2.
>
> -----Original Message-----
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 8:31 AM
> To: CF-Talk
> Subject: Query Question
>
> Is it possible to query a database on a different server? What I mean is
> can I have a template located at http://www.site1.com query a database
> located at http://www.site2.com assuming I have the propper user id and
> password?
>
> Thanks,
> Rich
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
