Heidi You can set all the parameters in the CF administrator when creating the connection. If you don't want all settings set in the administrator, you can pass username and password in <cfquery>. The server and dbname HAVE to be set in the ODBC.
<cfquery name="qTest" datasource="#DS#" username="#username#" password="#password#"> If you are using CF5, you can use the attribute 'connectstring' to establish the connection. The connection is created every time you use the DSN in a database tag (cfquery, cfstoredproc, cfinsert, cfupdate). Coldfusion can reuse an existing connection for that depending on your settings in the ODBC or create a new one if none is available. Hope this helps Pascal -----Original Message----- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 11:21 To: CF-Talk Subject: ODBC connection 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
