Help with Error on SQL DB when running
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=9037
Printed Date: 07 April 2026 at 3:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Help with Error on SQL DB when running
Posted By: nguyencno5
Subject: Help with Error on SQL DB when running
Date Posted: 19 January 2004 at 12:23pm
|
Can you guys help me on this.. I'm getting the error below when running WWForum (registration new user). Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Author_ID', table 'mySQL_database_name.dbo.tblAuthor'; column does not allow nulls. INSERT fails. Thanks in advance! |
Replies:
Posted By: Semikolon
Date Posted: 19 January 2004 at 3:02pm
| this means that you try to insert an empty value, but the field in the database doesnt support it.. make sure you have filled in all the required fields in the registration form.. |
Posted By: nguyencno5
Date Posted: 19 January 2004 at 5:35pm
|
I had no problem with Access DB before. I'm not sure how this
happen. I just recently upsized my Access DB to Ms SqL. can you think of any thing that could cause this? Thanks! |
Posted By: Semikolon
Date Posted: 20 January 2004 at 12:54pm
|
maybe.. have you changed any files? other than the database? |
Posted By: Jesper
Date Posted: 20 January 2004 at 2:18pm
|
I have the same problem... upgraded from Access to MSSQL (at least I'm trying to
|
)Posted By: Semikolon
Date Posted: 20 January 2004 at 2:24pm
|
if you pay an ISP for hosting and they support ms sql, they will probabl help yopu with upgrading.. some do it for free, as access is a pain in the ass for the hosts, and some require an additional fee(it shouldnt be very much).. this is absolutely the best way to move to ms sql if you have data in your access database that you want to keep.. |
Posted By: Jesper
Date Posted: 20 January 2004 at 2:36pm
|
ok... I've figured it out. There's a bug in the creation of tables on the MSSQL server on Borg's behalf. The Author_ID column in the tblAuthors table is set to 'integer'. In the Access version this is 'autonumber'. I set the Identity property of the column to 'Yes', Identity seed to 1 and finally Identity increment to 1. That fixed that problem |
Posted By: Semikolon
Date Posted: 20 January 2004 at 2:42pm
| in access it should be integer (or int), but it should also be Identity Yes, key Yes, id seed 1 and id increment 1 |
Posted By: nguyencno5
Date Posted: 20 January 2004 at 7:02pm
|
thank you all.. it did fix my problem.. My forum is running on SQL now.. Thanksssssss! |
Posted By: WebWiz-Bruce
Date Posted: 20 January 2004 at 7:12pm
There isn't a bug in my SQL server creation file, see the following line from the file sets the Author_ID field to interger; Indentity, incrementing by 1 and not allowing nulls:- strSQL = strSQL & "[Author_ID] [int] IDENTITY (1, 1) PRIMARY KEY CLUSTERED NOT NULL ," ------------- 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 |
Jesper wrote:Posted By: Jesper
Date Posted: 21 January 2004 at 2:14am
Wierd, I'm puzzled why the table we created without setting the identity property 
|