ADO connectstring for SQLServer not port 1433

right now I am using this connect string:
"DRIVER={SQL
Server};SERVER=myserver;DATABASE=mydatabase;Trusted_Connection=yes;"
or
"DRIVER={SQL
Server};SERVER=myserver;DATABASE=mydatabase;Trusted_Connection=no;UID=userna
me;PWD=password;"

but what if my sqlserver is not on the default port (1433)?

thanks,
owen


.

Relevant Pages

  • Re: browsing a web site with ends in :8383
    ... The all string. ... > isa 2000 ... is it because it use a non standard 80 port? ... Prev by Date: ...
    (microsoft.public.isaserver)
  • SQL SERVER INSTANCES
    ... Tipically when I create a new SQLSERVER 2000 instance I ... put a new port number or the same port number of my ... default istance? ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: Migrating from VB6 and Printer object
    ... You can use the GetPrinter API call to get all the information (such as Port name) - e.g. ... ByRef phPrinter As Int32, _ ... Public pServerName As String ... Dim dmOut As New DEVMODE ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Serial port error statistics - any comparable data?
    ... Alas - the port in question is the native legacy motherboard port. ... The "cluster" in all the cases observed is the loss of exactly one character, ... "The quick brown fox jumps over the lazy dog 0123456789" ... the string from a port unblocked with fcntl - and the throw away python ...
    (comp.lang.python)
  • Re: How to convert array to string, and vice versa
    ... and converting it to a single string: ... then I have a string I can write to the database record. ... information about the port optics. ... to have a set of port-records, pointing to the interface card. ...
    (comp.lang.php)