cuadmin
asked on
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!
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!
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
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