Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sonamsaxena
Starting Member

1 Posts

Posted - 10 October 2004 :  01:58:28  Show Profile
Can someone explain and mail me on sonam@saxena.com why this error is showing up?


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(1, 'admin', 'admin', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20041009135937', '20041009135437', '20041009135937', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_FORUM(CAT_ID, F_STATUS, F_MAIL, F_SUBJECT, F_URL, F_DESCRIPTION, F_TOPICS, F_COUNT, F_LAST_POST, F_PASSWORD_NEW, F_PRIVATEFORUMS, F_TYPE, F_IP, F_LAST_POST_AUTHOR, F_LAST_POST_TOPIC_ID, F_LAST_POST_REPLY_ID) VALUES(1, 1, 0, 'Testing Forums', '', 'This forum gives you a chance to become more familiar with how this product responds to different features and keeps testing in one place instead of posting tests all over. Happy Posting! ', 1, 1, '20041009135937', '', 0, 0, '000.000.000.000', 1, 1, 0)
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_TOPICS (CAT_ID, FORUM_ID, T_STATUS, T_MAIL, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_ARCHIVE_FLAG) VALUES(1, 1, 1, 0, 'Welcome to Snitz Forums 2000', 'Thank you for downloading Snitz Forums 2000. We hope you enjoy this great tool to support your organization! Many thanks go out to John Penfold <asp@asp-dev.com> and Tim Teal <tteal@tealnet.com> for the original source code and to all the people of Snitz Forums 2000 at http://forum.snitz.com for continued support of this product.', 1, 0, 0, 0, '20041009135937', '20041009135937', 0, '000.000.000.000', 1, 0, 1)
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_TOTALS (COUNT_ID, P_COUNT, T_COUNT, U_COUNT) VALUES(1,1,1,1)
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES (' ****',' ****')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('*****','*****')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('All Categories you have access to','All Categories you have access to')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('Default Categories','Default Categories')
Error: -2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)

The Installation has NOT been completed !

Classicmotorcycling
Development Team Leader

Australia
2085 Posts

Posted - 10 October 2004 :  04:33:15  Show Profile
Very easy. It means that your database can not be updated. You need to have write permission on you database and this is why it is not working. If you did a search for Operation must use an updateable query in the search page you would find it.

There is also help at: Dougs Code

Cheers,

David Greening
Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 10 October 2004 :  13:33:22  Show Profile
Also, don't ask for help via email. These forums are the tools that should be used for help, otherwise others wouldn't benefit from the questions and answers (if they would just use the search page every now and then).
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2085 Posts

Posted - 11 October 2004 :  04:40:41  Show Profile
What there is a search page at this site? You must be kidding us all.. [big giant grin][/big giant grin]
quote:
Originally posted by Roland

(if they would just use the search page every now and then)
I know the search page makes it easy for me to find stuff.


Cheers,

David Greening
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07