Enable IIS to run 32-bit applications on 64-bit Windows

In Microsoft Windows Server 2003 R2 Standard x64 Edition(or any 64bit Windows)…connecting MS Access to ASP pages…by using following code<scripting language used is javascript>:
cn= Server.CreateObject(“ADODB.Connection”);
cn.ConnectionString=”DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= “+ Server.MapPath(“any.mdb”)
cn.Open;

gives error:
ADODB.Connection error ‘800a0ea9′
Provider is not specified and there is no designated default provider

As the MS Access driver is 32bit…and is being accessed by 64bit windows..
This error can be solved by:
1.Opening  command prompt and navigating to the directory %systemdrive%\Inetpub\AdminScripts
2.Typing:
cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true

Done!!

12 responses to “Enable IIS to run 32-bit applications on 64-bit Windows

  1. ...

    Great post, thanks!

  2. Some Dude

    You have to be careful, though – the app I currently maintain cannot run in 32-bit mode IIS. As always, that setting is a double-edged sword. Good post, though – I’m sure it is or will be useful to many!

  3. สุดยอด ขอบคุณครับ

  4. This website has got a lot of very helpful info on it! Thanks for sharing it with me!

  5. ibiruel Biruel

    CONGRATULATION! HELP ME ON BRAZIL :D THANKS!

  6. RacingTomcat

    Great Post. It saves me from re-installing the server as 32bit again! Thanks a lot !!

  7. Gokhan ALAGOZ

    Great post, thanks!

  8. Sergio Intenricola

    Many thanks also from me (Italy) !!!

  9. I’m now not sure the place you are getting your info, however great topic.
    I needs to spend a while finding out much more or working out more.

    Thank you for great info I was in search of this info for my mission.

  10. I enjoy what you guys are usually up too. This kind of clever work and exposure!
    Keep up the excellent works guys I’ve included you guys to our
    blogroll.

  11. Garmin nuvi 2555 gps lifetime

    Helpful info. Lucky me I found your site by chance, and I am surprised why
    this coincidence didn’t happened in advance!
    I bookmarked it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Twitter-What I am doing

  • Total 32 tremors of >=4.5 magnitude since yesterday in the Nepal area tinyurl.com/mcwuw86 7 hours ago
  • Difference between India and Australia cricket team is just the fast bowlers of the latter is better, utilized the conditions best 4 weeks ago
  • In cricket ,you can't underestimate any team/player.exceptional ,unexpected innings from Grant Elliott ...cool under pressure ! 1 month ago
  • Ordered Micromax Nitro A311 from flipkart got Rs.2700 off ..Hope its better than Samsung S3 1 month ago
  • Time to show super human ability of ABD again.. #fb 1 month ago

Pages

Archives

Current Month

June 2008
S M T W T F S
« Apr   Jul »
1234567
891011121314
15161718192021
22232425262728
2930  
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: