TDS and character encoding - Framework and Interface Programming

This is a discussion on TDS and character encoding - Framework and Interface Programming ; On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote: >I've exactly the same trouble ... My apps is responding fine on a LAN >but when I goes on a WAN, getting horrible ! > >>From 5 sec to 7 ...

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 61 to 63 of 63

TDS and character encoding

  1. Default Re: TDS and character encoding

    On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote:

    >I've exactly the same trouble ... My apps is responding fine on a LAN
    >but when I goes on a WAN, getting horrible !
    >
    >>From 5 sec to 7 min ... When I look SQL Time is the same so I look
    >network usage with network ****yser and find the same result a you !

    Just to make sure one basic point is covered, do all the stored
    procedures have SET NOCOUNT ON right at the beginning? Leaving that
    out can magnify network issues.

    Roy Harvey
    Beacon Falls, CT

  2. Default Re: TDS and character encoding

    On Thu, 27 Sep 2007 08:54:30 -0700, bzh_29 <xiii29@free.Fr> wrote:

    >I've exactly the same trouble ... My apps is responding fine on a LAN
    >but when I goes on a WAN, getting horrible !
    >
    >>From 5 sec to 7 min ... When I look SQL Time is the same so I look
    >network usage with network ****yser and find the same result a you !

    Just to make sure one basic point is covered, do all the stored
    procedures have SET NOCOUNT ON right at the beginning? Leaving that
    out can magnify network issues.

    Roy Harvey
    Beacon Falls, CT

  3. Default I don't know your business, but even if you are not aiming at the Far Eastern market,

    I don't know your business, but even if you are not aiming at the Far
    Eastern market, you may expand into Poland or Hungary one day. That's
    enough reason to use Unicode.

    Developing for Unicode from the start is cheap. Changing to Unicode after
    the fact is expensive.

    And if you use varchar in your application, what is really your problem?
    The only Unicode you need to send is the name of the stored procedures you
    call? Or are you sending query batches from the application? Now, if you
    do that, there are some bytes you can save by using stored procedures
    instead.
    London Escort Agencies how to play seven seven
+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
« Simple FPGA project with USB interface | Different Versions of Object Libraries »

Similar Threads

  1. TDS and character encoding
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 08-30-2007, 09:26 AM
  2. Character Encoding
    By Application Development in forum C
    Replies: 2
    Last Post: 12-15-2006, 05:58 PM
  3. RE: SAX Via MSXML3.DLL XML Character encoding
    By Application Development in forum XML SOAP
    Replies: 1
    Last Post: 09-13-2006, 01:37 AM
  4. XMLHTTP.send and character encoding
    By Application Development in forum XML SOAP
    Replies: 1
    Last Post: 09-23-2004, 02:53 AM
  5. character encoding with jsp multipart uploads
    By Application Development in forum Java
    Replies: 0
    Last Post: 12-01-2003, 08:39 PM