connect asp.netwith mssql 2008

March 3, 2009 at 22:12:04
Specs: Windows XP
hi,i want to create a login page using with vb in microsoft visual web developer 2008 and connect it to microsoft sql server 2008 but it's not successful and there's an error says :

The 'SQLNCLI10Server=LOPEIHWADatabase=FYP' provider is not registered on the local machine.

the stack trace is:

[InvalidOperationException: The 'SQLNCLI10Server=LOPEIHWADatabase=FYP' provider is not registered on the local machine.]
System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) +962260
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +124
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4861516
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.OleDb.OleDbConnection.Open() +40
ASP.login_aspx.btnsignin_Click(Object sender, EventArgs e) +64
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

can anyone help me with this?
thanks a lot.

See More: connect asp.netwith mssql 2008

Report •

March 4, 2009 at 07:25:05
Your connection string is broken; it appears to be missing the semicolons.

Report •

March 4, 2009 at 12:06:48
after i put the semicolons another error came out.
Invalid authorization specification
Invalid connection string attribute

Is it something wrong with my code?I'm a beginner in
Dim DSLogin As New DataSet
Line 11: DBConn = New OleDbConnection("Provider=SQLOLEDB;" & "DataSource=LOPEIHWA;" & "Integrated(Security=SSPI);" & "Initial Catalog=FYP;")
Line 12: DBConn.Open()
Line 13: DBCommand = New OleDbDataAdapter("Select UserID From Security" & "UserID = '" & TxtUserName.Text & "' and Password ='" & TxtPassword.Text & "'", DBConn)
Line 14: DBCommand.Fill(DSLogin, "UserInfo")

Report •

March 4, 2009 at 13:09:27
Your connection string is still broken. Pick the most relevant, and modify accordingly.

Report •

Related Solutions

March 11, 2009 at 02:43:01
I still can't connect to it.i dunno wat's wrong with it.can u basically tell me how to create a login page with input to text boxes and see whether they are valid users in the database or not?really really thanks for ur help.

Report •

Ask Question