Re: ADO with MS SQL using custom port

From: Andrew Diabo (aadiabo_at_ix.netcom.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 14:36:17 -0400

Hi Steve,

Thanks a million. Will give that a try.

Andrew

"Steve Troxell" <steve_troxell@hotmail.com> wrote in message
news:40b44efd@newsgroups.borland.com...
> Andrew Diabo wrote:
> > Is there a way to specify the port in ADO when creating an
> > application that accesses a MS SQL Server?
>
> In the connection string:
>
> Server="<servername>,<port-number>"
>
> Note it's a comma, not a colon like you would normally expect with a port
> number reference.
>
> Steve Troxell
>
>

Relevant Pages

  • Re: Bug with instanceName property?
    ... If you specify a portnumber attempt to connect using port number. ... I installed SQL Server 2005 on a ... > you get a more efficient connection since it doesn't need to connect to ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: To allow inbound traffic from a specific ip
    ... create a new protocol for ... specify in the Primary connection in the Protocol field TCP ... TCP, and the direction as inbound, and the port range that you seen, note ...
    (microsoft.public.isa.configuration)
  • Re: Why does printk helps PCMCIA card to initialise?
    ... and can also specify how many IO address lines they ... restriction for a card; if it only decodes 3 lines, ... port boundary. ... are specified that the meaning is complicated. ...
    (Linux-Kernel)
  • Re: Passive mode FTP under Solaris 10?
    ... I've come to understand that I need to specify a range of high ports ... There seems to be alternate ftp server software that's easy to ... When any control connection matching ... Allows control of the TCP port numbers which may be used ...
    (comp.unix.solaris)
  • Re: BTS2004 Dynamic Send Port with XmlDocument and SOAP
    ... The send port will need an assembly and class specified as context ... will be used to call the web service. ... This gives the adapter enough information to create the proxy ... specify an Assembly in my message. ...
    (microsoft.public.biztalk.general)