By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,571 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,571 IT Pros & Developers. It's quick & easy.

VB.NET and MDAC+JET

P: n/a
bz
Hi,

When writing database program with VB.NET that accesses MDB and XLS file, do
you guys know if I still need to distribute MDAC and JET4 to the client
machine?

Or .NET framework already comes with all those drivers?

Thanks!
--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.

There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.
http://spaces.msn.com/bzDaCat
Nov 15 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
For BZ, the client need in my idea to have a proper license of office.

Jet is free and if you use AdoNet and when you use OleDB, than you don't
need AFAIK nothing more.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl...
Hi,

When writing database program with VB.NET that accesses MDB and XLS file,
do you guys know if I still need to distribute MDAC and JET4 to the client
machine?

Or .NET framework already comes with all those drivers?

Thanks!
--
>There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.

There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.

http://spaces.msn.com/bzDaCat

Nov 15 '06 #2

P: n/a
bz
So, you are saying that I still need to install MDAC and JET to the client
machine if I want to access MDB and XLS files.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
For BZ, the client need in my idea to have a proper license of office.

Jet is free and if you use AdoNet and when you use OleDB, than you don't
need AFAIK nothing more.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl...
>Hi,

When writing database program with VB.NET that accesses MDB and XLS file,
do you guys know if I still need to distribute MDAC and JET4 to the
client machine?

Or .NET framework already comes with all those drivers?

Thanks!
--
>>There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.

There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.

http://spaces.msn.com/bzDaCat


Nov 15 '06 #3

P: n/a
Peter,

As far as I know are all the computers where Net can run on already with the
proper MDAC installed.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
So, you are saying that I still need to install MDAC and JET to the client
machine if I want to access MDB and XLS files.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
>For BZ, the client need in my idea to have a proper license of office.

Jet is free and if you use AdoNet and when you use OleDB, than you don't
need AFAIK nothing more.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl...
>>Hi,

When writing database program with VB.NET that accesses MDB and XLS
file, do you guys know if I still need to distribute MDAC and JET4 to
the client machine?

Or .NET framework already comes with all those drivers?

Thanks!
--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.

There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.

http://spaces.msn.com/bzDaCat



Nov 15 '06 #4

P: n/a
"bz" <no****@yahoo.comwrote in
news:#f**************@TK2MSFTNGP02.phx.gbl:
So, you are saying that I still need to install MDAC and JET to the
client machine if I want to access MDB and XLS files.
MDAC has been included as a system component since Windows 2000.

However, most users on Windows 98 should (but you may want to write a check
routine) have MDAC installed as well.

Nov 15 '06 #5

P: n/a
Spam Catcher <sp**********@rogers.comwrote in
news:Xn**********************************@127.0.0. 1:
MDAC has been included as a system component since Windows 2000.

However, most users on Windows 98 should (but you may want to write a
check routine) have MDAC installed as well.
BTW, MDAC for Windows 2000 is MDAC v2.5. However, .NET requires MDAC v2.6
and recommends v2.7. Thus you may still want to put some MDAC error
handling just in case.

You'll get this error if you run the app on a machine without MDAC:

The .NET Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
_
Access Components (MDAC) version 2.6 or later.
Nov 15 '06 #6

P: n/a
bz
So, I still need to install JET4 to access MDB and XLS files, do I?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...
Peter,

As far as I know are all the computers where Net can run on already with
the proper MDAC installed.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
>So, you are saying that I still need to install MDAC and JET to the
client machine if I want to access MDB and XLS files.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
>>For BZ, the client need in my idea to have a proper license of office.

Jet is free and if you use AdoNet and when you use OleDB, than you don't
need AFAIK nothing more.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl...
Hi,

When writing database program with VB.NET that accesses MDB and XLS
file, do you guys know if I still need to distribute MDAC and JET4 to
the client machine?

Or .NET framework already comes with all those drivers?

Thanks!
--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.
>
There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.

http://spaces.msn.com/bzDaCat



Nov 15 '06 #7

P: n/a
And ...

Mdac 2.5 was the last version that had everything included ( Jet oledb ) to
access Access :-)

Since version 2.5 Jet oledb has become a seperate installation

so my recomendation would be ,, ship the jet oledb merge module with your
deployment and you should be safe

regards

Michel Posseth [MCP]

"Spam Catcher" <sp**********@rogers.comschreef in bericht
news:Xn**********************************@127.0.0. 1...
Spam Catcher <sp**********@rogers.comwrote in
news:Xn**********************************@127.0.0. 1:
>MDAC has been included as a system component since Windows 2000.

However, most users on Windows 98 should (but you may want to write a
check routine) have MDAC installed as well.

BTW, MDAC for Windows 2000 is MDAC v2.5. However, .NET requires MDAC v2.6
and recommends v2.7. Thus you may still want to put some MDAC error
handling just in case.

You'll get this error if you run the app on a machine without MDAC:

The .NET Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
_
Access Components (MDAC) version 2.6 or later.

Nov 16 '06 #8

P: n/a
Yes , you do need to make sure that it is installed on the target system
before you start your program

regards

Michel posseth [MCP]
"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
So, I still need to install JET4 to access MDB and XLS files, do I?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...
>Peter,

As far as I know are all the computers where Net can run on already with
the proper MDAC installed.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>So, you are saying that I still need to install MDAC and JET to the
client machine if I want to access MDB and XLS files.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
For BZ, the client need in my idea to have a proper license of office.

Jet is free and if you use AdoNet and when you use OleDB, than you
don't need AFAIK nothing more.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl...
Hi,
>
When writing database program with VB.NET that accesses MDB and XLS
file, do you guys know if I still need to distribute MDAC and JET4 to
the client machine?
>
Or .NET framework already comes with all those drivers?
>
Thanks!
>
>
--
>There is no answer.
>There has not been an answer.
>There will not be an answer.
>That IS the answer!
>And I am screwed.
>Deadline was due yesterday.
>>
>There is no point to life.
>THAT IS THE POINT.
>And we are screwed.
>We will run out of oil soon.
>
http://spaces.msn.com/bzDaCat
>




Nov 16 '06 #9

P: n/a
bz
So, if I am using ADO.NET to open MDB or XLS files, I still need to install
JET4.

Got it. Thanks!

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:uz**************@TK2MSFTNGP06.phx.gbl...
Yes , you do need to make sure that it is installed on the target system
before you start your program

regards

Michel posseth [MCP]
"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
>So, I still need to install JET4 to access MDB and XLS files, do I?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...
>>Peter,

As far as I know are all the computers where Net can run on already with
the proper MDAC installed.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl.. .
So, you are saying that I still need to install MDAC and JET to the
client machine if I want to access MDB and XLS files.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
For BZ, the client need in my idea to have a proper license of
office.
>
Jet is free and if you use AdoNet and when you use OleDB, than you
don't need AFAIK nothing more.
>
Cor
>
"bz" <no****@yahoo.comschreef in bericht
news:OL**************@TK2MSFTNGP04.phx.gbl.. .
>Hi,
>>
>When writing database program with VB.NET that accesses MDB and XLS
>file, do you guys know if I still need to distribute MDAC and JET4 to
>the client machine?
>>
>Or .NET framework already comes with all those drivers?
>>
>Thanks!
>>
>>
>--
>>There is no answer.
>>There has not been an answer.
>>There will not be an answer.
>>That IS the answer!
>>And I am screwed.
>>Deadline was due yesterday.
>>>
>>There is no point to life.
>>THAT IS THE POINT.
>>And we are screwed.
>>We will run out of oil soon.
>>
>http://spaces.msn.com/bzDaCat
>>
>
>




Nov 16 '06 #10

P: n/a

This is where you can find the latest jet oledb drivers ( servicepack 8 )

http://support.microsoft.com/default.aspx/kb/829558
regards

Michel
"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
So, if I am using ADO.NET to open MDB or XLS files, I still need to
install JET4.

Got it. Thanks!

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:uz**************@TK2MSFTNGP06.phx.gbl...
>Yes , you do need to make sure that it is installed on the target system
before you start your program

regards

Michel posseth [MCP]
"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
>>So, I still need to install JET4 to access MDB and XLS files, do I?

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...
Peter,

As far as I know are all the computers where Net can run on already
with the proper MDAC installed.

Cor

"bz" <no****@yahoo.comschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl. ..
So, you are saying that I still need to install MDAC and JET to the
client machine if I want to access MDB and XLS files.
>
>
>
"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl.. .
>For BZ, the client need in my idea to have a proper license of
>office.
>>
>Jet is free and if you use AdoNet and when you use OleDB, than you
>don't need AFAIK nothing more.
>>
>Cor
>>
>"bz" <no****@yahoo.comschreef in bericht
>news:OL**************@TK2MSFTNGP04.phx.gbl. ..
>>Hi,
>>>
>>When writing database program with VB.NET that accesses MDB and XLS
>>file, do you guys know if I still need to distribute MDAC and JET4
>>to the client machine?
>>>
>>Or .NET framework already comes with all those drivers?
>>>
>>Thanks!
>>>
>>>
>>--
>>>There is no answer.
>>>There has not been an answer.
>>>There will not be an answer.
>>>That IS the answer!
>>>And I am screwed.
>>>Deadline was due yesterday.
>>>>
>>>There is no point to life.
>>>THAT IS THE POINT.
>>>And we are screwed.
>>>We will run out of oil soon.
>>>
>>http://spaces.msn.com/bzDaCat
>>>
>>
>>
>
>




Nov 17 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.