Given that, what would you suggest? The situation is that I'm faced with an access database whose name will change based on user feedback. I suppose I could use the many CF_Datasource options to create and modify ODBC Datasources on the fly, however that seems like quite a bit to do, and does ColdFusion MX support Dynamic datasources in any way?
Also for extra credit we'd have to make this solution work in ColdFusion 5.0 as well. Today's challenge for the day, have fun! -----Original Message----- From: Dave Watts <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Fri, 2 Aug 2002 14:33:53 -0400 Subject: RE: ColdFusion MX - Querying without ODBC > > Hey there, say I have an access database at > > > > C:\items.mdb > > > > How can I query this database WITHOUT ODBC in ColdFusion MX. > > I've tried CFQUERY and typing in the path and file name in > > the datasource attribute to no avail. The ConnectString > > attribute didn't seem to help much either. > > I don't think you can. The CONNECTSTRING attribute is no longer > supported in > CF MX; neither is OLEDB. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
