EasyCFM.COM ColdFusion Forums / MS Access Related Issues / Access 2007 connect problem

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Access 2007 connect problem

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

dragnegabriel
08-16-2010 @ 2:46 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 14
Joined: Jun 2010

hello! I'm just starting to learn CF and trying to connect to
an Access 2007 database to CF 9. Which driver should I use
to do this? An step by step approach would be greatly
appreciated. Thx!

megan
08-16-2010 @ 8:31 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

Are you on windows 7 ?? if so try this:

call the ODBC inside of Windows 7 C:\windows\syswow64\odbcad32.exe Register your data source there. Then see if you can register the datasource in the CF admin and validate.

hth ~megan

PS - I suggest you not be dependent on Access but instead download and install sql server express (no cost) and/or mysql and learn to use those databases



-------------------------------------------------------
"The chief cause of failure & unhappiness is trading what you want most for what you want now." ~Zig Ziglar


Website Designed and Developed by Pablo Varando.