deficulty in getting data from server and display the same

[taurusone]

Hi all,

plz help me out from the problem i am facing

I am a junior developer and i am working on a already developed VB.Net project. many of the employees in my company (around

45 employees) use this software to store customer details (starting from enquiry to invoice).

This software is connected to a Windows Server 2003 (via LAN) to store data (data is stored in sql server 2008). BUt now a

days many users (around 20) are facing problem in getting the data displayed on the software (usually on data gridview) and

also software repondes very slowly (some times it displays timeout error).

There was no changes made to client system or server. The system administrator and network administrator are very close to

me. Even they are not able to find out what is causing this issue. We have done a virus scan and installed windows updates on

client machine (or computer) and server, but no luck.

Can anyone plz tell what might have gone wrong or what might be causing this issue??? any solution to this problem.

additional info: The vb.net software was develped using visual studio .net 2002 and .net 1.1

 

[JuggaloBrotha]

Are there any error messages in your app? What's the stack trace?

Additionally, are you able to connect to the DB server in SSMS using the same credentials as the app's connection string?

 

[taurusone]

Are there any error messages in your app? No... some times app stops responding.. some time it gives error message 'time out' because it crossed the default 30 sec time to fetch the data from sql server


What's the stack trace? what is it and how to trace it


Additionally, are you able to connect to the DB server in SSMS using the same credentials as the app's connection string? yes with out any issues

 

[JuggaloBrotha]

Are there any error messages in your app? No... some times app stops responding.. some time it gives error message 'time out' because it crossed the default 30 sec time to fetch the data from sql server


What's the stack trace? what is it and how to trace it


Additionally, are you able to connect to the DB server in SSMS using the same credentials as the app's connection string? yes with out any issues

Can the user's pc's ping the DB server?

Really without knowing what the error message is (yes, there is one) it's difficult for anyone here to be able to help you figure it out.
Can you post the code? Post the entire try/catch block around one of the DB interaction sections of your code.

The stack trace is part of the exception when the try/catch block catches one, there's an error message and the whole stack trace that lead to the exception happening.

 

[Herman]

Check wiring... 90% of the time these issues are caused by a network cable not pushed all the way into its socket.