Solved

Why is Data Disappearing in Multi-User environment

Posted on 2008-06-18
10
225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

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 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

729 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