Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Why is Data Disappearing in Multi-User environment

Posted on 2008-06-18
10
Medium Priority
?
233 Views
Last Modified: 2010-04-21
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
Comment
Question by:Sheritlw
  • 6
  • 4
10 Comments
 
LVL 4

Expert Comment

by:zx10r
ID: 21813384
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
 

Author Comment

by:Sheritlw
ID: 21813534
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
 
LVL 4

Expert Comment

by:zx10r
ID: 21813685
What about the code for vSchedules?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:Sheritlw
ID: 21813798
It is a view stored in SQL Server.  It is just like any view and works fine.
0
 
LVL 4

Expert Comment

by:zx10r
ID: 21813955
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
 

Author Comment

by:Sheritlw
ID: 21813980
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
 

Author Comment

by:Sheritlw
ID: 21814012
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
 
LVL 4

Accepted Solution

by:
zx10r earned 1500 total points
ID: 21814770
Might be worth to check the setting on the SQL Express where it is working and replicate them on the full version.
0
 

Author Comment

by:Sheritlw
ID: 21814788
What settings should I check?
0
 

Author Closing Comment

by:Sheritlw
ID: 31468358
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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question