ASP.net With Access Issue

[78mike78]

Thread information:
Thread ID: 8
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at DataLayer.DataBase.OpenDatabase() in C:\brendan\Brandon\brendan\DataLayer\DataBase\Common.vb:line 84
at BusinessLayer.Common.ConnectDB(Object obDB) in C:\brendan\Brandon\brendan\BusinessLayer\Common.vb:line 69

i get this error in the event logs and our site gets an asp error..it happens between every 15min-25min.
Not sure what is causing it..anyone any ideas would be apriciated.
Tnx

 

[jmeckley]

what is the acutal error messsage and exception type? this will give you the most information.

that said the error is in the Common.vb file at line 69 & 84.
Access must read/write lock files when it is accessed. chances are that is the problem.

any db is better than access for a multi-user system. your system is since it's a web app. check out either sqllite, mysql, sql server express, postgresql. sql server express will be the easiest to implement. none of these options cost money.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[78mike78]

When i restart IIS it works again. For now just keep the webiste up, i m using a batch file to restart iis every 15 minutes. I just stopped the task, so that i can get you the full info from the error.
We are planning on converting over to sql in a month.
Thanks for trying to help, i should be posting the reply wihtin the next 15 minutes when it errors out

 

[78mike78]

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: Unspecified error]
DataLayer.DataBase.OpenDatabase() in C:\brendan\Brandon\brendan\DataLayer\DataBase\Common.vb:84
BusinessLayer.Common.ConnectDB(Object obDB) in C:\brendan\Brandon\brendan\BusinessLayer\Common.vb:69

[Exception: Connection Error: Unspecified error]
BusinessLayer.Common.ConnectDB(Object obDB) in C:\brendan\Brandon\brendan\BusinessLayer\Common.vb:75
ASP.global_asax.Session_Start(Object sender, EventArgs e) +55
System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +2221711
System.Web.SessionState.SessionStateModule.CompleteAcquireState() +159
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +518
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +90
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +161

 

[jmeckley]

definitely an issue with opening connection to access. google "Exception: Connection Error: Unspecified error" and see how others are handling this issue.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[78mike78]

Thanks, i googled it and foudn some permision issues, but all of my permisions are set correct. The reason why its such a mistry, is becaseu it works for 15-60minutes then it crashes. if you are already on the page you can brows all the without any problems, but new users get the error on the hope page

 

[jmeckley]

access isn't really meant to run a high use website. it's best for 5 - 10 user at a given time.

make sure you are closing/disposing your db connections. if your not this will help. if you are then you need to migrate off of access asap.

Jason Meckley
Programmer
Specialty Bakers, Inc.