I have 2 applications: .Net 1.1 application (wrote by another company) and Java application (our app).
Both apps use a same user and password to access to SQL Server 2005 (In some places it is Express release).
When I open .Net app, it reads and shows info. Also I can change info and it is writing to DB. Also I have refresh button to reload info from DB.
If I use 2 .Net apps, it are seeing a changes between them.
After openning .Net app, I am using Java app. Java app is writing some info to DB. But when I am going to .Net app and push refresh button, it doesn't bring me a changes from Java app. For get a changes I need to close .Net app and start it again
(Java app can be still up, and we don't need to close it).
As I think, it can be 2 different sessions and closing .Net app are free some resourses.
For fixed this problem I have tried: using 2 different SQL users, using SQL user + Windows user. But I have still a same problem.
Can you suggest me any solutions?
The .NET programmer
View Complete Post