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]]

Re: Control for Sql Connection?

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]
- mvp@spam.guard. caspershouse.co m

"someone" <nospam@stopspa m.com> wrote in message
news:OcjU11DdGH A.1856@TK2MSFTN GP03.phx.gbl...[color=blue]
> 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.
>[/color]

[someone]

Re: Control for Sql Connection?

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]" <mvp@spam.guard .caspershouse.c om> wrote in
message news:etfbh9DdGH A.636@TK2MSFTNG P05.phx.gbl...[color=blue]
> 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]
> - mvp@spam.guard. caspershouse.co m
>
> "someone" <nospam@stopspa m.com> wrote in message
> news:OcjU11DdGH A.1856@TK2MSFTN GP03.phx.gbl...[color=green]
>> 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.
>>[/color]
>
>[/color]

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

Re: Control for Sql Connection?

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]
- mvp@spam.guard. caspershouse.co m

"someone" <nospam@stopspa m.com> wrote in message
news:uW4oPZEdGH A.1792@TK2MSFTN GP03.phx.gbl...[color=blue]
> 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]" <mvp@spam.guard .caspershouse.c om> wrote
> in message news:etfbh9DdGH A.636@TK2MSFTNG P05.phx.gbl...[color=green]
>> 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]
>> - mvp@spam.guard. caspershouse.co m
>>
>> "someone" <nospam@stopspa m.com> wrote in message
>> news:OcjU11DdGH A.1856@TK2MSFTN GP03.phx.gbl...[color=darkred]
>>> 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.
>>>[/color]
>>
>>[/color]
>
>[/color]

[_DD]

Re: Control for Sql Connection?

On Wed, 10 May 2006 10:39:34 -0400, "Nicholas Paldino [.NET/C# MVP]"
<mvp@spam.guard .caspershouse.c om> wrote:
[color=blue]
>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.[/color]

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?