AllExperts > Experts 
Search      

Active Server Pages Programming (ASP)

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More Active Server Pages Programming (ASP) Answers
Question Library

Ask a question about Active Server Pages Programming (ASP)
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Srini 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.
 
   

You are here:  Experts > Computing/Technology > Business Software > Active Server Pages Programming (ASP) > DSN Connection In ColdFusion to Access

Topic: Active Server Pages Programming (ASP)



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.  

Answer
hi

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

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.