Granting read/write permissions on database.
-
Hello guys. I have an update problem that with my logoncheck.asp and when I googled the problem I found out it might be permission problems on the database. Now I have tried to grant permission on the database folder properties to allow read/write, but I still get the same error. Is there another way I can use to maybe grant this permission.Unless there is something else Im doing wrong. The error is Error # -2147467259 Operation must use an updateable query. SQL = UPDATE tbl_employees SET lastlogin = #29-Feb-2008# WHERE employeelogin = 'SIPHOSIBUYANE' Code is : ]]> "" and request.Cookies("shark_password") <> "" and request.form("ccokie") <> "false" then strUserid = request.Cookies("shark_user_id") strPassword = request.Cookies("shark_password") boolFromCookie = True end if end if '----------------------------------------------------- '----------------------------------------------------- 'Level 1 Basic Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Test for Entry of Member ID prior to Running Search '----------------------------------------------------- if (strUserID="") then ' Member ID Entered session("msg") = "
" & dictLanguage("Error_NoUserID") & "
" Response.Redirect "default.asp?opt=1" 'Run Search '----------------------------------------------------- else 'Run Database Lookup sql = sql_GetEmployeesByLogin(strUserID) 'response.write sql & "
" Set rs = Server.CreateObject("ADODB.RecordSet") rs.open sql, conn, 3, 3 end if '----------------------------------------------------- '----------------------------------------------------- 'Level 2 Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Member ID Entered Now Run Search for Record '------------------------------------------- If rs.eof Then 'No Record Found, Bad ID rs.close session("msg") = ""
-
Hello guys. I have an update problem that with my logoncheck.asp and when I googled the problem I found out it might be permission problems on the database. Now I have tried to grant permission on the database folder properties to allow read/write, but I still get the same error. Is there another way I can use to maybe grant this permission.Unless there is something else Im doing wrong. The error is Error # -2147467259 Operation must use an updateable query. SQL = UPDATE tbl_employees SET lastlogin = #29-Feb-2008# WHERE employeelogin = 'SIPHOSIBUYANE' Code is : ]]> "" and request.Cookies("shark_password") <> "" and request.form("ccokie") <> "false" then strUserid = request.Cookies("shark_user_id") strPassword = request.Cookies("shark_password") boolFromCookie = True end if end if '----------------------------------------------------- '----------------------------------------------------- 'Level 1 Basic Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Test for Entry of Member ID prior to Running Search '----------------------------------------------------- if (strUserID="") then ' Member ID Entered session("msg") = "
" & dictLanguage("Error_NoUserID") & "
" Response.Redirect "default.asp?opt=1" 'Run Search '----------------------------------------------------- else 'Run Database Lookup sql = sql_GetEmployeesByLogin(strUserID) 'response.write sql & "
" Set rs = Server.CreateObject("ADODB.RecordSet") rs.open sql, conn, 3, 3 end if '----------------------------------------------------- '----------------------------------------------------- 'Level 2 Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Member ID Entered Now Run Search for Record '------------------------------------------- If rs.eof Then 'No Record Found, Bad ID rs.close session("msg") = ""
Hi I also face the same problem while uploading my first web site, see if your program or webpage executes perfectly in offline mode then there are no problem with the code. This type of error occor mostly due to read write permission of the database, of it could the cause of cookies and caching and in this case try again after removing the cokkies and offline content from your system. With Regards Yogesh Agarwal
-
Hi I also face the same problem while uploading my first web site, see if your program or webpage executes perfectly in offline mode then there are no problem with the code. This type of error occor mostly due to read write permission of the database, of it could the cause of cookies and caching and in this case try again after removing the cokkies and offline content from your system. With Regards Yogesh Agarwal
First thank you for the response, but unfortunately this site has to fun from my hosting company, so I cant test it offline.I have removed all the cached files and deleted the history, and still.Nothing happens. Is it possible that the hosting company could maybe check if their server grants access rights to my database??
kagiso
-
First thank you for the response, but unfortunately this site has to fun from my hosting company, so I cant test it offline.I have removed all the cached files and deleted the history, and still.Nothing happens. Is it possible that the hosting company could maybe check if their server grants access rights to my database??
kagiso
This is possible but did you havn't the control panel details for the site you are developing?? And in your post you are tried to say that you have to write code then upload it on the server to check the effect of your code, you can't even use F5 option to debug for site. and if it is so then only the hosting company will help you. Yogesh
-
This is possible but did you havn't the control panel details for the site you are developing?? And in your post you are tried to say that you have to write code then upload it on the server to check the effect of your code, you can't even use F5 option to debug for site. and if it is so then only the hosting company will help you. Yogesh
I have just contacted the service provider and they tell me that they will escalate the query.The problem is that, when I put in the wrong username and password, I get the right message (Make sure ur username and password are correct), but when I put in the right username and password, I get the error (Make sure the operation uses an updatable query).So it most definitely has to be permission issues. But they promised to call me back. Thanx again.
kagiso
-
Hello guys. I have an update problem that with my logoncheck.asp and when I googled the problem I found out it might be permission problems on the database. Now I have tried to grant permission on the database folder properties to allow read/write, but I still get the same error. Is there another way I can use to maybe grant this permission.Unless there is something else Im doing wrong. The error is Error # -2147467259 Operation must use an updateable query. SQL = UPDATE tbl_employees SET lastlogin = #29-Feb-2008# WHERE employeelogin = 'SIPHOSIBUYANE' Code is : ]]> "" and request.Cookies("shark_password") <> "" and request.form("ccokie") <> "false" then strUserid = request.Cookies("shark_user_id") strPassword = request.Cookies("shark_password") boolFromCookie = True end if end if '----------------------------------------------------- '----------------------------------------------------- 'Level 1 Basic Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Test for Entry of Member ID prior to Running Search '----------------------------------------------------- if (strUserID="") then ' Member ID Entered session("msg") = "
" & dictLanguage("Error_NoUserID") & "
" Response.Redirect "default.asp?opt=1" 'Run Search '----------------------------------------------------- else 'Run Database Lookup sql = sql_GetEmployeesByLogin(strUserID) 'response.write sql & "
" Set rs = Server.CreateObject("ADODB.RecordSet") rs.open sql, conn, 3, 3 end if '----------------------------------------------------- '----------------------------------------------------- 'Level 2 Validation Testing '----------------------------------------------------- '----------------------------------------------------- 'Member ID Entered Now Run Search for Record '------------------------------------------- If rs.eof Then 'No Record Found, Bad ID rs.close session("msg") = ""
It's the user account used for running the ASP.NET code that needs permission to the database file, usually the account IIS_WPG. Check also that the file is not simply write protected.
Despite everything, the person most likely to be fooling you next is yourself.
-
It's the user account used for running the ASP.NET code that needs permission to the database file, usually the account IIS_WPG. Check also that the file is not simply write protected.
Despite everything, the person most likely to be fooling you next is yourself.
-
Well, I checked the database folder and I gave read/write permissions to my account but I still have the problem.Now I dont knw what to do. Im on asp by the way, not asp.net.
kagiso
The same thing applies to ASP; it's not your user account that is used to run the ASP code. Check the settings for the web site in IIS manager to find out what user account is used to run the application.
Despite everything, the person most likely to be fooling you next is yourself.
-
The same thing applies to ASP; it's not your user account that is used to run the ASP code. Check the settings for the web site in IIS manager to find out what user account is used to run the application.
Despite everything, the person most likely to be fooling you next is yourself.
-
Well, IIS is not a problem.The site runs perfectly from IIS, but we just posted the site onto the new ISP FTP folder and its doing this.
kagiso
Files that you upload to the ISP normally isn't writable by the account running the ASP code. An ISP that supports Access usually has a pre-created folder especially for database files, that has the appropriate security settings.
Despite everything, the person most likely to be fooling you next is yourself.
-
Files that you upload to the ISP normally isn't writable by the account running the ASP code. An ISP that supports Access usually has a pre-created folder especially for database files, that has the appropriate security settings.
Despite everything, the person most likely to be fooling you next is yourself.