MartyConnelly
martyconnelly at shaw.ca
Sat Jan 10 12:33:23 CST 2004
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/dllinfo.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