I found that a good way to cheat when building the connection string is to set up a file datasource (using the ODBC Control Panel applet) then concatenate each line with a semi-colon delimiter (of course, you'll need to change any lines to match the server environment where the data is stored)
--- Billy Cravens -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 3:34 PM To: CF-Talk Subject: Re: DSN-Less DB Connection First, you will want to create a connection string like so: <cfset DBPATH=ExpandPath("../../Database")> <cfset DBFile="Baby.mdb"> <cfset Driver="{Microsoft Access Driver (*.mdb)}"> <cfset ConStr="DRIVER=#Driver#;DBQ=#DBFile#;DefaultDir=#DBPATH#;UID=Admin;PWD=; "> You then want to set up your CFQUERY like so: <cfquery dbtype="dynamic" connectstring="#ConStr#" name="qAuthenticate"> Query goes here </cfquery> ---------- Original Message ---------------------------------- From: Anthony DeStefano <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 12 Apr 2002 13:17:51 -0700 Does anyone know the syntax to connect to an Access DB without a DSN? Also, are there any pros/cons to using DSN-Less connections. I have done it in ASP without any noticable performance issues, but I am not sure about how ColdFusion deals with it. Many Thanks, Tony Anthony DeStefano Programmer/Analyst Telect, Inc. (509) 893-4375 [EMAIL PROTECTED] ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
