SQL Server, VFP, + Win 95 Prob.

[lachlanK]

Hi, I have a client / server app using VFP 6.0 + SQL Server 2000 which works successfully over a WAN.

Clients have various versions of windows.

In the weekend I added another branch to the user base. The 95 / 98 1st edition machines are giving me an "update conflict" error during some operations on remote views, which other versions of Windows have never done.

Any thoughts on why this may be, and perhaps any solutions?

Unfortunately is difficult for me to set up a test environment as I do not have a spare PC.

Thanks in advance.

- Lachlan

 

[rgbean]

Besides installing your application, are you also updating / installing the latest SQL server client software? I believe you'll want to make sure you are using MDAC 2.6 SP2 (or 2.7 RTM), available at

http://www.microsoft.com/data/.

Rick

 

[lachlanK]

Have done that now, seems to have corrected problem.

Seems strange that (whatever version was on there) could malfunction so badly, I had values mysteriously changing by 1 cent, etc.

Cheers,

- Lachlan