Home All Groups Group Topic Archive Search About
Author
15 Nov 2006 6:38 PM
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

Author
15 Nov 2006 7:15 PM
Cor Ligthert [MVP]
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

Show quoteHide quote
"bz" <nospam@yahoo.com> schreef in bericht
news:OLzGXYOCHHA.4428@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
>
Author
15 Nov 2006 7:24 PM
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.



Show quoteHide quote
"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
> news:OLzGXYOCHHA.4428@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
>>
>
>
Author
15 Nov 2006 8:01 PM
Cor Ligthert [MVP]
Peter,

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

Cor

Show quoteHide quote
"bz" <nospam@yahoo.com> schreef in bericht
news:%23fimPyOCHHA.3396@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]" <notmyfirstn***@planet.nl> wrote in message
> news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
>> news:OLzGXYOCHHA.4428@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
>>>
>>
>>
>
>
Author
15 Nov 2006 8:51 PM
bz
So, I still need to install JET4 to access MDB and XLS files, do I?



Show quoteHide quote
"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:euimhCPCHHA.1012@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" <nospam@yahoo.com> schreef in bericht
> news:%23fimPyOCHHA.3396@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]" <notmyfirstn***@planet.nl> wrote in message
>> news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
>>> news:OLzGXYOCHHA.4428@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
>>>>
>>>
>>>
>>
>>
>
>
Author
16 Nov 2006 6:32 PM
Michel Posseth [MCP]
Yes , you do need to make sure that it is installed on the target system
before you start your program

regards

Michel posseth [MCP]


Show quoteHide quote
"bz" <nospam@yahoo.com> schreef in bericht
news:%23KkkhiPCHHA.4256@TK2MSFTNGP04.phx.gbl...
> So, I still need to install JET4 to access MDB and XLS files, do I?
>
>
>
> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
> news:euimhCPCHHA.1012@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" <nospam@yahoo.com> schreef in bericht
>> news:%23fimPyOCHHA.3396@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]" <notmyfirstn***@planet.nl> wrote in message
>>> news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
>>>> news:OLzGXYOCHHA.4428@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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Author
16 Nov 2006 7:22 PM
bz
So, if I am using ADO.NET to open MDB or XLS files, I still need to install
JET4.

Got it.  Thanks!



Show quoteHide quote
"Michel Posseth [MCP]" <M***@posseth.com> wrote in message
news:uzptl1aCHHA.3524@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" <nospam@yahoo.com> schreef in bericht
> news:%23KkkhiPCHHA.4256@TK2MSFTNGP04.phx.gbl...
>> So, I still need to install JET4 to access MDB and XLS files, do I?
>>
>>
>>
>> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
>> news:euimhCPCHHA.1012@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" <nospam@yahoo.com> schreef in bericht
>>> news:%23fimPyOCHHA.3396@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]" <notmyfirstn***@planet.nl> wrote in message
>>>> news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
>>>>> news:OLzGXYOCHHA.4428@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
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Author
17 Nov 2006 5:40 PM
Michel Posseth [MCP]
This is where you can find the latest jet oledb drivers ( servicepack 8 )

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


regards

Michel


Show quoteHide quote
"bz" <nospam@yahoo.com> schreef in bericht
news:%23rJ3WVbCHHA.4024@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]" <M***@posseth.com> wrote in message
> news:uzptl1aCHHA.3524@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" <nospam@yahoo.com> schreef in bericht
>> news:%23KkkhiPCHHA.4256@TK2MSFTNGP04.phx.gbl...
>>> So, I still need to install JET4 to access MDB and XLS files, do I?
>>>
>>>
>>>
>>> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
>>> news:euimhCPCHHA.1012@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" <nospam@yahoo.com> schreef in bericht
>>>> news:%23fimPyOCHHA.3396@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]" <notmyfirstn***@planet.nl> wrote in message
>>>>> news:OjS2soOCHHA.3600@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" <nospam@yahoo.com> schreef in bericht
>>>>>> news:OLzGXYOCHHA.4428@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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Author
15 Nov 2006 8:09 PM
Spam Catcher
"bz" <nospam@yahoo.com> wrote in
news:#fimPyOCHHA.3396@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.
Author
15 Nov 2006 8:10 PM
Spam Catcher
Spam Catcher <spamhoneypot@rogers.com> wrote in
news:Xns987C9A196C7CFusenethoneypotrogers@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.
Author
16 Nov 2006 8:32 AM
Michel Posseth [MCP]
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]



Show quoteHide quote
"Spam Catcher" <spamhoneypot@rogers.com> schreef in bericht
news:Xns987C9A5B7A4C3usenethoneypotrogers@127.0.0.1...
> Spam Catcher <spamhoneypot@rogers.com> wrote in
> news:Xns987C9A196C7CFusenethoneypotrogers@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.