ASP - Using MS Access/ODBC in Windows 7 / 64-bit OS

I have just installed WIndows 7 and would like to run IIS to edit a few old ASP/M$ Access applications.
When I try to setup the Access database in the ODBC admin, it doesn't have drivers for MS Access - only SQL Server.

Any ideas how to correct this?

Thanks!
cuadminAsked:
Who is Participating?
 
rdivilbissCommented:
AFAIK, there are no 64 bit drivers for Access, ergo the previous recommendation.

Assuming you are running the web app in a 32 bit application pool, then downloading the latest MDAC should get you the drivers you need.

You should know that MS advises to use the OLEDB drivers over ODBC due to stability, features, and speed.
0
 
rdivilbissCommented:
Yes, you'll have to setup a 32 bit application pool for your web app.  Your not the first person to hit this wall.

Rather than tell you from my faulty memory I'll offer a link to how to set this up.

http://www.bibble-it.com/2008/06/09/32bit-web-app-inside-64bit-website-iis-70

Regards,
Rod
0
 
cuadminAuthor Commented:
rdivilbiss,

Thanks for the comment... my app actually works fine, it's just that I've been unable to setup my data connection (MS access) - therefore I get errors on any page that references my DB connection - ODBC Driver Manager] Data source name not found and no default driver specified.

When I go to system DSN, click add, the only driver there is the MS SQL driver.
I've tried launching the odbcad32.exe  - same problem.

In the USER DSN - there is a MS Access driver listed. When I click configure, I get:
the setup routines for the microsoft access driver odbc driver could not be found.

Any ideas?

Thanks,

E.D.
0
 
cuadminAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.