Solved

Why is Data Disappearing in Multi-User environment

Posted on 2008-06-18
10
202 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 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