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!!

10 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.

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

  • ETV Bihar news,a man crying..because he wasnt able to vote though he had voter id(his name was not in voter list) :O 2 days ago
  • Election day..here in Patna..cant cast vote .:( 3 days ago
  • SL gawaar celebration :P 1 week ago
  • Sanga's wkt is India's match!!! 1 week ago
  • "Main tera hero" had headache watching the movie.. 2 weeks 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: