Active Server Pages Programming (ASP)/DSN Connection In ColdFusion to Access
Expert: Srini Nagarajan - 7/6/2005
QuestionSrini:
I hope you can help.
I am using ColdFusion and unable to create a connection to an access data base.
I followed the instructions in an MS article number 305599, as well as the recipe in CF Administration.
But when I attempt tp create a Recordset, CF asks me for a Login and Password which I continually fail for some reason.
Could you guide me thru a foolproof series of steps to fix my problem and allow me to access the DB.
Where do I create the login and password for the query.
Also, do I need to create the DSN in both XP and in CF.
This process should be a no brainer, but I have been on it for a whole day.
Hope you can help.
Nick M.
Answerhi
give a try like this
<CFQUERY NAME="rs"
DBTYPE="dynamic"
CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\db\mydb.mdb;Uid=Admin;Pwd=;"
>
SELECT SeekId, SeekUsername, SeekPassword from Seekers
</CFQUERY>
Happy programming!
-srini