October 31st, 2010, 11:04 PM
Friend of Wrox
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Thanked 14 Times in 14 Posts
IIS 7.5 running 32 bit applications
I have an application which has been very happy sitting in a 2003 server environment. A classic ASP app which uses an ODBC driver to connect to the MYOB accounting software. It took alot of effort to get the driver called MYOAU0801 issued from MYOB for the Premiere 12 version going a while back.
We have moved to a 2008 server with IIS 7.5 - After creating the System DSN I get this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
it turns out the 2008 machine is 64 bit and the driver is 32. Research tells me the solution is:
This solution is all over many sites. This fails for me. The cause is the defaultAppPool stops when runnig a browser. This link tals about exactly this:
Now I have been looking for days and can not find a solution. has anybody got any advice on how to allow 32bit and 64 bit to run for a site inside iis7.5?