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
