Professional Web Applications Themes

Different connection types - ASP Database

I am interested in why we use different connection types between ASP pages and MS SQL Server? And connections created within sql server its self, What is the prefered way and why in each case I have read the technet details but from a real worl perspective, what should i use and when. Just so I make the right choice !. Regards Don ie Named Pipes - Network Library=DBNMPNTW TCP/IP - Network Library=DBMSSOCN Multi Protocol - Network Library=DBMSRPCN...

  1. #1

    Default Different connection types

    I am interested in why we use different connection types between ASP pages
    and MS SQL Server?
    And connections created within sql server its self, What is the prefered way
    and why in each case
    I have read the technet details but from a real worl perspective, what
    should i use and when.
    Just so I make the right choice !.
    Regards
    Don

    ie
    Named Pipes - Network Library=DBNMPNTW
    TCP/IP - Network Library=DBMSSOCN
    Multi Protocol - Network Library=DBMSRPCN




    Don Grover Guest

  2. #2

    Default Re: Different connection types

    It depends on what network protocols you are running on your network.

    TCP/IP relies on TCP/IP being enabled
    Named Pipes relies on NetBT I think ('cause you need to authenticate to
    \\server\IPC$)
    MultiProtocol is RPC if I recall correctly

    You might be better off asking in an SQL Server group...

    Cheers
    Ken

    "Don Grover" <spamfreeassoft.com.au> wrote in message
    news:Oxjb1XZoDHA.1072TK2MSFTNGP09.phx.gbl...
    : I am interested in why we use different connection types between ASP pages
    : and MS SQL Server?
    : And connections created within sql server its self, What is the prefered
    way
    : and why in each case
    : I have read the technet details but from a real worl perspective, what
    : should i use and when.
    : Just so I make the right choice !.
    : Regards
    : Don
    :
    : ie
    : Named Pipes - Network Library=DBNMPNTW
    : TCP/IP - Network Library=DBMSSOCN
    : Multi Protocol - Network Library=DBMSRPCN


    Ken Schaefer Guest

  3. #3

    Default Re: Different connection types

    Actually, here is a better answer:
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsentpro/html/veconchoosingsqlserversnetworkprotocol.asp[/url]

    and here's another article:
    [url]http://www.winnetmag.com/Article/ArticleID/14360/14360.html[/url]
    and
    [url]http://www.sqlmag.com/Articles/Index.cfm?ArticleID=5923[/url]

    HTH

    Cheers
    Ken


    "Don Grover" <spamfreeassoft.com.au> wrote in message
    news:Oxjb1XZoDHA.1072TK2MSFTNGP09.phx.gbl...
    : I am interested in why we use different connection types between ASP pages
    : and MS SQL Server?
    : And connections created within sql server its self, What is the prefered
    way
    : and why in each case
    : I have read the technet details but from a real worl perspective, what
    : should i use and when.
    : Just so I make the right choice !.
    : Regards
    : Don
    :
    : ie
    : Named Pipes - Network Library=DBNMPNTW
    : TCP/IP - Network Library=DBMSSOCN
    : Multi Protocol - Network Library=DBMSRPCN
    :
    :
    :
    :


    Ken Schaefer Guest

  4. #4

    Default Re: Different connection types

    Thanks Ken.
    Interesting reading.
    Many Thanks


    "Ken Schaefer" <kenREMOVETHISadOpenStatic.com> wrote in message
    news:uFszrgcoDHA.2416TK2MSFTNGP10.phx.gbl...
    > Actually, here is a better answer:
    >
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsentpro/html/veconchoosingsqlserversnetworkprotocol.asp[/url]
    >
    > and here's another article:
    > [url]http://www.winnetmag.com/Article/ArticleID/14360/14360.html[/url]
    > and
    > [url]http://www.sqlmag.com/Articles/Index.cfm?ArticleID=5923[/url]
    >
    > HTH
    >
    > Cheers
    > Ken
    >
    >
    > "Don Grover" <spamfreeassoft.com.au> wrote in message
    > news:Oxjb1XZoDHA.1072TK2MSFTNGP09.phx.gbl...
    > : I am interested in why we use different connection types between ASP
    pages
    > : and MS SQL Server?
    > : And connections created within sql server its self, What is the prefered
    > way
    > : and why in each case
    > : I have read the technet details but from a real worl perspective, what
    > : should i use and when.
    > : Just so I make the right choice !.
    > : Regards
    > : Don
    > :
    > : ie
    > : Named Pipes - Network Library=DBNMPNTW
    > : TCP/IP - Network Library=DBMSSOCN
    > : Multi Protocol - Network Library=DBMSRPCN
    > :
    > :
    > :
    > :
    >
    >

    Don Grover Guest

Similar Threads

  1. Net connection without Internet connection whoas
    By calmchess333 in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: June 11th, 12:29 AM
  2. Replies: 6
    Last Post: March 14th, 10:40 PM
  3. Disparity between XML Schema types and .Net CLS types
    By MikeL in forum ASP.NET Web Services
    Replies: 2
    Last Post: February 22nd, 06:08 AM
  4. One NFS connection fine, one NFS connection slow
    By Robert E A Harvey in forum Linux / Unix Administration
    Replies: 5
    Last Post: May 28th, 07:28 AM
  5. Have internet connection but not workgroup connection.
    By Steve Winograd [MVP] in forum Windows Networking
    Replies: 2
    Last Post: July 18th, 10:01 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139