Confused about MDAC, VB.Net, and Jet

[TC]

I have a VB.Net application which uses System.Data.Ole Db to connect to
a Jet database. Recently, I learned that MDAC no longer contains Jet
drivers. I'm confused what that means for my application. Can someone
help me with answers to these basic questions?

First of all, does the absence of Jet driver from MDAC imply that most
computers in the future will lack Jet drivers?

Second, if I use a Visual Studio setup project to package my
application, will it recognize the Jet driver as a dependency, and
include it in the distribution file? In other words, if I distribute
my application to someone who has a recent version of MDAC, will it
work?

Third, does the exclusion of Jet from MDAC imply that Jet is
deprecated?
-TC

[Armin Zingler]

"TC" <go*********@ya hoo.comschrieb

I read the page you referenced. It seems to imply that all versions
of Windows since Windows 2000 include Jet. If so, then why would a
Windows computer ever lack the Jet drivers?

Yesterday, a friend asked me to debug a problem. He was receiving
the message "The 'Microsoft.Jet. OLEDB.4.0' provider is not
registered on the local machine". When I researched that error, most
of the search results explained the problem by noting that MDAC no
longer includes Jet. However, if I understand
http://support.microsoft.com/kb/239114 correctly, that explanation
is bogus. My friend and others who receive that error are not
missing Jet because it was omitted from MDAC; they are missing Jet
because... why?

I'm afraid, I can't answer this. I don't know if it also applies to the
Jet OLEDB provider or only to the Jet core components (or whether both
are the same).

Armin

[TC]

On May 28, 6:54 am, "Armin Zingler" <az.nos...@free net.dewrote:

"TC" <golemdan...@ya hoo.comschrieb

I read the page you referenced. It seems to imply that all versions
of Windows since Windows 2000 include Jet. If so, then why would a
Windows computer ever lack the Jet drivers?

Yesterday, a friend asked me to debug a problem. He was receiving
the message "The 'Microsoft.Jet. OLEDB.4.0' provider is not
registered on the local machine". When I researched that error, most
of the search results explained the problem by noting that MDAC no
longer includes Jet. However, if I understand
http://support.microsoft.com/kb/239114correctly, that explanation
is bogus. My friend and others who receive that error are not
missing Jet because it was omitted from MDAC; they are missing Jet
because... why?

I'm afraid, I can't answer this. I don't know if it also applies to the
Jet OLEDB provider or only to the Jet core components (or whether both
are the same).

Armin

Armin,

I just re-read article 239114, and I have a theory:

1) When it says "you have a later version of Jet 4.0...", it does not
mean "you already have Jet 4.0 installed." Rather, what it means is
"you have a setup package for Jet 4.0 on your product CD, so we don't
need to provide you with a download."

2) When it says "We recommend that you install the latest service pack
for Windows ???" it does not mean "you can install Jet 4.0 by
installing the latest service pack." Rather, what it means is "before
you install Jet 4.0, you should make sure your OS is current."

3) When it says "To install the latest Jet 4.0 service pack... 1.
Download the appropriate version of the Jet service pack", it does not
mean "download." Rather, it means "either download or obtain from your
product CD."

Could this interpretation be correct? If so, it means the Jet
components are not automatically installed with Windows, so I cannot
expect computers to have it when I distribute my application.
Furthermore, it means that people missing Jet, like my friend, cannot
simply download and install it; they must find it on their product CD.

Frankly, I'm more confused than ever. I'm going to post another
newsgroup message asking specifically how to interpret 239114.
-TC

[Cor Ligthert[MVP]]

TC,

If you want a complete answer then ask this in the newsgroup

microsoft.publi c.dotnet.framew ork.adonet

William Vaugh is probably the best one who can answer your questions in dept
while he is active in that newsgroup.

Cor

"TC" <go*********@ya hoo.comschreef in bericht
news:f0******** *************** ***********@a32 g2000prf.google groups.com...

On May 28, 6:54 am, "Armin Zingler" <az.nos...@free net.dewrote:

>"TC" <golemdan...@ya hoo.comschrieb

I read the page you referenced. It seems to imply that all versions
of Windows since Windows 2000 include Jet. If so, then why would a
Windows computer ever lack the Jet drivers?

Yesterday, a friend asked me to debug a problem. He was receiving
the message "The 'Microsoft.Jet. OLEDB.4.0' provider is not
registered on the local machine". When I researched that error, most
of the search results explained the problem by noting that MDAC no
longer includes Jet. However, if I understand
http://support.microsoft.com/kb/239114correctly, that explanation
is bogus. My friend and others who receive that error are not
missing Jet because it was omitted from MDAC; they are missing Jet
because... why?

I'm afraid, I can't answer this. I don't know if it also applies to the
Jet OLEDB provider or only to the Jet core components (or whether both
are the same).

Armin

Armin,

I just re-read article 239114, and I have a theory:

1) When it says "you have a later version of Jet 4.0...", it does not
mean "you already have Jet 4.0 installed." Rather, what it means is
"you have a setup package for Jet 4.0 on your product CD, so we don't
need to provide you with a download."

2) When it says "We recommend that you install the latest service pack
for Windows ???" it does not mean "you can install Jet 4.0 by
installing the latest service pack." Rather, what it means is "before
you install Jet 4.0, you should make sure your OS is current."

3) When it says "To install the latest Jet 4.0 service pack... 1.
Download the appropriate version of the Jet service pack", it does not
mean "download." Rather, it means "either download or obtain from your
product CD."

Could this interpretation be correct? If so, it means the Jet
components are not automatically installed with Windows, so I cannot
expect computers to have it when I distribute my application.
Furthermore, it means that people missing Jet, like my friend, cannot
simply download and install it; they must find it on their product CD.

Frankly, I'm more confused than ever. I'm going to post another
newsgroup message asking specifically how to interpret 239114.
-TC

[TC]

On May 28, 10:05 am, "Cor Ligthert[MVP]" <notmyfirstn... @planet.nl>
wrote:

TC,

If you want a complete answer then ask this in the newsgroup

microsoft.publi c.dotnet.framew ork.adonet

William Vaugh is probably the best one who can answer your questions in dept
while he is active in that newsgroup.

Cor

"TC" <golemdan...@ya hoo.comschreef in berichtnews:f0* *************** *************** ***@a32g2000prf .googlegroups.c om...

On May 28, 6:54 am, "Armin Zingler" <az.nos...@free net.dewrote:

"TC" <golemdan...@ya hoo.comschrieb

I read the page you referenced. It seems to imply that all versions
of Windows since Windows 2000 include Jet. If so, then why would a
Windows computer ever lack the Jet drivers?

Yesterday, a friend asked me to debug a problem. He was receiving
the message "The 'Microsoft.Jet. OLEDB.4.0' provider is not
registered on the local machine". When I researched that error, most
of the search results explained the problem by noting that MDAC no
longer includes Jet. However, if I understand
http://support.microsoft.com/kb/239114correctly, that explanation
is bogus. My friend and others who receive that error are not
missing Jet because it was omitted from MDAC; they are missing Jet
because... why?

I'm afraid, I can't answer this. I don't know if it also applies to the
Jet OLEDB provider or only to the Jet core components (or whether both
are the same).

Armin

Armin,

I just re-read article 239114, and I have a theory:

1) When it says "you have a later version of Jet 4.0...", it does not
mean "you already have Jet 4.0 installed." Rather, what it means is
"you have a setup package for Jet 4.0 on your product CD, so we don't
need to provide you with a download."

2) When it says "We recommend that you install the latest service pack
for Windows ???" it does not mean "you can install Jet 4.0 by
installing the latest service pack." Rather, what it means is "before
you install Jet 4.0, you should make sure your OS is current."

3) When it says "To install the latest Jet 4.0 service pack... 1.
Download the appropriate version of the Jet service pack", it does not
mean "download." Rather, it means "either download or obtain from your
product CD."

Could this interpretation be correct? If so, it means the Jet
components are not automatically installed with Windows, so I cannot
expect computers to have it when I distribute my application.
Furthermore, it means that people missing Jet, like my friend, cannot
simply download and install it; they must find it on their product CD.

Frankly, I'm more confused than ever. I'm going to post another
newsgroup message asking specifically how to interpret 239114.

-TC

Thanks. I've rephrased my question and posted it there:
http://groups.google.com/group/micro...aa86e80e76e342

-TC

[Michel Posseth [MCP]]

Or just read one of the few previous discussions about this topic a quick
google will bring them forward
cause Bill told his opinion lots of times regarding this mather

see this recent one where Bill is also participating , although it is
about DAO
http://groups.google.nl/group/micros...500fad61eb452e

or more generic

http://groups.google.nl/groups/searc...et&qt_s=Zoeken
Access is still usable in VB.Net ( if you target 32 bit computers only )
however personally i would go for the SQL server anywhere product family ,,
unless it is your goal that users can bypass your app and query themselves
on the DB

Regards

Michel Posseth


"Cor Ligthert[MVP]" <no************ @planet.nlschre ef in bericht
news:59******** *************** ***********@mic rosoft.com...

TC,

If you want a complete answer then ask this in the newsgroup

microsoft.publi c.dotnet.framew ork.adonet

William Vaugh is probably the best one who can answer your questions in
dept while he is active in that newsgroup.

Cor

"TC" <go*********@ya hoo.comschreef in bericht
news:f0******** *************** ***********@a32 g2000prf.google groups.com...

>On May 28, 6:54 am, "Armin Zingler" <az.nos...@free net.dewrote:

>>"TC" <golemdan...@ya hoo.comschrieb

I read the page you referenced. It seems to imply that all versions
of Windows since Windows 2000 include Jet. If so, then why would a
Windows computer ever lack the Jet drivers?

Yesterday, a friend asked me to debug a problem. He was receiving
the message "The 'Microsoft.Jet. OLEDB.4.0' provider is not
registered on the local machine". When I researched that error, most
of the search results explained the problem by noting that MDAC no
longer includes Jet. However, if I understand
http://support.microsoft.com/kb/239114correctly, that explanation
is bogus. My friend and others who receive that error are not
missing Jet because it was omitted from MDAC; they are missing Jet
because... why?

I'm afraid, I can't answer this. I don't know if it also applies to the
Jet OLEDB provider or only to the Jet core components (or whether both
are the same).

Armin

Armin,

I just re-read article 239114, and I have a theory:

1) When it says "you have a later version of Jet 4.0...", it does not
mean "you already have Jet 4.0 installed." Rather, what it means is
"you have a setup package for Jet 4.0 on your product CD, so we don't
need to provide you with a download."

2) When it says "We recommend that you install the latest service pack
for Windows ???" it does not mean "you can install Jet 4.0 by
installing the latest service pack." Rather, what it means is "before
you install Jet 4.0, you should make sure your OS is current."

3) When it says "To install the latest Jet 4.0 service pack... 1.
Download the appropriate version of the Jet service pack", it does not
mean "download." Rather, it means "either download or obtain from your
product CD."

Could this interpretation be correct? If so, it means the Jet
components are not automatically installed with Windows, so I cannot
expect computers to have it when I distribute my application.
Furthermore, it means that people missing Jet, like my friend, cannot
simply download and install it; they must find it on their product CD.

Frankly, I'm more confused than ever. I'm going to post another
newsgroup message asking specifically how to interpret 239114.
-TC