Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Muhammad Majid Ali Attari
  Where is Muhammad Majid Ali Attari?
 Hyderabad
 Pakistan
 Muhammad Majid Ali Attari
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Slow Reponse From DB Server
Thread ID: 344602 Message ID: 345002 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 17, 2012 6:54:52 AM         
   


> >
> >
> > Logs on server are as:
> >
> > unexpected EOF on client connection
> > could not send data to client
> >
> > Regards,
> >
> > Muhammad Majid Ali Attari
>
>
> Hi,
> Sounds like a networking disconnect issue to me.
> - NIC card or drivers.
> - Network cabling.
> - On one workstation only, check NIC card and drivers on that workstation.
> - As a simply test try copying a 40-50 Meg file or files from server to workstation and see what happens.
> Repeat the above copy 5-6 times and see if you get an error in copying.
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com

netwrok is perfect. i was trying to figure it out. i was not applying SQLDISCONNECT() at exit of my app assuming that the connection will be ended automatically. i came to know that if i you dont terminate a connection to postgre server, it has been left open. although i could not watch those left open connections in server status window. but i applied it and added SQLDISCONNECT() at exit of app. it has been 3 days, client has not complained for slow response of server. hoping that i applied the right and learned a new lesson.
well Pete, thanx 4 ur time. if i get any update, i will bother this thread again. thanx again

Regards,

Muhammad Majid Ali Attari

ENTIRE THREAD

Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/11/2012 9:13:48 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/11/2012 5:02:20 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/12/2012 7:21:34 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/12/2012 11:03:48 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:13:04 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/14/2012 2:49:10 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:30:32 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/15/2012 2:15:30 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:54:52 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/17/2012 6:22:45 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:34:34 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/14/2012 7:45:39 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:32:14 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/15/2012 11:07:57 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:55:51 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/17/2012 7:08:04 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 11:28:23 AM