Gee, I hate having to answer my own questions.
Not exactly obvious - found it by looking at the SQL server client registry
settings.
Just include the port number in the Data source property eg DataSource =
MyServer, myport. eg SQL1,2048
> -----Original Message-----
> From: Myles Penlington [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, June 03, 2000 2:32 PM
> To: Multiple recipients of list delphi
> Subject: [DUG]: SQL Sever ADO Connection properties - 2nd Attempt
>
> Hi,
>
> We have SQL server 7.0 listening on TCP/IP, on a different port than the
> standard 1433.
>
> How in a ADO connection string do you specify the different port number??
> WITHOUT installing the SQL server Client Network configuration utility on
> the client end or creating a ODBC DSN on the client end - both of which I
> know get around the problem, but these are not feasible solutions in this
> case.
>
> I can't seem to find any documentation on this one.
>
> Thanks,
>
> Myles Penlington
> Advanced Management Systems Ltd
> www.ams.co.nz/email
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
