Accessing MDB's

  • Thread starter Thread starter BobAchgill
  • Start date Start date
B

BobAchgill

What more do I need to install on a user's computer to
access a MDB database from my VB .Net Win Form? I am
trying to minimize the footprint of the install size.

This is my typical user machine:
- 2000 or XP
- Framework 1.1

If I go with Jet 4.0 technology, do I have to install the
whole MDAC or can I get by with just Jet drivers?

If I go with ODBC technology are the drivers already on
the 2000 and XP operating system?

What are the trade offs between Jet and ODBC??

Thanks!

Bob
 
Hi Bob,

Incase you are using Jet 4.0 technology,you don't need to install MDAC.You
can do with Jet drivers.

For ODBC,you need to install MDAC. The .NET framework version 1.1 supports
MDAC 2.6 or later.
However, MDAC 2.7 or later is recommended

Microsoft Jet is basically designed to connect to MS Access exclusively.
With ODBC provider, you can connect to various data sources like Access,SQL
Server, Oracle etc.
It provides a common platform for a variety of data sources.

HTH

Mona
 
Hi Bob,

JET drivers are included with MDAC <= 2.5. For later mdac versions there is
a separate download.
http://support.microsoft.com/kb/239114

..net OleDbProvider 1.1 require MDAC >= 2.6 (framework 1.1 comes with mdac
2.7 sp1).
I would say that you have to incude separate jet provider setup to be on the
safe side.
 
I found this (see link below) which suggest that only ODBC Desktop
Pack
drivers ARE included with 2000 and XP operating systems.

Quote (from link below)-
"These drivers are included with the Windows 2000
operating system, the Windows XP operating system, and the Windows
Server 2003 operating system."

Am I reading this correctly that I do NOT need to load ODBC (MDAC)
drivers if my desktops are 2000, XP or 2003??

Where did you get your quote from??

Quote -
".net OleDbProvider 1.1 require MDAC >= 2.6 (framework 1.1 comes with
mdac
2.7 sp1)."


Maybe both quotes are correct... ODBC drivers DO come with 2000, XP and
2003 but those drivers are not supported by .Net??

Are there performance trades between using ODBC instead of Jet? I have
heard that ODBC is slow?


Bob

-------------------------------------------------------------------
How to obtain the latest service pack for the Microsoft Jet 4.0
Database Engine
http://support.microsoft.com/kb/239114#9

If you obtain the Jet 4.0 Service Pack 8 download for computers that
are running Microsoft Windows 95, Microsoft Windows 98, and Microsoft
Windows NT version 4.0, you will also receive the ODBC Desktop Driver
Pack drivers. These drivers are included with the Windows 2000
operating system, the Windows XP operating system, and the Windows
Server 2003 operating system. The ODBC Desktop Driver Pack drivers
includes the following files:
 
¤ What more do I need to install on a user's computer to
¤ access a MDB database from my VB .Net Win Form? I am
¤ trying to minimize the footprint of the install size.
¤
¤ This is my typical user machine:
¤ - 2000 or XP
¤ - Framework 1.1
¤
¤ If I go with Jet 4.0 technology, do I have to install the
¤ whole MDAC or can I get by with just Jet drivers?
¤
¤ If I go with ODBC technology are the drivers already on
¤ the 2000 and XP operating system?
¤
¤ What are the trade offs between Jet and ODBC??
¤
¤ Thanks!
¤
¤ Bob

MDAC should already be installed since it is required by the framework.

You need Jet regardless of whether you use ODBC or OLEDB. I would recommend using the Jet OLEDB
provider instead of the MS Access ODBC driver. Newer technology and it's stable.


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