Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 31st, 2010, 07:17 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default IIS 7.5 running 32 bit applications

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
__________________
Wind is your friend
Matt

Last edited by mat41; October 31st, 2010 at 07:19 PM..
Reply With Quote
  #2 (permalink)  
Old October 31st, 2010, 09:17 PM
J_P J_P is offline
Authorized User
Points: 48, Level: 1
Points: 48, Level: 1 Points: 48, Level: 1 Points: 48, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2009
Posts: 12
Thanks: 0
Thanked 1 Time in 1 Post
Default

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


this group is more focused on just classic ASP
Reply With Quote
  #3 (permalink)  
Old October 31st, 2010, 11:01 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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.
__________________
Wind is your friend
Matt
Reply With Quote
  #4 (permalink)  
Old November 1st, 2010, 03:03 AM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

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
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #5 (permalink)  
Old November 1st, 2010, 05:56 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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!
__________________
Wind is your friend
Matt
Reply With Quote
  #6 (permalink)  
Old November 2nd, 2010, 03:06 AM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

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
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual studio 2005(32 bit) code not work in visual studio 2008 on windows server 2008 gr8.jain Visual Basic 2008 Essentials 1 August 31st, 2009 10:07 AM
Running external applications from access thisgent Access VBA 2 July 9th, 2007 05:03 PM
get names of all Applications currently running gs2000 VB How-To 2 November 27th, 2006 07:20 AM
64 Bit - Issue in 64 bit IIS calling Win32 API Hubman General .NET 1 August 24th, 2006 09:19 AM
Running application at IIS marjanm Beginning PHP 1 July 26th, 2004 12:56 AM



All times are GMT -4. The time now is 06:33 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.