Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Langley, British Columbia, Canada
    Posts
    13

    Unanswered: Named Pipes vs TCP

    How would one go about adjusting the default connection to the SQL Server on the client side, using either Named Pipes or TCP as the default?
    Jeff Jonsson

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Look for the Client Network Utility tool in the SQL Server program group. Or start->run CliConfig.exe.

  3. #3
    Join Date
    Jan 2003
    Location
    Langley, British Columbia, Canada
    Posts
    13
    any way to pull of the defaulting programmatically??
    Jeff Jonsson

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, but the mechanics vary a lot depending on how you are programming. The easiest/surest way is to use the NETWORK parameter within DSN-Less connection strings.

    -PatP

  5. #5
    Join Date
    Jan 2003
    Location
    Langley, British Columbia, Canada
    Posts
    13
    Looks like the ticket, thanks for your assistance...
    Jeff Jonsson

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •