You just set up your ODBC data source on the server ...if the odbc data source can connect (their is usually a test button at the end of the process). Once the data source works .... their is no difference in your CF code. -eric ------------------------------------------------ Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 12:55 PM To: CF-Talk Subject: SQL How do you query a SQL database on another server? I do local querys on my Access DB's, and im thinking about setting up a MS SQL box or MY SQL box. Is it just a matter of setting up the datasource in the CFQUERY different? Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
