How there a utility to make connection string

15 Nov 2005 1:48 PM

ad

I often make mistake when making a connection to SqlServer.
I heard that there is a utility to make connection in Sql2005.
Has that?

15 Nov 2005 2:39 PM

Kalpesh

Use Server Explorer in VS.NET & see the properties of the connection
Alternatively, www.connectionstrings.com might help :)

HTH
Kalpesh

15 Nov 2005 5:09 PM

William (Bill) Vaughn

The 2.0 Framework includes a new "StringBuilder" class that can help.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote

"ad" <fly***@wfes.tcc.edu.tw> wrote in message
news:%23coV8se6FHA.2616@TK2MSFTNGP15.phx.gbl...
>I often make mistake when making a connection to SqlServer.
> I heard that there is a utility to make connection in Sql2005.
> Has that?
>

15 Nov 2005 8:45 PM

ad

I have used StringBuilder to make ordinary string for a long time.

How can I use it to make connection string?

Show quote

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> ¼¶¼g©ó¶l¥ó·s»D:u7uIAcg6FHA.***@TK2MSFTNGP10.phx.gbl...
> The 2.0 Framework includes a new "StringBuilder" class that can help.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "ad" <fly***@wfes.tcc.edu.tw> wrote in message
> news:%23coV8se6FHA.2616@TK2MSFTNGP15.phx.gbl...
>>I often make mistake when making a connection to SqlServer.
>> I heard that there is a utility to make connection in Sql2005.
>> Has that?
>>
>
>

20 Nov 2005 8:14 AM

Sahil Malik [MVP]

I think Bill meant "ConnectionStringBuilder"

... anyway .. yes you can use SqlConnectionStringBuilder to create a
connection string for SQL Server etc. programmatically, but if you want that
GUI, where the user can specify details and connect to the SQL Server, you
should look into SMO (Sql Server Management Objects).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

----------------------------------------------------------------------------

Show quote

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:u7uIAcg6FHA.632@TK2MSFTNGP10.phx.gbl...
> The 2.0 Framework includes a new "StringBuilder" class that can help.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "ad" <fly***@wfes.tcc.edu.tw> wrote in message
> news:%23coV8se6FHA.2616@TK2MSFTNGP15.phx.gbl...
>>I often make mistake when making a connection to SqlServer.
>> I heard that there is a utility to make connection in Sql2005.
>> Has that?
>>
>
>