[dba-Tech] ADO 2.7 Library Reference

Dan Waters dwaters at usinternet.com
Sat Jan 10 13:41:42 CST 2004


Marty - Wow!

Thanks for this wealth of info!  I can use this for the long term.

Dan

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Saturday, January 10, 2004 12:33 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] ADO 2.7 Library Reference


Here is how to track down these problems
WinNT SP5 has ADO 1.5 as the default
WinXP has ADO 2.7 as its default

How do I know? I go to the DLL Hell database
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dll
info.asp&fp=1
and type in msado15.dll
This will give you a list of the versions msado15.dll that could be 
installed
Go to your clients machine in Win explorer
C:\Program Files\Common Files\System\ado\   and on file msado15.dll 
right click select properties
then select version tab and note file version number . Mine says 2.71.9030
so I have some version of ADO 2.7 from one of the MDAC downloads, there 
maybe
different versions of MDAC installed for one major version number 2.7. 
My version
number came from either WinXP SP 1 or SQL Server 2000 SP3.
I find out this from the "more info" on the version number of 
msado15.dll in the DLL Hell
information.

While you are in explorer at C:\Program Files\Common Files\System\ado\ You
may see files like msado21.tlb msado25.tlb msado26.tlb These tlb files( type
libraries) are the older versions of MDAC's 
installed that you can still reference
rather than the possible default higher version.
If you want to upgrade your NT system to MDAC 2.7
go to
http://www.microsoft.com/data/download

I would choose MDAC 2.71 SP1 Refresh
MS no longer allows MDAC downloads below MDAC 2.1

You can also download MDAC Utility: Component Checker
from the same page which will report on the version of MDAC installed 
automagically
you can download from here
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-
BF53-14332EF092C9&displaylang=en

So why did I tell you the long way.

Well you might as well update Jet while you are here.
There used to be Jet upgrades contained in the MDAC below 2.6 Now they are a
separate install and download You can use the long above procedure to check
which version of Jet is 
installed.
Look under C:\WINDOWS\system32\msjet40.dll or older version  msjet35.dll

So on url http://www.microsoft.com/data/download
scroll half way down to find downloads.

And install one the following Jet Service Packs depending on your OS Jet 4.0
Service Pack 8

Jet 4.0 SP8 is the latest service pack for Jet 4.0. It clears up sandbox 
problems.

SP 8.0 downloads are available for Windows 2000, Windows XP, and Windows 
Server 2003.

Jet 4.0 Service Pack 7
 for Windows 98, NT, and ME, download and install SP7
 
Jet 4.0 SP7 is available for Windows 98, Windows ME, Windows 2000, 
Windows NT, Windows XP, and Windows Server 2003.
 
One other caveat some older versions of VB6 programs may break on 
installation of ADO 2.7  The odds are about 1:100
I have only heard of this happening with some shareware programs. So just
recompile after pointing  reference to the correct ADO dll or tlb. Also some
of these SP's  will not work below Win98. Also you can check these version
numbers via VBA code if necessary.
 

Dan Waters wrote:

>On a client's PC that uses Windows NT, I am unable to locate the 
>reference for ADO 2.7 in the references window.  On my PC with WXP I 
>can find and check the library in the references window.  On my PC the 
>library file is msado15.dll, and the path is displayed in the 
>references window.  On the client's PC the msado15.dll file (same 
>version) is also located in the same directory as my PC.
>
>So the right file is in the right place but I can't select it as a 
>reference
>- what could be the reason for the ADO 2.7 library not appearing in the
>references window on the client's PC? 
>
>Any ideas would be helpful!
>
>Thanks,
>Dan Waters
>Quality Process Solutions 
>_______________________________________________
>dba-Tech mailing list
>dba-Tech at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/dba-tech
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list