Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL SERVER and Application / Client Interaction

Posted on 2011-09-29
8
Medium Priority
?
237 Views
Last Modified: 2012-05-12
I have an application that runs on Windows Server 2003 R2 with SQL Server.  Client machines use the application (it appears it's installed on each client) and access a medical clinic customer management system database.

We are having trouble with some records showing that they are "open" when they are not.
The application software company has opined that one of our client machines is "broken" because if IT opens a customer record, thereafter the record appears to be already open to the other client machines.

Does this seem reasonable?
I can install Wireshark and look at packets in and out of the "culprit" machine but I have to wonder if SQL Server would allow a record to remain "open" if it isn't.  Ditto whatever bit that shows that it's "open".

I know nothing about the implementation of the application and next to nothing about SQL Server.
0
Comment
Question by:Fred Marshall
[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
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 2

Accepted Solution

by:
pablito70 earned 2000 total points
ID: 36818939
Hello,
for records "open" means records locked ?
Try to look at: http://support.microsoft.com/kb/323630 if there are something that can help you or your supplier.
Or you can check for locks through Microsoft SQL Server Management Studio (Enterprise Manager if you running MSSQL 2K or less).
paolo
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36893193
"We are having trouble with some records showing that they are "open" when they are not."
Where do you see that? Is there any message saying that the record is "open"?
I bet that is in your application and if that's the case I guess is the app that flags it "open" somehow in the database. Why that "open" status is not released if ALL clients are disconnected from the app - you can guess it: it's the bad app that does not handle very well connections when they are closed or crashed.

Good Luck!
0
 
LVL 26

Author Comment

by:Fred Marshall
ID: 36894037
pablito70:  perhaps easier said than done.  
"you can check for locks through Microsoft SQL Server Management Studio "
How do you do that?  It's not obvious to me as I know next to nothing about SQL Server
This one is SQL Server 2005.

icohan:  Perhaps so but that is not going to be a very easy row to hoe.  Been there.
I haven't seen the message myself.  The folks using the app have talked with the app supplier.  Apparently what they see is some message when they try to open one of those records.  
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 40

Expert Comment

by:lcohan
ID: 36894142
In that case please try use Activity Monitor in SQL 2005 SSMS and look for the Bloking/Blocked by columns or you can try execute sp_who2 in a new  query against your server.
For activity monitor open SSMS and look for it under Management section.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36895252
>> I know next to nothing about SQL Server<<
Then please don't take this the wrong way, but you are going to have to find someone that does and can optionally give you hands on training.
0
 
LVL 2

Assisted Solution

by:pablito70
pablito70 earned 2000 total points
ID: 36895609
Hello,
agree with Icohan; I would prefer first check that there aren't strange locks condition of records/tables on SQL Server, than troubleshooting on application. If the record status, from application side, is managed by a particular field with fixed values (i.e. Open, Closed, Pending, etc) IMHO you have to check on db the status of this field when the software performs insert/update/delete transactions.

my 2 cents.
paolo
0
 
LVL 26

Author Comment

by:Fred Marshall
ID: 36897651
acperkines:  My "someone that does (know) is EE"  I can read well enough and I can navigate well enough.  And I can cobble together some "language" things if necessary.  Knowing where to start is a big help!

Icohan:  I'll try that.

0
 
LVL 26

Author Closing Comment

by:Fred Marshall
ID: 37347734
Thanks!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

636 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