Hi, U must Know there are few things When U are connecting to SqlServer as DataBase support.
when u are using sqlclient in VS 2005 then four parameter are Required. - Server - mean U have to provide Server name in case of ur own computer is localhost then put . or computername. - initial catalog - is Database name. like pubs or northwind i sql server. - UID - is Username for sql server connectivity. - PWD - is Password for sql server connectivity. then ur connection string is look like "server=.;initial catalog=dbname;UID=username;PWD=password;" Try this. On 5/27/09, The_Fruitman <[email protected]> wrote: > > Here's an example of the flow that you need to do. NOTE: This was > written very quickly and there is room for refactoring and cleaning up > the functions as well as adding error handling but the basic principal > is what I'm trying to get across. For this example I'm going to throw > the results into a dataset. > > Private Sub login_button_Click(ByVal sender As System.Object, > ByVal e As System.EventArgs) Handles login_button.Click > > Dim sqlconn As SqlConnection > Dim sqldata As SqlDataAdapter > Dim dsresults As New DataSet > Dim strsql As String = "Select * From table" > > sqlconn = New SqlConnection("PUT YOUR CONNECTION STRING HERE") > sqldata = New SqlDataAdapter(strsql, sqlconn) > sqlconn.Open() > sqldata.Fill(dsresults) > sqlconn.Close() > > End Sub > > > > On May 26, 5:56 pm, jt_2009 <[email protected]> wrote: > > HI everyone, > > > > Thank you for all the info and the welcome. Couple of things: > > > > 1. What is OP? > > 2. I understand that the logic/concept is the same. However where I am > > stuck is in the application of this concept. > > > > As you can see from the above I've since attempted to do the following > > when the button is clicked: > > a. open a connection to sybase (using the connection string from the > > connection string website) > > b. I've also imported System.Data.Oledb > > > > However this is still not working. I have tried connecting to a MSSQL > > server instead (just easier for me as I am learning). I can add a data > > source in VS2005 BUT I still have no idea on how to get the connection > > to be established when the button is clicked. I must definitely be > > missing something. > > > > So if you would be able to assist me in this particular area that > > would be great. Even helping me get the MSSQL connectivity working > > upon clicking the login buttong would be a good start - I can then > > apply the same thing to connect to say sybase. > > > > At this stage though I need someone to take my hand and walk me > > through (unfortunately). Once again I understand the concept is the > > same no matter what db/type of app but practically speaking I can't > > get it working. > > > > Thanks again for your time. > > > > On May 22, 5:32 pm, Cerebrus <[email protected]> wrote: > > > > > > > > > Correct, but the OP is referring to Login suite of controls which are > > > exclusively ASP.NET. Clearly, it was a lapse on the part of the OP not > > > to mention the type of application at the outset. > > > > > BTW, Welcome to the Group! ;-) > > > > > On May 22, 1:33 am, Neo <[email protected]> wrote: > > > > > > dude, > > > > even if u are developing a window app (.exe), the logic behind the > > > > authentication remains the same, > > > > i.e. : > > > > if the user name and password exists in db, > > > > load them in your app, using ADO.NET and compare it with the user > > > > input. simple :) > > > > > > On May 20, 6:35 am, jt_2009 <[email protected]> wrote: > > > > > > > Hi Keidrick > > > > > > > Thank you for your reply, but I think the login control is for web > > > > > based applications? I am building an exe - please correct me if I > am > > > > > wrong. > > > > > > > On May 20, 12:04 am, KeidrickP <[email protected]> wrote: > > > > > > > > I would also recommend using the .net login controls. > > > > > > Instead of just regular text boxes. > > > > > > > >http://msdn.microsoft.com/en-us/library/ms178329.aspx > > > > > > > > On Tue, May 19, 2009 at 8:50 AM, The_Fruitman > > > > > > > > <[email protected]> wrote: > > > > > > > > > The programming logic remains the same no matter what database > you're > > > > > > > connecting to. > > > > > > > > > > http://www.google.com/search?hl=en&q=connect+to+database+in+vb.net&aq... > > > > > > > > > The connection string can be found here: > > > > > > >http://connectionstrings.com/sybase-adaptive > > > > > > > > > On May 18, 11:04 pm, jt_2009 <[email protected]> wrote: > > > > > > >> Hi I am new to vb.net. > > > > > > > > >> I am creating a login form and require the form to validate > the > > > > > > >> username and password from a sybase ASE database. I was > wondering if > > > > > > >> anyone here knows how to do that? > > > > > > > > >> Thank you . I am doing this using VS 2005. > > > > > > > > -- > > > > > > Keidrick Pettaway > > > > > > > >http://kpettaway.com-Hidequotedtext - > > > > > > > - Show quoted text -- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text - >
