Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Why is Data Disappearing in Multi-User environment

Hi Experts,

I have a strange situation going on and really need your help.
I have a scheduling app with a VB 6 front end and a sql server 2005 backend.  
When using the program as a single user all scheduled appointments are displayed, but when using in a multi-user environment some schedules don't show.  The client says it is random.
I have checked on my machine with their database and front-end and nothing seems to be wrong, but this is as a single user.
The schedules to be displayed is retrieved using ADO and a view, there is no binding.  Is there some setting in SQL Server that needs to be checked, or some other thing that could cause this to happen?
Thanks
0
Sheritlw
Asked:
Sheritlw
  • 6
  • 4
1 Solution
 
zx10rCommented:
Can you provide more info on how the process works for retrieving the schedule information for each user? Maybe the code for the view as well.
0
 
SheritlwAuthor Commented:
The code is the same for each user.  The front end uses ADO to connect and retrieve data from a view in SQL Server.   Their is no binding so it is sql syntax that is sent to the server to retrieve the information needed from the view.
I don't know how the client has their SQL Server configured and since the program brought in all the data as a single user, but not when used in a multiple user environment, I tend to think their are some settings I need to look for.
The code from the vb front end is
Select * from vSchedules where scheddate = '" & dDate & "'"
0
 
zx10rCommented:
What about the code for vSchedules?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
SheritlwAuthor Commented:
It is a view stored in SQL Server.  It is just like any view and works fine.
0
 
zx10rCommented:
I do not think this is a SQL issue if the view is returning correct data, that being multiple or single requests. Check the on the front end where the data is being displayed, it might be a problem there.
0
 
SheritlwAuthor Commented:
The strange thing is that in a single user environment the data displays just fine, it's only when multiple users are on the system the information doesn't get displayed.
0
 
SheritlwAuthor Commented:
Also, other clients use the program in a multi-user environment, but with sql server express as the backend and don't have any problems.
0
 
zx10rCommented:
Might be worth to check the setting on the SQL Express where it is working and replicate them on the full version.
0
 
SheritlwAuthor Commented:
What settings should I check?
0
 
SheritlwAuthor Commented:
I did a webx with the client and found out they had a filter applied that would stop the information from show.  Problem solved.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now