IIS 7.5 running 32 bit applications

mat41 · October 31st, 2010, 07:17 PM

Good day..

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:

http://blogs.msdn.com/b/rakkimk/arch...processes.aspx

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:

http://forums.iis.net/t/1154334.aspx

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?

TYIA

J_P · October 31st, 2010, 09:17 PM

you may want to post this to an iis group
specifically.

this group is more focused on just classic ASP

mat41 · October 31st, 2010, 11:01 PM

I did think about that. My appologies, you are probably correct...

That said, I guess the reason I placed it here is - All classic ASP people (even though we are a dying breed) need, and do know about IIS. IMO the answer to this post will be very useful to any ASP person who is EG connecting to an Access DB using ODBC on a 64bit machine.

Imar · November 1st, 2010, 03:03 AM

Hi Matt,

Did you turn on "Enable 32-Bit Applications" for the application pool? I've been having similar issues with a CMS that uses an Access database under the hood, and turning on that feature has always worked for me.

Cheers,

Imar

mat41 · November 1st, 2010, 05:56 PM

Hi Imar - Thankyou for your time....

90% of posts suggets this however when I dig deeper into, what has become a monster issue, it appears Exchange 2008 does not like any of the application pools running with 32bit setting set to true. Even though you would create a seperate pool

All of the research out there is relative to getting Access running. There is very little, alomost none which relates to my specific issue, this being, getting the My Own Business (MYOB) ODBC driver which is 32bit working in a 64bit environment. Please note - MYOB is an Australian accounting software package, a huge percentage of the country uses it. Yes I am in contact with MYOB, its a new issue for them, they do not have a solution yet.

here is the most useful info I have found. BTW - the suggested solution tells you how to run Access without setting the Enable 32bit to true:

http://digitallibraryworld.com/?p=6

Also vewry useful:

http://learn.iis.net/page.aspx/563/u...70-and-iis-75/

However these solutions, including Imars do not fix my issue. The runtime error is:

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

I am beginning to think the driver I am working with simply will not work in this 2008 location. Yes I have also tested the DSN with a test connection utility which works.

A bit stuck!

Imar · November 2nd, 2010, 03:06 AM

Quote:

it appears Exchange 2008 does not like _any of the application pools_ running with 32bit setting set to true. Even though you would create a seperate pool

That's pretty weird. I thought the whole idea of application pools was isolation.

Ran out of other ideas, sorry. Enable 32 Bit on the app pool has always worked for me, so I never investigated other solutions.

Cheers,

Imar