I'm trying to create a query in a Cold Fusion webpage. I'm hosting the data in an MS Access DB. Unfortunately, it appears as though creating a local dynamic connection to the database is no longer supported in any version of Cold Fusion over 5.0.
Can anyone tell me how I can "update" this query to conform to a more Cold Fusion 8 standard???
dbtype = "dynamic"
connectstring="DRIVER=Microsoft Access Driver (*.mdb);
SELECT * FROM tblQuotes
Note, I do not have access to update the ODBCs or DataSources or anything like that. I can simply update the pages, and drop an Access file in the folder. Is there any hope?