[AccessD] ADO 2.6 install

Thanks Marty.

Jim D

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Friday, November 21, 2003 12:04 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADO 2.6 install


Some OS have a basic install of MDAC ie. WinXP has MDAC 2.7

To quote.
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e5f816c-4918-4250-b8bd-3794582c9089&DisplayLang=en
 "The MDAC 2.6 SP2 redistributable installer installs the same Data 
Access core components as Microsoft SQL Server 2000 SP2. This release 
does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the 
Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC Driver."

MDAC 2.6 was last one, able  to be installed on Win95.

To get these drivers I think you need MDAC 2.5 SP 3.  This MDAC comes 
with Win 2000 SP-3.

MDAC 2.5 SP-3 was last MDAC to contain total Jet 4.0 Install
http://www.microsoft.com/downloads/details.aspx?FamilyID=c57692e9-dde7-4a60-b586-5d4fd6794db6&DisplayLang=en
Here is manifest list for MDAC 2.5 SP3
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/MDAC/2.5/SP3manifest.asp

Just for interest sakes MDAC 2.0 was last one that installed Jet 3.0 or 
was it 3.5, but it is no longer available.
You can still install it via Access 97 or VB6.

There are some bugs with FoxPro Drivers that were fixed in Jet SP 5 or 6 
that might affect you.
So you would need Jet SP 7 or SP 8 upgrade depending on the OS

If you want to get really carried away MDAC 2.8 has just been released.
This handles a lot of security changes , you may have to modify security 
in IE if calling ado from there or
if you have a space in a database name put within brackets.

A lot of the gory details are at
http://www.microsoft.com/data

Jim DeMarco wrote:

>List, 
>
>I'm putting together an install for an app that will retrieve data from FoxPro, an mdb, and an Excel sheet.  Will including ADO 2.6 in my install automatically install the OLEDB drivers for all of these or do I need to include MDAC as part of the install?  Using InstallShield 4.0.
>
>TIA,
>
>Jim DeMarco
>Director Product Development
>Hudson Health Plan
>Tarrytown, NY
>
>
>
>
>***********************************************************************************
>"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
>***********************************************************************************
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************