Control for Sql Connection?

10 May 2006 2:24 PM

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.

10 May 2006 2:39 PM

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

Show quoteHide quote

"someone" <nospam@stopspam.com> wrote in message
news:OcjU11DdGHA.1856@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.
>

10 May 2006 3:28 PM

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?

Show quoteHide quote

"Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> wrote in
message news:etfbh9DdGHA.636@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]
>          - mvp@spam.guard.caspershouse.com
>
> "someone" <nospam@stopspam.com> wrote in message
> news:OcjU11DdGHA.1856@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.
>>
>
>

10 May 2006 4:01 PM

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

Show quoteHide quote

"someone" <nospam@stopspam.com> wrote in message
news:uW4oPZEdGHA.1792@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]" <mvp@spam.guard.caspershouse.com> wrote
> in message news:etfbh9DdGHA.636@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]
>>          - mvp@spam.guard.caspershouse.com
>>
>> "someone" <nospam@stopspam.com> wrote in message
>> news:OcjU11DdGHA.1856@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.
>>>
>>
>>
>
>

15 May 2006 3:11 AM

_DD

On Wed, 10 May 2006 10:39:34 -0400, "Nicholas Paldino [.NET/C# MVP]"
<mvp@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?