I m sure <CFQUERY> tag CF MX 7.0 does not support connectstring attribute.
Can you ask support at GoDaddy to create a CF Admin Data Source for you for this access file you are trying to access and use that DSN instead in your Query tags..? Thanks. -S -----Original Message----- From: Betsy McDonald [mailto:[EMAIL PROTECTED] Sent: Saturday, December 16, 2006 11:03 PM To: CF-Newbie Subject: Re: Godaddy/DNS connection problems Okay, I'm back... but still feeling clueless. After my grappling with this for a while, a kind friend advised me to connect through ODBC. So I've been looking around, trying to get my new string to work and still not having success. Still using Microsoft Access (building on dreamweaver dx). Godaddy offers me the ColdFusion MX 7 Enterprise Edition. First I tried this code, which was offered here at HoF to someone in similar straights: <CFSET sConnectionString = "Driver={Microsoft Access Driver (*.mdb)};"> <CFSET sConnectionString = sConnectionString & "Dbq=c:\mydatabase.mdb;SystemDB=c:\access_db\mysecurity.mdw;"> <CFSET sConnectionString = sConnectionString & "Uid=x;Pwd=y"> <cfset CurrentPage=GetFileFromPath(GetTemplatePath())> <cfparam name="PageNum_catalog" default="1"> <CFQUERY NAME="recordset" DBTYPE="dynamic" CONNECTSTRING="#sConnectionString#"> ...... etc.... </cfquery> And received this error: --------Attribute validation error for tag query. The tag does not have an attribute called connectstring. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug------------ Now have switched to this code (from livedocs.macromedia.com): <cfset CurrentPage=GetFileFromPath(GetTemplatePath())> <cfparam name="PageNum_catalog" default="1"> <cfquery name = "recordset" dbtype=dynamic connectstring="DRIVER = {Microsoft Access Driver (*.mdb)}; SERVER=(local); Dbq=c:\mydatabase.mdb; SystemDB=c:\mysecurity.mdw; UID=x; PWD=y"> .... etc.... </cfquery> To which I get the same error. I feel like I'm just on the verge of finishing this. Can anyone give me a hand & tell me what I've done wrong? Betsy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2354 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
