Professional Web Applications Themes
  1. #1

    Default ODBC standard TCP port number!

    Hi all,

    I appreciate if anyone could tell me what the standard TCP port number to
    make an ODBC connection to SQL Database from web server??

    Thanks..


    Min Guest

  2. #2

    Default Re: ODBC standard TCP port number!

    Min,

    1433

    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    "Min" <mintaung@hotmail.com> wrote in message
    news:%23Xx%23uTMRDHA.1804@TK2MSFTNGP11.phx.gbl...
    > Hi all,
    >
    > I appreciate if anyone could tell me what the standard TCP port number to
    > make an ODBC connection to SQL Database from web server??
    >
    > Thanks..
    >
    >

    Dinesh.T.K Guest

  3. #3

    Default Re: ODBC standard TCP port number!

    Is that the port that cisco router can take in access-list filter?? I tried
    port 1433 and the router in between doesn't take it...i mean there are a web
    server out there in DMZ and DB server(MSSQL2000) inside LAN..Cisco router is
    located between them..basically, i tried to open up a port in the router
    access-list to allow ODBC traffic connection to DB Server located in the
    LAN...and so on..
    I'm not sure it's the right port # that cisco router can pass the traffic
    through..

    Thanks..


    "Dinesh.T.K" <tkdinesh@nospam.mail.tkdinesh.com> wrote in message
    news:eVmbqYMRDHA.2332@TK2MSFTNGP10.phx.gbl...
    > Min,
    >
    > 1433
    >
    > --
    > Dinesh.
    > SQL Server FAQ at
    > [url]http://www.tkdinesh.com[/url]
    >
    > "Min" <mintaung@hotmail.com> wrote in message
    > news:%23Xx%23uTMRDHA.1804@TK2MSFTNGP11.phx.gbl...
    > > Hi all,
    > >
    > > I appreciate if anyone could tell me what the standard TCP port number
    to
    > > make an ODBC connection to SQL Database from web server??
    > >
    > > Thanks..
    > >
    > >
    >
    >

    Min Guest

  4. #4

    Default Re: ODBC standard TCP port number!

    thanks Dinesh and oj...guys i appreciate it..


    "oj" <nospam_ojngo@home.com> wrote in message
    news:#tI2SCNRDHA.2036@TK2MSFTNGP12.phx.gbl...
    > See if the following steps help.
    > 1. Run "SQL Server Network Utility" on the server and verify the desired
    TCP
    > port.
    > 2. Configure your Cisco router to forward request to SQL Server (i.e. open
    > that same port)
    > 3. Ensure your connection string is pointed to the same port (i.e. Data
    > Source=...,1433). Also take a look at Carl's site for more
    info
    > on connectionstring at [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
    >
    > --
    > -oj
    > RAC v2.2 & QALite!
    > [url]http://www.rac4sql.net[/url]
    >
    >
    > "Min" <mintaung@hotmail.com> wrote in message
    > news:en3olyMRDHA.3796@tk2msftngp13.phx.gbl...
    > > Is that the port that cisco router can take in access-list filter?? I
    > tried
    > > port 1433 and the router in between doesn't take it...i mean there are a
    > web
    > > server out there in DMZ and DB server(MSSQL2000) inside LAN..Cisco
    router
    > is
    > > located between them..basically, i tried to open up a port in the router
    > > access-list to allow ODBC traffic connection to DB Server located in the
    > > LAN...and so on..
    > > I'm not sure it's the right port # that cisco router can pass the
    traffic
    > > through..
    > >
    > > Thanks..
    > >
    > >
    > > "Dinesh.T.K" <tkdinesh@nospam.mail.tkdinesh.com> wrote in message
    > > news:eVmbqYMRDHA.2332@TK2MSFTNGP10.phx.gbl...
    > > > Min,
    > > >
    > > > 1433
    > > >
    > > > --
    > > > Dinesh.
    > > > SQL Server FAQ at
    > > > [url]http://www.tkdinesh.com[/url]
    > > >
    > > > "Min" <mintaung@hotmail.com> wrote in message
    > > > news:%23Xx%23uTMRDHA.1804@TK2MSFTNGP11.phx.gbl...
    > > > > Hi all,
    > > > >
    > > > > I appreciate if anyone could tell me what the standard TCP port
    number
    > > to
    > > > > make an ODBC connection to SQL Database from web server??
    > > > >
    > > > > Thanks..
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Min Guest

Similar Threads

  1. How to set non-standard SFTP Port
    By ltoews73 in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: May 28th, 06:26 AM
  2. Port number in a URL
    By Shafia in forum ASP.NET Building Controls
    Replies: 0
    Last Post: June 13th, 08:30 AM
  3. can i get cfmx to work on standard port (80)?
    By kilroy05 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: March 4th, 05:06 PM
  4. client port number
    By rkusenet in forum Informix
    Replies: 1
    Last Post: September 24th, 01:36 AM
  5. MySQL on non standard port yields error 111 on connect
    By Figmo in forum PHP Development
    Replies: 0
    Last Post: September 19th, 04:02 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