Control for Sql Connection?

[someone]

Hi all,
I need to let the users of my windows app select the Sql Server and
database they want to connect to and enter their Sql userid and password. Is
there a control available either in Visual Studio 2005 or by any third party
vendors to do this?

Thanks in advance.

[Nicholas Paldino [.NET/C# MVP]]

someone,

There is a dialog that VS.NET uses for SQL Server connections, but it is
a part of VS.NET 2005, and not really for distribution (using it is a little
bit of a hack).

You might be better off just creating a control which gets the
appropriate information from the user and then working with that.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"someone" <no****@stopspam.com> wrote in message
news:Oc**************@TK2MSFTNGP03.phx.gbl...

Hi all,
I need to let the users of my windows app select the Sql Server and
database they want to connect to and enter their Sql userid and password.
Is there a control available either in Visual Studio 2005 or by any third
party vendors to do this?

Thanks in advance.

[someone]

Thanks for your reply.
If I develop a VBA application in Excel instead of a Windows app, is
there a way to use the VS.Net dialog for Sql connections without hacks?

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:et*************@TK2MSFTNGP05.phx.gbl...

someone,

There is a dialog that VS.NET uses for SQL Server connections, but it
is a part of VS.NET 2005, and not really for distribution (using it is a
little bit of a hack).

You might be better off just creating a control which gets the
appropriate information from the user and then working with that.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"someone" <no****@stopspam.com> wrote in message
news:Oc**************@TK2MSFTNGP03.phx.gbl...

Hi all,
I need to let the users of my windows app select the Sql Server and
database they want to connect to and enter their Sql userid and password.
Is there a control available either in Visual Studio 2005 or by any third
party vendors to do this?

Thanks in advance.

[Nicholas Paldino [.NET/C# MVP]]

someone,

No, there isn't. It's not a function of whether or not you use VBA, but
the assembly that the dialog is located in.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"someone" <no****@stopspam.com> wrote in message
news:uW**************@TK2MSFTNGP03.phx.gbl...

Thanks for your reply.
If I develop a VBA application in Excel instead of a Windows app, is
there a way to use the VS.Net dialog for Sql connections without hacks?

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in message news:et*************@TK2MSFTNGP05.phx.gbl...

someone,

There is a dialog that VS.NET uses for SQL Server connections, but it
is a part of VS.NET 2005, and not really for distribution (using it is a
little bit of a hack).

You might be better off just creating a control which gets the
appropriate information from the user and then working with that.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"someone" <no****@stopspam.com> wrote in message
news:Oc**************@TK2MSFTNGP03.phx.gbl...

Hi all,
I need to let the users of my windows app select the Sql Server and
database they want to connect to and enter their Sql userid and
password. Is there a control available either in Visual Studio 2005 or
by any third party vendors to do this?

Thanks in advance.

[_DD]

On Wed, 10 May 2006 10:39:34 -0400, "Nicholas Paldino [.NET/C# MVP]"
<mv*@spam.guard.caspershouse.com> wrote:

someone,

There is a dialog that VS.NET uses for SQL Server connections, but it is
a part of VS.NET 2005, and not really for distribution (using it is a little
bit of a hack).

You might be better off just creating a control which gets the
appropriate information from the user and then working with that.

Nicholas (and anyone else who knows about this):

I've been trying to find out more about using that dialog (MSDASC or
adodb if memory serves) from within VS2005. It seemed to work OK with
earlier versions of VS.

I've also found that it's useful for confirming/testing connections
even when the connect string is generated by other means.

I thought that it had been modelled in a new control?