I am trying to get the Access version of the PSK to work on GoDaddy. Everything works fine on my local machine, but when I upload to GoDaddy and try to run, I get the following error:
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: Operation must use an updateable query.
Source Error:
Line 211: createCommand.Parameters.Add(new OleDbParameter("@LastActivityDate", new DateTime(lastActivityDate.Year, lastActivityDate.Month, lastActivityDate.Day, lastActivityDate.Hour, lastActivityDate.Minute, lastActivityDate.Second))); Line 212: Line 213: if (createCommand.ExecuteNonQuery() != 0) { Line 214: lookupResult = lookupCommand.ExecuteScalar(); Line 215: if ((lookupResult != null) && (lookupResult is int)) {
Either your access database file is readonly or you have not given full control to the account that the ASP.NET worker thread is running under (usually ASPNET or Network Service) for the folder your db is in. You should be able to do this using your providers
control panel.
Hi, Thanks for the help. I don't see anywhere on the GoDaddy cpntrol panel where I can change permissions for a directory, plus I was under the impression that the APP_Data folder was automatically Read/Write permissable. Anyway, I moved the database to
the folder that GoDaddy sets up for Access databases, access_db, and changed the web.config file to point to this. I am now getting the following error:
Exception Details: System.Exception: AccessFile is not valid: d:\hosting\adkhkr1\Provider=Microsoft.Jet.OLEDB.4.0;Data Source=~\access_db\ASPNetDB.mdb
Source Error:
Line 241: conn.Open(); Line 242: } catch { Line 243: throw new Exception("AccessFile is not valid: "+fileName); Line 244: } Line 245: finally {
None
0 Points
22 Posts
PSK on GoDaddy with an Access Database setup question.
Apr 08, 2007 06:16 PM|adkboards|LINK
I am trying to get the Access version of the PSK to work on GoDaddy. Everything works fine on my local machine, but when I upload to GoDaddy and try to run, I get the following error:
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: Operation must use an updateable query.
Source Error:
Line 211: createCommand.Parameters.Add(new OleDbParameter("@LastActivityDate", new DateTime(lastActivityDate.Year, lastActivityDate.Month, lastActivityDate.Day, lastActivityDate.Hour, lastActivityDate.Minute, lastActivityDate.Second)));Line 212:
Line 213: if (createCommand.ExecuteNonQuery() != 0) {
Line 214: lookupResult = lookupCommand.ExecuteScalar();
Line 215: if ((lookupResult != null) && (lookupResult is int)) {
Source File: d:\**************\App_Code\AccessConnectionHelper.cs Line: 213
Does anyone know what this means, I am just a newbie at this stuff, thank you.
Star
7692 Points
1845 Posts
Re: PSK on GoDaddy with an Access Database setup question.
Apr 08, 2007 08:10 PM|whighfield|LINK
Either your access database file is readonly or you have not given full control to the account that the ASP.NET worker thread is running under (usually ASPNET or Network Service) for the folder your db is in. You should be able to do this using your providers control panel.
Hope this helps
None
0 Points
22 Posts
Re: PSK on GoDaddy with an Access Database setup question.
Apr 09, 2007 08:35 AM|adkboards|LINK
Hi, Thanks for the help. I don't see anywhere on the GoDaddy cpntrol panel where I can change permissions for a directory, plus I was under the impression that the APP_Data folder was automatically Read/Write permissable. Anyway, I moved the database to the folder that GoDaddy sets up for Access databases, access_db, and changed the web.config file to point to this. I am now getting the following error:
Exception Details: System.Exception: AccessFile is not valid: d:\hosting\adkhkr1\Provider=Microsoft.Jet.OLEDB.4.0;Data Source=~\access_db\ASPNetDB.mdb
Source Error:
Source File: d:\hosting\adkhkr1\App_Code\AccessConnectionHelper.cs Line: 243
Stack Trace:
The Access file is not read-only, thanks again for your help.
None
0 Points
22 Posts
Re: PSK on GoDaddy with an Access Database setup question.
Apr 09, 2007 11:33 AM|adkboards|LINK