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: Database: MS SQL Server
 Converted from access to SQLServer - issues
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

johnnysqueeb
Starting Member

USA
4 Posts

Posted - 11 October 2006 :  22:49:59  Show Profile  Visit johnnysqueeb's Homepage  Send johnnysqueeb an AOL message  Send johnnysqueeb an ICQ Message
I converted from Access to SQL Server 2000 recently, followed all directions on the Snitz forums in setting up the DTS. Had 0 issues and all went well, but now users cannot edit posts.

This is the error when a user attempts to edit the post. I do not see it as I am the Admin for the forum:
Note: Only the poster of this message, and the Moderator can edit the message.
Format:

Forum: Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/forum/post.asp, line 642


Anyone have any ideas what could be causing this issue? Seems like it it is not recognizing the person who created the post as the person trying to edit it - based on the data return in rs. Could the column on the table be set to a varchar and it needs to be an integer? Shooting blind on this one as it may not be a database issue, just not sure what direction to start troubleshooting this one.

The forum is located at:
http://jsfl.j-s-o-l.com/forum/default.asp

Thanks in advance to anyone who may be able to help on this one.

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 12 October 2006 :  04:25:09  Show Profile  Visit HuwR's Homepage
see here http://forum.snitz.com/forum/topic.asp?TOPIC_ID=62792
Go to Top of Page

johnnysqueeb
Starting Member

USA
4 Posts

Posted - 15 October 2006 :  23:51:54  Show Profile  Visit johnnysqueeb's Homepage  Send johnnysqueeb an AOL message  Send johnnysqueeb an ICQ Message
Excellent, issue is resolved, thanks alot, greatly appreciated!!
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.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07