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

Reply via email to