Specify Port in Connection String??

[NoCoolHandle]

I am trying to connect to SQL Server from a ADO Client and need to specify a Port for the connection.

I am using a non standard port and don't want to have to run the SQLClient tool on every PC that connects or build a DSN..

Any clues (my guess is I need to use the "Network Library" argument in the connection string, but I am finding it hard to get documentation.



Rob

 

[NoCoolHandle]

Got it...

Provider=sqloledb;
Network Library=DBMSSOCN;Server=xxx.xxx.xxx.xxx,8946

The DBMSSOCN = tcpip and the ,8946 specifies the port that SQL is waiting on.. (port 8946)

 

[bertrandkis]

You will find a wealth of information here:

http://www.able-consulting.com/ADO_Conn.htm

Enjoy
Bertrandkis