ODBC INSTALLER - alert about versions

RM, have you applied both service releases, #1 and #2, to your Office 97 installation? There are ODBC fixes in both. Also, have you run the System File Checker in Windows 98?

Add the service releases if you haven't already and then do this:

Have your Windows 98 CD Rom disk handy.

1.      Reboot the system and either hold the Ctrl key down right after memory post or when you see the “Starting Windows…” dialogue, touch the F8 key.
2.      Choose #5 Command (MSDOS)  Prompt only.
3.      At the dos prompt, change directories to X:\Windows\Command, with “X” being the directory where Windows is installed.
4.      Now type SCANREG/FIX <enter>
5.      Follow the dialogue and let Scanreg review your registry and make any necessary repairs.
6.      When Scanreg is done, reboot into Windows.

NEXT:

1.      Insert your Windows 98 CD Rom disk into the drive.
2.      Click Start, Run and type  SFC <OK>
3.      This will start the System File Checker.
4.      Click on the settings button and select “Check for changed and deleted files” and click OK to start.
5.      Replace any files that are detected as bad or corrupt. Also watch the file dates carefully and always try and replace older files (pre-May 1998) with newer files, and most important, always use the latest version numbers for all files. SFC will copy the old file to X:\Windows\Sysbckup in case you need it back.
6.      When SFC is done, reboot the system and note the performance.

Let me know if you need more!
Dennis

Dennis, thanks for such a speedy reply.

I don't know about any 'service releases' but they sound like megabytes of download.
I omitted the 'service releases' and followed the rest of your instructions.

Prior to this alert problem my system did everything I needed so I just need to restore what I had before.

SCANREG/FIX ran without incident.
SFC, with changed and deleted files ticked, reported nothing.

Rebooted after both above stages but the problem remains.
Pages from PWS involving access data appear at first then the browser starts timing out so I do have a real problem, and not the cosmetic one of swatting awya an alert.


Any further thoughts please?

RM, I can't help you if you don't want to help yourself. I suggested those service releases for a reason, much of which is that it makes Office 97 compatible with Windows 98, including the ODBC connectors. I know they are fairly large downloads, but what can I tell you. The incompatibility will tend to grow until this becomes a kernel crash.

Fair enough.

I find I have SR1 and confirmed that with the checker program downloaded from the MS site.

I am currently downloading SR2b. Estimated time 4 hours.#I hope it will be worth it, because I did not find anyuthing on ODBC in the list of fixed problems.

Thanks for your help.
Rodney

RN, see your post.

You uninstalled 97 and reinstalled it.

If this is the case, SR#1 must be reapplied and then SR#2.

I never installed SR1 as such it seems to be built in to the version of O97 I have, as evidenced by
a) The About screen
b) Results of the version test downloaded from MS site which told me it was OK to install SR2b

I downloaded SR2b patch and installed it. Ran the suggested procedures.
However, I still get the previously described alert concering the ODBC driver versions.

RM, after discussing this further with MS enginerring, here is what they recommend:

Use either or both methods as necessary:

Method 1:
---------
 
1. Move or remove shortcuts in the Startup group for any applications that use
   ODBC.
 
2. If Personal Web Server is installed on the computer, set the startup mode so
   it will not run automatically at startup.
 
3. Restart the computer.
 
   Alternatively, restart Windows 95, and hold down the SHIFT key while it is
   restarting. Doing this will start Windows 95 in safe mode, and will bypass
   most applications that load at startup.
 
4. Reinstall ODBC, or copy files with the correct version into the
   Windows\System directory.

**Office 97 in your case!
 
5. Restart your applications.
 
Method 2
--------
 
1. Rename the MSJT3032.DLL and ODBCJT32.DLL files in the C:\WINDOWS\SYSTEM
   directory.
 
2. Run the appropriate Setup program again.
 
Installing the updated versions of the MSJT3032.DLL and ODBCJT32.DLL files in
your C:\WINDOWS\SYSTEM directory allows you to successfully complete Setup.
 
MORE INFORMATION
================
 
You can download ODBC version 3.0.2301 from:
 
   http://support.microsoft.com/support/downloads/dp2445.asp
 
You can download ODBC version 3.0.2822 (ODBC 3.0 Service Pack 1) from:
 
   http://www.microsoft.com/data/odbc/download/dmdownload.htm
 
   -or-
 
   ftp://ftp.microsoft.com/developr/ODBC/public/odbcdmin.exe
 
You can download ODBC version 3.5 (MDAC) from:
 
   http://www.microsoft.com/data/mdac2.htm
 
If you are installing ODBC 3.5, please see the following article(s) in the
Microsoft Knowledge Base:
 
   Q177913 HOWTO: Use the MDAC Standalone Setup EXE in Unattended Mode
 
   Q177136 INFO: Required Files to Install MDAC 1.5 (ODBC/OLEDB/ADO/RDS)
 
The ODBC core files are usually listed in the ODBC Administrator (on the About
tab), and are located in the Windows\System(WIN 9X) or windows\system32(WINNT)
folder. They consist of the following files:
 
   Odbccp32.dll   ODBC Administrator DLL
   Odbccp32.cpl   Control Panel Device
   Odbcad32.exe   Control Panel Startup
   Odbccr32.dll   Cursor Library
   Odbc32.dll     Driver Manager
   Odbcint.dll    Localized Resource DLL
 
The following files are not shown in Control Panel ODBC Administrator, but may
contribute to the problem. They are also located in the Windows\System(WIN 9.X)
or Windows\system32(WINNT):
 
   Odbcstf.dll    Setup file
   Odbctrac.dll   Trace functions
   Odbc16gt.dll   Thunking file
   Odbc32gt.dll   Thunking file
   Ds16gt.dll     Thunking file
   Ds32gt.dll     Thunking file

Sorry for the delay... you know how it is.
It found the page http://www.microsoft.com/Data/faq.htm with links to the MDAC articles including the one mentioned but wihtout exception the links 404'd.

Adjusted points to 300

Well I think, with your help, I have cracked it finally.
I downloaded and ran a reinstall odbcdmin.exe but it appeared to have no effect on the key files.

Then I concentrated on odbc32int.dll which was the one file to have a slightly out of step version number to the rest of the files listed in ODBC Adminstrator under the 'About' tab.

I thought perhaps that I could restore just that file with the utility you put me on to : sfc : System File Checker
using Run SFC OK I tried that but the problem was finding another file odbc32int.dll on the Windows98 CD. There is a fair bit of ODBC stuff in the pws folder but not that file.

So I thought maybe I could get a full set, wioth matching version numbers from another computer and use sfc to replace the old files. I copied all the files listed on the ODBC About tab from my laptop to a diskette - a total of just 544kb.

The using SFC and its option to extract one file from installtion disk I did that for each file suing the diskette as the source, so just putting A:\ for the source location.

After that, even without a restart, I was able to start up a web application under PWS using ODBC data access without seeing the alert about different versions of drivers.

I strongly suspect that if I had merely copied the files to windows/system rather using sfc I would have hit some troubles and since I knew nothing of sfc before you briefed me on it that was valuable and I thank you deeply for the time attention you have given to answering my question.

Although much of what I have done now appears obvious - isn't it always so? - I hope my description of what worked will help someonelse, looking in the question archives.

All the best,


Rodney

Great work Rod, and I'm certain that it will help someone else. There's a number of great tools in Win98, one that provides allot of info is System Information. Click through the various areas and you'll see what I mean.