473,323 Members | 1,547 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Control for Sql Connection?

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
4 1008
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
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
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
_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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Björn Marthen | last post by:
Hello, I wrote two custom controls. The first control (dbconnection) inherits from "System.ComponentModel.Component" and has the properties for the database connection. The second control...
0
by: Chris Schremser | last post by:
I have a question regarding embedded controls in IE. We are looking to replace a small VB ActiveX control with something written in C#. We have written the control and it instantiates correctly...
3
by: Thierry Lefevre | last post by:
Hi all, I have written a control in c# which heard an UDP port on a network broadcast address. In the other hand, a server send periodically (every 500ms) some messages to this broadcast...
0
by: Wysiwyg | last post by:
I'm writing an application in C# with Visual Studio 2003. I want to put a sql server connection dialog on a form used to configure an application. This is for setting up the connection and saving...
7
by: mfeingold | last post by:
I am working on a system, which among other things includes a server and a ..net control sitting in an html page and connected to the server. I ran into a couple of problems, you guys might have...
4
by: D Witherspoon | last post by:
How do I add a dataset control to a ASP.NET 2005 app? It was easy in 2003. I would just drag a control onto the form. In an ASP.NET web project VS.2005 project the control doesnt seem to exist....
0
by: postings | last post by:
Hi This is (more or less) a repost from last week. Sorry I'm pretty despirate for a soltution and hope I get better luck this time! Would you mind looking at this? - Thanks.... The code below...
7
by: Jason | last post by:
I have created a user control, MyControl.ascx, that has a text box and a button. The button updates a table in SQL with the text in the textbox. Now, I include that control in a page...
2
by: Kiran | last post by:
Hello all, I am using a tree to display stuff, and it is constantly updated, but what I have noticed is in the lowest level, there is clearly noticable cutoff of the text I place there. The cutoff...
0
by: Miguel | last post by:
Hello Everybody, I am trying to display a chart in my asp page. The problem is that I need to connect to a Database and if you see the HTML code you can see the connection String (User and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.