----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 5:54 PM
> How do you query a SQL database on another server?
>
> Is it just a matter of setting up the datasource in the CFQUERY different?
The datasource reference remains the same - the only difference is the location
of the SQL database the datasource points to - that can be either local or on
another server - the CF code is the same.
The DSN is setup in CF Administration, where you can specify the machine and
database name, and the login details. You will need to use an SQL login, which
means setting up an SQL login, assigning that login as a database user, and
pointing the DSN at that machine, database, login and password.
HTH.
Adrian Cooper.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
