Re: ADO with MS SQL using custom port

From: Steve Troxell (steve_troxell_at_hotmail.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 04:02:04 -0400

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

  • ADO with MS SQL using custom port
    ... Is there a way to specify the port in ADO when creating an application that ... accesses a MS SQL Server? ...
    (borland.public.delphi.thirdpartytools.general)
  • connection through internet to SQL Server
    ... My Delphi 7 application connects to a local SQL Server 7 using ADO, ... Is there anything I can do or I will have to open that port? ...
    (borland.public.delphi.database.ado)
  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
    (microsoft.public.sqlserver.setup)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)