Query running slow from workstation

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  January 8, 2007 at 11:52 am

  #122221

  Query run locally run from the server itself takes about 2 minutes however when run from workstation takes hours and eventually dies with the following error -

  any suggetions/advise greatly appreciated

   

  Many thanks!!!

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 8, 2007 at 12:08 pm

  #681851

  What's the error? 

  Greg

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  January 8, 2007 at 12:56 pm

  #681863

  sorry, here it is -

   

  [Microsoft][ODBC SQL Server Driver]TDS buffer length too large

• Jason Irwin

  SSC Veteran

  Points: 255

  More actions

  January 9, 2007 at 9:12 am

  #682049

  If you're using ODBC to connect from the workstation, you might want to check this out:

  http://support.microsoft.com/default.aspx/kb/176256

• Al Cook

  SSCertifiable

  Points: 6739

  More actions

  January 9, 2007 at 9:14 am

  #682051

  What is the Windows version on the client?  Check out these links;

  http://support.microsoft.com/kb/140536

  http://support.microsoft.com/default.aspx/kb/176256

  If that is not your problem, follow these instructions...

  On the Database Server

   Right Click MyNetworkPlaces -> Properties

   Right Click Local Area Connection -> Properties

   Select Internet Protocol(TCP/IP) -> Configure

   Go to Advanced Tab -> Speed & Duplex

    If the value is "auto"

    Set the Value to -> 100mb full

   

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  January 9, 2007 at 10:21 am

  #682087

  Thanks Jason and Al, will try and let you know -

  thanks again!!!