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!!
Great post, thanks!
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!
It killed the intranet for me. Getting “Service Unavailable” and cannot find in the adsutil.vbs where the edit was made. HELP!!
สุดยอด ขอบคุณครับ
This website has got a lot of very helpful info on it! Thanks for sharing it with me!
CONGRATULATION! HELP ME ON BRAZIL 😀 THANKS!
Great Post. It saves me from re-installing the server as 32bit again! Thanks a lot !!
Great post, thanks!
Many thanks also from me (Italy) !!!
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.
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.
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.
Me ha molado tu escrito. Desde hace 6 meses que padezco
lo mismo. Saludos.