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:2353
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