[RESOLVED] Connection String (SQL 2005) using a non standard port

Hi Guys

I need to set up a connection string to a SQL 2005. We have the database listening on a port other then the default on (1433)....

I looked on ConnectionStrings but did not see anything.


I thought it would be like ServerName\InstanceName,port;

That did not work.

Help

Thanks Gary

That should be the way, here's their example:

Code:

---

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

---

OK found out they place the slash the wrong way. Done