Hi All!
I have a visual foxpro 9 application that uses SQL Server 2000 as a backend. The application communicates using SQL pass through.
I have a new problem, something we have never noticed before. All of a sudden, I have a situation where the app is sending INSERTs and UPDATE, the server is not reporting an error yet the data changes never happen. I can see the statements coming through on SQL Profiler but it tells me that there are zero writes for the statement.
It gets a little better, here. This is not 100% consistent. They can enter the same transaction multiple times and it won't work x times but at x+1 it will write. Obviously, the code being executed at the client is exactly the same.
The client OS is win2000 Pro and the SQL Server os in win2000 Server.
Any ideas?