Hehehehe....I take it then there's no hope, maybe I'll create a web service in Visual Basic or C# that ColdFusion (either 5.0 or MX) can hit, that will parse your query and return the results in XML. That's what .net was built for anyways.
Gregory Harris [EMAIL PROTECTED] -----Original Message----- From: "Ken Beard" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Fri, 2 Aug 2002 15:34:54 -0400 Subject: RE: ColdFusion MX - Querying without ODBC > yeah.. decrypt the cfadministrator, steal the code for making/modifying > datasources, use that... cfregistry. > > ken > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 02, 2002 2:35 PM > To: CF-Talk > Subject: RE: ColdFusion MX - Querying without ODBC > > > 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 > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
