I want help with the jet 4.0 provider..

[Guest]

I try to make a connection with an access database using jet 4.0 OLE DB
provider and i receive the following messages:
"Test connection failed because of an error in initializing
provider.catastrophic failure" and/or
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll
Additional information: No error information available:
REGDB_E_CLASSNOTREG(0x80040154)."
I have made the following steps until now
-I updated my jet 4.0 db engine with the last version (4.00.8618.0)
-I re-installed visual studio.net....and nothing change!!
I use windows xp and office 2003.
Can anyone Help me with this problem?

 

[Paul Clement]

¤ I try to make a connection with an access database using jet 4.0 OLE DB
¤ provider and i receive the following messages:
¤ "Test connection failed because of an error in initializing
¤ provider.catastrophic failure" and/or
¤ "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
¤ in system.data.dll
¤ Additional information: No error information available:
¤ REGDB_E_CLASSNOTREG(0x80040154)."
¤ I have made the following steps until now
¤ -I updated my jet 4.0 db engine with the last version (4.00.8618.0)
¤ -I re-installed visual studio.net....and nothing change!!
¤ I use windows xp and office 2003.
¤ Can anyone Help me with this problem?
¤

Are you trying to add a connection through the Server Explorer? There could be a problem with the
options you are selecting.


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

 

[Guest]

I tried to make a connection by OleDbDataAdapter wizard or with a connecton
string and i received thes massages I reported I've stucked!

 

[Paul Clement]

¤ I tried to make a connection by OleDbDataAdapter wizard or with a connecton
¤ string and i received thes massages I reported I've stucked!
¤

Can you save the connection without testing it? If so, can you post the value of the
ConnectionString property?


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

 

[Guest]

Dim myConnection As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Password="";User ID=Admin;Data Source=C:\Program Files\Microsoft Visual
Studio .NET\Crystal Reports\Samples\xtreme;" & _
"Mode=Share Deny None;Extended Properties="";" & _
"Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
OLEDBatabase Password="";" & _
"Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;" & _
"Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";" & _
"Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;" & _
"Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without
Replica Repair=False;" & _
"Jet OLEDB:SFP=False;")

 

[Paul Clement]

¤ Dim myConnection As OleDbConnection = New
¤ OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
¤ "Password="";User ID=Admin;Data Source=C:\Program Files\Microsoft Visual
¤ Studio .NET\Crystal Reports\Samples\xtreme;" & _
¤ "Mode=Share Deny None;Extended Properties="";" & _
¤ "Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
¤ OLEDBatabase Password="";" & _
¤ "Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;Jet
¤ OLEDB:Global Partial Bulk Ops=2;" & _
¤ "Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
¤ Password="";" & _
¤ "Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
¤ Database=False;" & _
¤ "Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without
¤ Replica Repair=False;" & _
¤ "Jet OLEDB:SFP=False;")
¤

The Data Source is a folder path - I don't see a file name (mdb).

Did you select the provider first on the Provider tab and then select the database name on the
Connection tab?


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

 

[Guest]

This connectionstring Property isn't made by the oleDbDataAdapter wizard I
Wrote it and stops at the line: myConnection.Open()
I select the provider first on the Provider tab and then I select the
database name on the Connection tab
I cannot save the connectionString Property using the wizard because when i
click the okButton shows a message :Unable to connect to
database.Catastrophic failure

 

[Paul Clement]

¤ This connectionstring Property isn't made by the oleDbDataAdapter wizard I
¤ Wrote it and stops at the line: myConnection.Open()
¤ I select the provider first on the Provider tab and then I select the
¤ database name on the Connection tab
¤ I cannot save the connectionString Property using the wizard because when i
¤ click the okButton shows a message :Unable to connect to
¤ database.Catastrophic failure
¤

Are you certain the database isn't corrupt? Have you tried connecting to a different database?


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

 

[Guest]

Yes, I've already done this to different databases with no results.

 

[Paul Clement]

¤ Yes, I've already done this to different databases with no results.
¤

Can you connect using the System.Data.OleDb.OleDbConnection in code?


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

 

[Guest]

If you mean by writing code to connect to other databases, yes.
I send you a piece of code I wrote to connect at a database(made by me) in
access

Imports System.Data
Imports System.Data.OleDb

Public Class Form1
Inherits System.Windows.Forms.Form

Dim myConnection As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\My CD's\Τα CD μου.mdb;User ID=;Password=;")
Dim myAdapter As New OleDbDataAdapter()
Dim MyDataSet As New DataSet()

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

'ανοιξε την σÏνδεση..
myConnection.Open() ........And here is THE PROBLEM and the message
too!!
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll

Additional information: No error information available:
REGDB_E_CLASSNOTREG(0x80040154)."

 

[Paul Clement]

¤ If you mean by writing code to connect to other databases, yes.
¤ I send you a piece of code I wrote to connect at a database(made by me) in
¤ access
¤
¤ Imports System.Data
¤ Imports System.Data.OleDb
¤
¤ Public Class Form1
¤ Inherits System.Windows.Forms.Form
¤
¤ Dim myConnection As OleDbConnection = New
¤ OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
¤ "Data Source=F:\My CD's\?? CD ???.mdb;User ID=;Password=;")
¤ Dim myAdapter As New OleDbDataAdapter()
¤ Dim MyDataSet As New DataSet()
¤
¤ #Region " Windows Form Designer generated code "
¤
¤ Public Sub New()
¤ MyBase.New()
¤
¤ 'This call is required by the Windows Form Designer.
¤ InitializeComponent()
¤
¤ 'Add any initialization after the InitializeComponent() call
¤
¤ '?????? ??? ???????..
¤ myConnection.Open() ........And here is THE PROBLEM and the message
¤ too!!
¤ "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
¤ in system.data.dll
¤
¤ Additional information: No error information available:
¤ REGDB_E_CLASSNOTREG(0x80040154)."
¤ "Paul Clement" wrote:

If you cannot connect with code either then I would suspect there is a problem with either the MDAC
or Jet installation. Have you tried installing the latest versions of both MDAC and Jet?

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en
http://www.microsoft.com/downloads/...c4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en


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

 

[Guest]

Yes and i received the following messages:
"MDAC 2.8 is incompatible with this version of windows.All of its features
are currently part of windows",
and for jet service pack:
"Setup has detected that the service pack version of this system is newer
than the update you are applying.There is no need to install this update."

 

[Paul Clement]

¤ Yes and i received the following messages:
¤ "MDAC 2.8 is incompatible with this version of windows.All of its features
¤ are currently part of windows",
¤ and for jet service pack:
¤ "Setup has detected that the service pack version of this system is newer
¤ than the update you are applying.There is no need to install this update."
¤

Did you try to install the Jet Service Pack?


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

 

[Guest]

Yes and i received the message i wrote:
"Setup has detected that the service pack version of this system is newer
than the update you are applying.There is no need to install this update."

 

[Paul Clement]

¤ Yes and i received the message i wrote:
¤ "Setup has detected that the service pack version of this system is newer
¤ than the update you are applying.There is no need to install this update."
¤
¤

Can you open the database with Microsoft Access or one of the other Office applications?

If you can't upgrade Jet or MDAC then I don't know what else to suggest. It would appear that the
installation of either Jet or MDAC has been corrupted.


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

 

[Guest]

If either Jet or MDAC has been corrupted how can I fix these ?
Could I re-install them?
If so,where could I find them?

 

[Paul Clement]

On Thu, 13 Jan 2005 11:27:06 -0800, "giorgos"

¤ If either Jet or MDAC has been corrupted how can I fix these ?
¤ Could I re-install them?
¤ If so,where could I find them?
¤
¤

Try the MDAC component checker:

http://support.microsoft.com/kb/307255

However, I would still verify as to whether you can connect from an application
other than .NET. If you can successfully connect then it's probably a .NET issue
and MDAC and Jet are fine.


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