Web Wiz Support and Community Forums : SQL server problem... https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 03:34:33 +0000 Tue, 17 Feb 2004 15:27:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9901 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL server problem... : What about all the posts and members?...]]> https://forums.webwiz.net/sql-server-problem_topic9901_post53371.html#53371 Author: CeeWulf
Subject: 9901
Posted: 17 February 2004 at 3:27pm

What about all the posts and members? Should I dump the database, thenuse the forum to re-create all the tables, then import the Accessdatabase?]]> Tue, 17 Feb 2004 15:27:38 +0000 https://forums.webwiz.net/sql-server-problem_topic9901_post53371.html#53371 <![CDATA[SQL server problem... : try reinstall and replace all...]]> https://forums.webwiz.net/sql-server-problem_topic9901_post53363.html#53363 Author: Semikolon
Subject: 9901
Posted: 17 February 2004 at 3:09pm

try reinstall and replace all the forum files..

the first one looks like its not set to autonumber, the second one looks like a corrupt file or permission problems on the SQL Server

]]> Tue, 17 Feb 2004 15:09:06 +0000 https://forums.webwiz.net/sql-server-problem_topic9901_post53363.html#53363 <![CDATA[SQL server problem... : This is a problem with the database. The...]]> https://forums.webwiz.net/sql-server-problem_topic9901_post53361.html#53361 Author: WebWiz-Bruce
Subject: 9901
Posted: 17 February 2004 at 3:06pm

This is a problem with the database.

The database has not been created properly. Delete the database and run the msSQL_setup.asp file again.
]]> Tue, 17 Feb 2004 15:06:25 +0000 https://forums.webwiz.net/sql-server-problem_topic9901_post53361.html#53361 <![CDATA[SQL server problem... : I recently upgraded to 7.7a,...]]> https://forums.webwiz.net/sql-server-problem_topic9901_post53359.html#53359 Author: CeeWulf
Subject: 9901
Posted: 17 February 2004 at 2:50pm

I recently upgraded to 7.7a, and also switched from an Access database to MS SQL.

However, I discovered that I cannot post new comments to the board, norcan anyone new register with the board. However, for some reason, I canedit posts.

This is the error message I'm getting when I try to create a new member:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column'Author_ID', table 'sherida_forums.dbo.tblAuthor'; column does notallow nulls. INSERT fails.

/starwars/forum/register.asp, line 954

This is the message I get when I try to post something:

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/starwars/forum/post_message.asp, line 746

I've tried talking to my provider, butthey haven't been able to help. I don't know if this is a problem withthe database or the forum code, but I am in desperate need of help.




Edited by CeeWulf]]> Tue, 17 Feb 2004 14:50:59 +0000 https://forums.webwiz.net/sql-server-problem_topic9901_post53359.html#53359