On Feb 26, 6:13 am, "C" <devp...@newfound.biz> wrote:
> I have a question that is prob. something really quick to solve..... I
> am writing a program using C# and VS2005 I have two diff. ms sql
> servers set up on one ip using different ports for each. I can connect
> to one of the servers using the standard port but I have not been able
> to connect to the other server. Is there a way in VS2005 to specify a
> port to connect on... wasnt there a way in vs2003? Any help would be
> awesome and greatly appreciated.
>
> thanks,
>
> cdp

wrote:

>On Feb 26, 6:13 am, "C" <devp...@newfound.biz> wrote:
>> I have a question that is prob. something really quick to solve..... I
>> am writing a program using C# and VS2005 I have two diff. ms sql
>> servers set up on one ip using different ports for each. I can connect
>> to one of the servers using the standard port but I have not been able
>> to connect to the other server. Is there a way in VS2005 to specify a
>> port to connect on... wasnt there a way in vs2003? Any help would be
>> awesome and greatly appreciated.
>>
>> thanks,
>>
>> cdp
>
>I figured it out and wow I feel stupid! I was trying....
>examplesqlserver.com:1234 and with a little experimentation usinb odbc
>I saw when i configured the port it was using a comma....
>examplesqlserver.com,1234 and then I went back and changed some
>settings and it worked!
>
>
>
>ttyl,
>
>
>cdp