AboutSrini Nagarajan Expertise I can answer any kind of questions in ASP.NET, C#, VB.NET, SharePoint 2007, ASP, Coldfusion, Powerbuilder 7.00 / 8.00, JAVA servlets, MS SQL 2000 / MSSQL7, Sybase
Experience Contact me if you need any custom development on ASP.NET, ASP, SharePoint 2007, Coldfusion, Powerbuilder.
Expert: Srini Nagarajan Date: 7/6/2005 Subject: DSN Connection In ColdFusion to Access
Question Srini:
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.