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

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";


On Thu, 16 Dec 2004 12:33:09 -0800, Daniel
<(E-Mail Removed)> wrote:

> 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
>
>



--
Happy Coding!
Morten Wennevik [C# MVP]