Web+Center Support
29 Oct

Knowledge Base Detail

Case Summary: How to configure Web+Center running on 64 bit OS to use a 32 bit Access Driver
ID: 2586
Date Created: 10/30/2009
Last Modified: 10/30/2009
Problem Type: Problem Report
Item: Web+Center 6.0
Resolution:
One can easily run IIS in 32 bit mode rather than 64 bit by simply changing
the default application pool to "enable 32 bit" applications.

Thanks to an
article by Amy Blankenship on 64 bit Windows, IIS and Access
, this simple solution
basically runs IIS in 32 bit and then allows integrated 32 bit applications and drivers
such as the Access ODBC 32 bit driver to run. This will make all of the applications
of the default website run in this 32 bit mode.



To change IIS to run in 32 bit mode,



  • Open IIS manager and select the View Application Pools" on the right hand menu options








  • Select the Default App Pool
  • Click on Advanced Settings...





  • Simply change the "Enable 32 Bit Applications" flag from False to True.

  • Close IIS



Configure 32 Bit ODBC Drivers


By default on a 64 bit OS, the default ODBC Datasources setup is a 64 bit application
that only shows 64 bit drivers. Since Microsoft does not have a 64 bit Access driver so
you won't see any Access drivers available.



The 32 bit version of the ODBC database sources still exists on the 64 bit
machine, but you must run it separately using the START... RUN command with the file path:






    C:\Windows\SysWOW64\odbcad32.exe



Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com