Solved

Why is Data Disappearing in Multi-User environment

Posted on 2008-06-18
10
185 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
Comment Utility
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
Comment Utility
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
Comment Utility
What about the code for vSchedules?
0
 

Author Comment

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

Expert Comment

by:zx10r
Comment Utility
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Sheritlw
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
What settings should I check?
0
 

Author Closing Comment

by:Sheritlw
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now