How do i change this connect string to support a SQL Server 2000 running on port 8832 User ID=car;Pa

[Daniel]

How do i change this connect string to support a SQL Server 2000 running on
port 8832 User ID=car;Password=rat;Server=abc.def.hij;Initial Catalog=foobar
i tried Server=abc.def.hij:8823 and Server=abc.def.hij;port=8823 neither of
these work

 

[Morten Wennevik]

Hi Daniel,

According to this page

http://www.connectionstrings.com/

It looks like you need to do

"Data Source=abc.def.hij,8823;Initial Catalog=foobat;User
ID=car;Password=rat";