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