Hey everyone,

I recently bought a new dev machine primarily for .Net but I still have a number of classic Asp apps to support. My new system has Vista Ultimate 64 bit installed, with IIS 7. I use Access DSN's for my old asp apps, but when you run the ODBC manager to create DSN's there is nothing available for all the old drivers that were available in XP and prior.

From what I can tell it's an issue with a lack of 64-bit drivers for the various databases, but I can't seem to find a clear-cut answer on the issue.

Anyone else have this problem and a solution for it?

For anyone interested, I found the solution to this problem. I'm running the 64 bit version of Vista Ultimate so the ODBC manager only presents DSN options that are 64 bit. All the old odbc drivers are 32 bit, and fortunately there's a 32 bit ODBC manager included.

If you run c:\wndows\syswow64\odbcad32.exe you'll be able to create dsn's for all the old odbc drivers that we were used to seeing.

Once your dsn is setup, you need to run IIS manager and change the application pool your site is running in to 32 bit mode. If all your sites are running under the default application pool, then change that one. Just right-click on it and follow the options, and select 32 bit.

Your app should be able to access the odbc dsn.