By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,467 Members | 1,500 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,467 IT Pros & Developers. It's quick & easy.

Control for Sql Connection?

P: n/a
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.
May 10 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

May 10 '06 #2

P: n/a
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.


May 10 '06 #3

P: n/a
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.



May 10 '06 #4

P: n/a
_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?

May 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.