Hi, I need some help here with the ODBC connection. I've set up the database and datasource so i have the database name, datasource name, user and password for the SQL database but it's all on a different server from where the application actually is. So now my problem is that i want to set up my application.cfm file so that it connects. What i have now is: <cfset DS = "AB1885000_nfc"> how do i set the rest up such that it can enter the username and password and the dataserver ip address? Thanks
===== Heidi Belal www.code-corner.com ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
