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