Solved

Why is Data Disappearing in Multi-User environment

Posted on 2008-06-18
10
222 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…

742 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