" 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine " on IIS 7?

I just solved another error message on one of the asp.net page on my IIS 7 server.

The message was:

'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

while my page tried to retrieve data from Access db and display the results.

I google'd the message and found that it was because my notebook is 64bit.

The solution is to set the Application Pool on IIS 7 to be true on 32 bit.

The following is the screen captures:

點左方的"檢視應用程式集區"

Then,

點 "設定應用程式集區設定值"

Then, activate the 32bit mode to True.

Then, refresh the page and the problem is solved. Yeah!
有網路真好!