Windows

General discussion

Gravatar
0 Votes
Locked

Win 2K/ Access/SQL data loss

By jorozco ·
Data loss (data that got corrupted and disappears (ms-sql:data type=image, ms-access: ole object) in the following scenario:
? Server: Windows NT4 with SP6a and SQL Server 7.0 (7.00.961)
? Client: Windows 2000 Pro with SP2 and Access 97
The file C:\Program Files\Common Files\System\OLE DB\oledb32.dll has the following version number:
? Server: 2.10.4202.0
? Client: 2.52.6019.0
There was a recommendation that we should have the same version of MDAC (2.5) in both, servers and clients.
Questions:
1. We should expect any problem installing MDAC 2.5 in the WinNT4 server?
2. Do you have any recommendations?

microsoft answer:
The version of MDAC on the server should have no interaction with the version of MDAC on the client. The client connects directly to the server, not through MDAC on the server.
There should be no problems installing MDAC 2.5 on the NT4 server, but that most likely will not solve their problem.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Win 2K/ Access/SQL data loss

by jim.brown In reply to Win 2K/ Access/SQL data l ...

for your data loss I would reinstall MDAC on the clients, reapply the database connections

MDAC 2.5:
1.No, the install is seamless.

2.I haven't had any problems with 2.5, we use it with SQL 6.5/7.0/2000

As for the Microsoft answer they areright about the client not using the servers MDAC. but if you have 2.5 on the clients you may as well have it as standard over the domain

Back to Windows Forum

Start or search

Related Discussions

Related Forums