Is it possible to set up DSN-Less Connection in MX?
<cfset MyConnectString =
"Driver={Microsoft Text Driver
(*.txt;*.csv)};Dbq=d:\HospitalFormulary\;Extensions=txt,csv,tab,txt;Persist
SecurityInfo=False;">
<CFQUERY
name="TheTest"
DBType="dynamic"
ConnectString="#MyConnectString#">
I am getting the error below:
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, cachedafter, cachedwithin, debug.
The Error Occurred in D:\Inetpub\wwwroot\test.cfm: line 17
15 : <cfset MyConnectString =
16 : "Driver={Microsoft Text Driver
(*.txt;*.csv)};Dbq=d:\HospitalFormulary\;Extensions=txt,csv,tab,txt;Persist
SecurityInfo=False;">
17 : <CFQUERY
18 : name="TheTest"
19 : DBType="dynamic"
tia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202943
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
