If you are running CFAS 5.0:

<cfquery name= "q"
  dbtype="dynamic"
  connectstring="DRIVER={SQL SERVER};SERVER=;UID=;PWD=;DATABASE="
  blockfactor="100">
   ...
</cfquery>

FYI: Connect string properties are specific to the database you are
connecting to

HTH,

Joseph DeVore
VeloxWeb Technologies


-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:17 PM
To: CF-Talk
Subject: XLS as a DSNless Connection


Hi All,

Does anyone have a code snippet that shows how to connect to an excel spread
sheet as a dnsless connection?

Thanks,
Duane

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to