When I am debugging a vb.Net 2008 windows application and click on the 
'next' button, I am getting the following error:
  'An unexpected error has occurred. The 'Microsoft.jet.oledb.4.0'provider is 
      not registered on the local machine'. 

 I think that I  may need to change some setting I have in the visual 
studio.net
2008 professional edition to solve this problem.

  I am working on an workstation that is 64 bits, XP operating system. When 
the click event has occurred, I have just attached an excel 2003 spreadsheet 
to a file in the general directory structure prior to clicking on the 'next' 
button.
  This application runs fine in production, this error just occurs in debug 
mode.
Thus can you tell me what I could change to fix my problem?

Am 02.07.2010 00:04, schrieb midnight:
>   When I am debugging a vb.Net 2008 windows application and click on the 
> 'next' button, I am getting the following error:
>   'An unexpected error has occurred. The 'Microsoft.jet.oledb.4.0'provider is 
>       not registered on the local machine'. 
> 
>  I think that I  may need to change some setting I have in the visual 
> studio.net
> 2008 professional edition to solve this problem.
> 
>   I am working on an workstation that is 64 bits, XP operating system. When 
> the click event has occurred, I have just attached an excel 2003 spreadsheet 
> to a file in the general directory structure prior to clicking on the 'next' 
> button.
>   This application runs fine in production, this error just occurs in debug 
> mode.
> Thus can you tell me what I could change to fix my problem?

Is the production machine also 64 bit? What is the compile target for your
app (AnyCPU, x86, x64)?

The Jet engine is not available as a 64 bit version. You must compile your app
as a 32 bit application.
(configuration manager -> "active platform:" <New...> -> "new platform:" x86,
check "[X] create new project platform" -> OK)



-- 
Armin