Connecting to Database Issue

Question

Hello everyone I'm new here hope you can help me out guys. I am doing a web application in VB.Net and I'm trying to connect to MSSQL Server through OLEDB and SQL Connection. But every time I run the program the message always appear Log in failed in user(Computername). I tried the OLEDB and SQL Connection in Windows form and it worked unliked what happened in my web application. Hope I can receive a reply ASAP.. Thanks in advance ! ! ! ^_^

Pradip Kishore · Answer

u try the following code for ur problem(i m telling u using sql server 2000) write the following in the form load event: Dim strConn As String = uid=sa;pwd=*;database=**;server=*** Dim dbConn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(strConn) dbConn.Open() * password of sql server 2000 ** your database name *** server name of the sql server hope this will solve ur problm