| Author |
 Topic  |
|
|
drensie
Starting Member
USA
8 Posts |
 Posted - 07 March 2007 : 16:15:47
|
I have uploaded the files to my server, made the path to the database (which I renamed) and it asks me for admin name and PW. After I submit that information, I receive the following 13 errors. I am following the directions, but apparently I have missed something.
Thanks
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_MEMBERS (M_STATUS, M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_LINK1, M_LINK2, M_PHOTO_URL, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_DEFAULT_VIEW, M_LEVEL, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_DATE, M_LASTHEREDATE, M_LASTPOSTDATE, M_TITLE, M_SUBSCRIPTION, M_HIDE_EMAIL, M_RECEIVE_EMAIL, M_LAST_IP, M_IP) VALUES |
Edited by - drensie on 08 March 2007 08:10:37 |
|
|
AnonJr
Moderator
United States
5768 Posts |
|
|
drensie
Starting Member
USA
8 Posts |
Posted - 07 March 2007 : 16:23:36
|
| I appreciate you letting me know. I did not know, however, it was related to access. Probably shows I am an idiot, but I did read through the commmon installation threads for the error numbers, with no success. Thanks for pointing me in the right direction. |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 March 2007 : 16:50:56
|
You're welcome. Don't feel too bad, lots of people ask that question, which is why its in the FAQ.
Best bet when you have an error is to search for the error number and/or text specific to the error like "Operation must use an updateable query". Usually the error (well, the more helpful messages) will give you additional information and a clue or two about related items which can help find an answer.
Like your message: "Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query."
The red part tells us that you are using an Access database, and you are using the ODBC drivers. This sort of stuff doesn't come over night.  I only say this because we all had to start somewhere. Good luck with the forum, and feel free to post any other issues/questions. We really are a friendly bunch. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 08 March 2007 : 09:23:58
|
First drensie continue on with a new post in this thread it makes it easier to follow what is happening so people can help.
Next off this is a read/write issue with your database. You need to set permissions on your folder and also your database itself. Again try searching "Operation must use an updateable query" You will find many topics on this.
hth |
|
|
|
drensie
Starting Member
USA
8 Posts |
Posted - 08 March 2007 : 11:01:56
|
I am sure that the answer to this question has a big circle around it with arrows and stars, but I haven't been able to find it. After I went through all the admin options, I wanted to see what our users will see. The instructions given do not address how to do anything after setting up the email...
I searched "installation", "after setup" and found a string relating to the default.asp page. I tried that and it gave me an error http 404 file not found. I confirmed that the file was in the folder I was pointing it to and then did a forum search for "http 404" I then found the information about turning off friendly messages, which didn't change anything. I am stuck. I would like to view my page, and know how to direct visitors to the forum. |
|
|
|
drensie
Starting Member
USA
8 Posts |
Posted - 08 March 2007 : 11:07:58
|
Ok, no big circles or stars...but i did figure it out. I was entering the default.asp address and it was returning an error. In the address bar it had login?...=default.asp. Just being curious I checked the login file...not there.
Thought it might help others looking for info. |
|
|
| |
Topic |
|
|
|
Topic Locked
