How do I use a DSN-less Connection with ColdFusion MX

To simulate the functionality of a DSN-less connection, it is necessary to create a "passthrough" database. To configure this for Microsoft Access, use the following steps:

1. Create an empty Access database.
2. Create a support request and have us add a data source in the ColdFusion Administrator, pointing to the empty database created in step 1.
3. Use the IN clause within the query, specifying the path to the actual database to be used.

SELECT FirstName
FROM Employees
IN 'd:\yourpathinfo\cfsnippets.mdb'

Add Feedback