MaD2ko0l

hiya,

have just installed vusial studio 05 and everythign seems to work fine, apart from when tryign to connect to an access dataabse.

as the title says, i get thsi error

the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

i have read through never thign i can find about this and nothing has worked...i have tryed downlaoding the latest jet engine but i already had the latest. i have tryed registering the files using regsrv but nothing.

nothing has worked.

i didnt quite understand the stuff about x86 or a 64bit or whatever it was but i am running 32bit os, if that helps

anyway, its much appreciated for the help

MaD2ko0l



Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


Look for the file msjet40.dll. It should be in the System32 directory. If the file is present try using the regsvr32 utility to register the file.




Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

i have already done that, the file is present and it is the correct version but it still wont work



Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


Could you post your connection string code




Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

i havent made 1...what i have done is in the "server explorer" tab i have right clicked on "Data Connections > Add Connection" and selected "Microsoft access database file" i then fill in the info and press ok or test connection and it then gives me that error

hope that helps





Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

Code Snippet
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("database_path/database_name.mdb"))
dbconn.Open()
end sub
</script>

i have also just tryed the above code and got the same error.
 
also just noticed that this error is on my local machine, when i save and uplaod the file with the above code it works fine o nthe server machine.




Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

any ideas anyone

this is starting to piss me off





Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

*BUMP*



Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


Is this a web application If so, what level of authentication is the application configured for




Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

yes it is for a web application, what do you mean "what level of authentication is the application configured for " can you dumb it down a little for me please

MaD2ko0l





Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


Web applications can be configured for different levels of authentication via IIS (Internet Information Server). You can select Anonymous, Basic, Integrated Windows, etc.

As a result, the web application will run under different identities depending upon the security configuration. I'm speculating that the account under which the web application is executing (which is not the interactive account) may not be able to access certain files or Registry entries related to the Jet OLEDB Provider.






Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

so, how do i go about setting my account up to access these files that it cannot get to

or are you telling me that its just not going to work





Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


At this point I don't know because I don't have enough information about your configuration.

Can you connect with a .NET Windows application The answer to this question might shed some light on whether there is a permissions problem.






Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

MaD2ko0l

i get the same error when trying to make a connection to the database in the windows application.



Re: .NET Framework Data Access and Storage the 'microsoft.jet.oledb.4.0' provider is not registered on the local machine

Paul P Clement IV


You might want to take a look at the following MS KB article to see if there is anything there that helps:

http://support.microsoft.com/default.aspx/kb/239114