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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cuadminAuthor Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.