Last post Jan 27, 2009 09:39 PM by jayavarman
Jan 27, 2009 01:17 AM|jayavarman|LINK
Can anyone help me out to get rid of this error from our website? I have checked and changed impersonate account to be "false" (as per advice from tecnical forum) and it didn't work! This error come when website is requesting data from MS Access (pls do
not advice on choosing or changing database). Person who know exactly what to do for this error can reply fast and am ready to provide more details that lead to resolution. Pasted below is the complete error message as seen in the browser,
Hope will get right solution faster!
Unspecified error at System Data
Ms access database error
Jan 27, 2009 02:40 AM|kkprakashmsc|LINK
I am not sure about your error but this error comes because of your connectionstring , the string what u r given is not able to open the database may be database will not have the permission to open , please once check by giving permissions for all users
to tha database
Jan 27, 2009 02:46 AM|Mikesdotnetting|LINK
Can you show the code you are using that causes this error?
Jan 27, 2009 02:49 AM|jayavarman|LINK
Thx Prakash for you quick reply will check on this and reply to you.
Jan 27, 2009 09:35 AM|Mikesdotnetting|LINK
Is it Conn.Open() that causes the error? If so, I would change the location of your database to put it into the App_Data folder within the site folder structure. App_Data is configured not to expose its contents to browsers, so it will be secure there.
You will then need to change your connection string:
con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|MatchMaker.mdb;");
Make sure that you apply MODIFY permissions to the App_Data folder for the ASPNET account on XP Pro, or NETWORK SERVICE account on Win 2k3/8
Some additional points which don't have any bearing on the error:
You are retrieving the entire user table and then looping through it to check to see if there is a match with the ones that have been entered. You would be much better advised using a WHERE clause in the SQL to only select the number of rows where they
match, using SELECT COUNT and parameters:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=75. You are also giving (in my opinion) too much information about what matches and what doesn't in your error messages. This is helpful to bruteforce hackers. They will know that they got one bit
right, and will concentrate on just getting the other.
Jan 27, 2009 09:39 PM|jayavarman|LINK