Hi Naveen & Cerberus Thanks for the info. The SQL server is setup for windows authentication. I am trying this method currently just so I can get the connection to the db step done - as mentioned I am very raw to all this and not much of a programmer really (but I am finding it enjoyable - with good help obviously :D)
I will give what you mentioned a try Cerberus. Once I get the connection going I am intending to try to get sql server and other database connection to read the server details of a say sql.ini file (for Sybase) and read the user and password of a login/pword textbox. But I think that's way too advanced for me now. :p Oh and thanks for explanining OP. On May 29, 4:23 am, Cerebrus <[email protected]> wrote: > Not necessarily. The OP is using the connection string type used in > Windows integrated authentication (SQL server Trusted connections). > Such connections do not require a username-password combo. > > This may prove to be the cause of the problem but only if the OP's SQL > server instance is not configured for Windows authentication. There is > nothing wrong with the connection string per se. > > On May 28, 10:45 am, Naveen Kumar <[email protected]> wrote: > > > 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 -- Hide quoted text - > > > - Show quoted text -
