Estoy intentando conectar access con using y web.config pero me da un error y no se como solucionarlos.
web.config
Código:
Código<connectionStrings> <add name="ConnectionStringAccess" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Base-datos.mdb;Persist Security Info=True;Jet OLEDB:Database Password=PASS" providerName="System.Data.OleDb"/> </connectionStrings>
Código:
Using con As New OleDbConnection con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("ConnectionStringAccess") con.Open() Using cmd As New OleDbCommand Dim sql_insert As String sql_insert = "SELECT * FROM Usuarios WHERE usu=@usu AND pass=@pass' and activa = true " cmd.Parameters.Add("@usu", SqlDbType.NVarChar, 250) cmd.Parameters.Add("@pass", SqlDbType.NVarChar, 250) cmd.Parameters("@usu").Value = usu cmd.Parameters("@pass").Value = pass cmd.CommandText = sql_insert cmd.Connection = con Dim odrUsuario As OleDbDataReader = cmd.ExecuteReader() If odrUsuario.Read Then Session("AdminREgistrado") = odrUsuario("Idusuario").ToString Response.Redirect("Pricipal.aspx") Else ' error End If End Using con.Close() End Using