S
Shico
Hi all!
Here is my problem:
An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll
Additional information: No error information available:
DB_SEC_E_AUTH_FAILED(0x80040E4D).
Error rises at Runtime in the following C# code:
string connectionString =
"provider=Microsoft.JET.OLEDB.4.0; User
Id=admin;Password=;"+"data source =
"+DataBaseFileName;
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT
* FROM Authors",connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet,"Authors");
//<-----Runtime ERROR!!!
DataTable dataTable = dataSet.Tables[0];
DataRow dataRow = dataTable.NewRow();
dataRow["UID"]=1;
dataRow["First_Name"]=author.FirstName;
dataRow["Middle_Name"]=author.MiddleName;
dataRow["Last_Name"]=author.LastName;
dataRow["AcademicDegree"]=author.AcademicDegree;
dataTable.Rows.Add(dataRow);
dataAdapter.Update(dataSet,"Authors");
dataSet.AcceptChanges();
Any suggestions?
Here is my problem:
An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll
Additional information: No error information available:
DB_SEC_E_AUTH_FAILED(0x80040E4D).
Error rises at Runtime in the following C# code:
string connectionString =
"provider=Microsoft.JET.OLEDB.4.0; User
Id=admin;Password=;"+"data source =
"+DataBaseFileName;
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT
* FROM Authors",connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet,"Authors");
//<-----Runtime ERROR!!!
DataTable dataTable = dataSet.Tables[0];
DataRow dataRow = dataTable.NewRow();
dataRow["UID"]=1;
dataRow["First_Name"]=author.FirstName;
dataRow["Middle_Name"]=author.MiddleName;
dataRow["Last_Name"]=author.LastName;
dataRow["AcademicDegree"]=author.AcademicDegree;
dataTable.Rows.Add(dataRow);
dataAdapter.Update(dataSet,"Authors");
dataSet.AcceptChanges();
Any suggestions?