Web Wiz Forums - need help for Sql Server version!!!!

Print Page | Close Window

need help for Sql Server version!!!!

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8389
Printed Date: 07 April 2026 at 5:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: need help for Sql Server version!!!!

Posted By: Zhiming
Subject: need help for Sql Server version!!!!
Date Posted: 28 December 2003 at 10:12pm

I have built a database using "Web_Wiz_Forums_SQL.sql" and imputing data from access database. However, when

I added forum category and new topics, there are some error messages Like this:

Microsoft OLE DB Provider for SQL Server (0x80040E2F)

无法将 NULL 值插入列 'Moved_ID'，表 'wwf.dbo.tblTopic' ；该列不允许空 540;。INSERT 失败。

/wwf/post_message.asp, 第 614 行

I know this is field default value not assigned,I try assign them. but next error message

Came up:

ADODB.Recordset (0x800A0CB3)

当前记录集不支 345;更新。这可能是提供程序的限制A 292;也可能是选定锁定类型的限制。

/wwf/post_message.asp, 第 746 行

This is because of SQL string used "order by" and "top 1"

Replies:

Posted By: WebWiz-Bruce
Date Posted: 29 December 2003 at 7:12am

The file Web_Wiz_Forums_SQL.sql is only there for documentation purposes and should not be used to create the database.

Please follow the install instructions and you will find that there is a file called msSQL_server_setup.asp, you need to run this file to create the SQL server database with all default values and create admin accounts etc.

You also need to enter your SQL server details in the connection file in the admin area, but this is all explained in the documentation.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting