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

Thread view:

Tree View List View (postings sorted by date) Single Message View

Enable EMail Alerts  Start New Thread

Thread rating:

Daniel - 16 Dec 2004 20:31 GMT

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

Reply to this Message

Morten Wennevik - 16 Dec 2004 21:55 GMT

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

> How do i change this connect string to support a SQL Server 2000 running  
> on
[quoted text clipped - 3 lines]
> of
> these work

Signature

Happy Coding!
Morten Wennevik [C# MVP]

Reply to this Message