User-1376164067 posted
Hello Everyone,
I have some light experience with Visual Studio and C# and I am experiencing a problem with my Access Database Connection and the Web Application. When I start debugging my site I get this error OleDbException (0x80004005): Could not find file (the
path to my database file).
Here is my class file code:
// This function gets information from the tblStaff
public static dsStaffSearch GetStaff(string Database)
{
// declaration of variable for the dataset, connection, and data adapter
dsStaffSearch DS;
OleDbConnection sqlConn;
OleDbDataAdapter sqlDA;
// Creates a new connection
sqlConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Database);
// Gathers information from the tblStaff
sqlDA = new OleDbDataAdapter("select * from tblStaff where StaffExperienec = 3", sqlConn);
// Creates a new dataset
DS = new dsStaffSearch();
// Fills the object with information from tblStaff
sqlDA.Fill(DS.tblStaff);
// Passes data through
return DS;
}
// This function gets information from the tblStaff
public static dsStaffSearch GetStaff(string Database)
{
// declaration of variable for the dataset, connection, and data adapter
dsStaffSearch DS;
OleDbConnection sqlConn;
OleDbDataAdapter sqlDA;
// Creates a new connection
sqlConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Database);
// Gathers information from the tblStaff
sqlDA = new OleDbDataAdapter("select * from tblStaff where StaffExperienec = 3", sqlConn);
// Creates a new dataset
DS = new dsStaffSearch();
// Fills the object with information from tblStaff
sqlDA.Fill(DS.tblStaff);
// Passes data through
return DS;
}
and the code behind file:
// Creates Staff Search dataset variable
dsStaffSearch dsSearch = new dsStaffSearch();
// Calls Get Staff function to dsSearch
dsSearch = clsDataLayer.GetStaff(Server.MapPath("StaffingSystem_DB.mdb"));
// Set the DataGrid to the DataSource based on the table
grdStaff.DataSource = dsSearch.Tables["tblStaff"];
// Bind the DataGrid
grdStaff.DataBind();
when the error occurs it points to this specific line: sqlDA.Fill(DS.tblStaff);
From what I have read people are saying I dont have permissions to the db but this is on my personal machine and I have verified that I have read/write permissions. If anyone could provide me some assistance it would be greatly appreciated!
Also here is the full error that is displayed in my web browser.
Description: An unhandled exception occurred during the execution of the current
web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Could not find file 'C:\Users\Roc\Documents\Visual Studio 2010\Projects\StaffingServiceWebSite\StaffingServiceWebSite\StaffingSystem_DB.mdb'.
Source Error:
Line 32:
Line 33: // Fills the object with information from tblStaff
Line 34: sqlDA.Fill(DS.tblStaff);
Line 35:
Line 36: // Passes data through
|
Source File: C:\Users\Roc\Documents\Visual Studio 2010\Projects\StaffingServiceWebSite\StaffingServiceWebSite\clsDataLayer.cs
Line: 34
Stack Trace:
[OleDbException (0x80004005): Could not find file 'C:\Users\Roc\Documents\Visual Studio 2010\Projects\StaffingServiceWebSite\StaffingServiceWebSite\StaffingSystem_DB.mdb'.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +337
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +31
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +76
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.OleDb.OleDbConnection.Open() +43
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +123
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +166
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
StaffingServiceWebSite.clsDataLayer.GetStaff(String Database) in C:\Users\Roc\Documents\Visual Studio 2010\Projects\StaffingServiceWebSite\StaffingServiceWebSite\clsDataLayer.cs:34
StaffingServiceWebSite.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Users\Roc\Documents\Visual Studio 2010\Projects\StaffingServiceWebSite\StaffingServiceWebSite\WebForm1.aspx.cs:22
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
|
