Missing MS Jet OLE DB Provider

[Guest]

I am using XP Professional with Visual Studio 2003 & Office 2002, there is no
Jet OLE DB Provider listed yet if I download the latest Jet update or MDAC a
message states my PC is up to date.

Please can anyone shed light on how to make this provider appear with my
other data link providers?

Thanks

Nora

 

[Miha Markic [MVP C#]]

Hi,

Did you install this stuff?
How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/kb/239114

 

[Mary Chipman]

I'm not sure what you mean by appear with the other providers. You use
the OleDb provider, and a connection string specific to the Jet
database you are using. You won't see a separate listing for it. If
you need a valid connection string, see
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#OLEDBManagedProvider
for a sample.

--Mary

 

[Guest]

Yup, I tried to install this Jet 4 update, but the installation states my
system has newer files than I am installing and the update is not needed.
Thanks for the suggestion.

Hi,

Did you install this stuff?
How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/kb/239114

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

I am using XP Professional with Visual Studio 2003 & Office 2002, there is
no
Jet OLE DB Provider listed yet if I download the latest Jet update or MDAC
a
message states my PC is up to date.

Please can anyone shed light on how to make this provider appear with my
other data link providers?

Thanks

Nora

 

[Guest]

Thanks for the connection string link, I haven't fully tested it, but there
are no wiggly lines to suggest it won't work.

My question remains, if I select 'Server Explorer' and click 'Connect to
Database' there is no option to connect to a Jet OLE DB. The only microsoft
providers I have are for MS ISAM, Data Mining Services, DTS Packages, SQL
Server and MS Directory Services.

Without the Jet provider, I cannot make use of the wizard to build the data
connection.

All suggestions welcom.

Nora

 

[Paul Clement]

¤ I am using XP Professional with Visual Studio 2003 & Office 2002, there is no
¤ Jet OLE DB Provider listed yet if I download the latest Jet update or MDAC a
¤ message states my PC is up to date.
¤
¤ Please can anyone shed light on how to make this provider appear with my
¤ other data link providers?
¤

It would appear that for some reason the Jet OLEDB Provider is not registered.

Search for a file called msjetoledb40.dll. It should be in your Windows /System32 folder. If you
have the file try registering it with Regsvr32:

Click Start, click Run, type regsvr32 msjetoledb40.dll in the Open box, and then click OK.

This should enable display of the provider in the Data Link Properties dialog. If there isn't a
wider problem this should fix the problem.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Mary Chipman]

OIC -- you are trying to run a wizard. Hopefully some of the other
suggestions in this thread helped you fix the problem.

--Mary

 

[Guest]

Thanks for the suggestion, I have registered the .dll, but it has made no
difference - I imagine it must have been registered already that if I type
'Imports system.Data.OleDB there is no sign of errors. It is simply absent
in the Server Explorer window. I have also tried upgrading to Office 2003
and reinstalling Visual Studio.net 2003, but to no avail.

All suggestions welcome.

Rebecca Eden

 

[Paul Clement]

¤ Thanks for the suggestion, I have registered the .dll, but it has made no
¤ difference - I imagine it must have been registered already that if I type
¤ 'Imports system.Data.OleDB there is no sign of errors. It is simply absent
¤ in the Server Explorer window. I have also tried upgrading to Office 2003
¤ and reinstalling Visual Studio.net 2003, but to no avail.
¤
¤ All suggestions welcome.
¤
¤ Rebecca Eden

Couple of other questions. First, are you a local administrator on this machine? It's possible that
there may be a Registry permissions issue that is preventing enumeration of the OLEDB providers.

Second, can you run a code snippet using the OLEDB provider?

Dim AccessConn As System.Data.OleDb.OleDbConnection
AccessConn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db1.mdb")

AccessConn.Open()

AccessConn.Close()


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

Thanks for taking an interest in this. Yes I am logged on as Administrator
and yes, the code snippet works fine. Any ideas?

Thanks

 

[Paul Clement]

¤ Thanks for taking an interest in this. Yes I am logged on as Administrator
¤ and yes, the code snippet works fine. Any ideas?
¤
¤ Thanks
¤

I'm out of ideas I'm afraid. There's obviously a configuration problem, I'm fairly certain it's
related to Registry settings but I don't know how it can be fixed manually.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

Reading "Professional Excel Development" by Steven bullen suggests that
Microsoft have "depreciated the provider"! "ADO version 2.5 is the last
version distributed with this provider" and suggests downloading it from the
Microsoft site. ... but i can't find it.... I find it quite unbelievable that
the OLE DB provider for Microsoft Jet isn't available after Office 2000!

 

[Robbe Morris [C# MVP]]

Are you sure you can't use the System.Data.OleDb namespace to
access Excel? I've done this recently without issue using Office 2003.

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

 

[Paul Clement]

¤ Reading "Professional Excel Development" by Steven bullen suggests that
¤ Microsoft have "depreciated the provider"! "ADO version 2.5 is the last
¤ version distributed with this provider" and suggests downloading it from the
¤ Microsoft site. ... but i can't find it.... I find it quite unbelievable that
¤ the OLE DB provider for Microsoft Jet isn't available after Office 2000!
¤

See the following:

How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[J Bowen]

I just wanted to post and say that I am having the exact same problem.
I don't have a solution and I have tried everything that I can think of.
Are you using source control and have you ever had the Jet option in the
"Data Link Properties" window?