As going
back and do the convert again, but this time in Access 2007 is not an option, i
found a solution, work-around.
Page:
http://xxxx.xxxxxx.xxx/register.asp?FID=0
Happens: When you only enter the required fields in the registration
page.
Error:
Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_register_USR
File Name:- register.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
The INSERT statement conflicted with the CHECK constraint
"SSMA_CC$tblAuthor$Gender$disallow_zero_length". The conflict occurred
in database "terrangb", table "dbo.tblAuthor", column 'Gender'.
My solution:
Change line 1673 in the Register.asp file so that “Private” is always selected/checked
if you don’t select male or female. Solved my problem with getting the Zero
error.
Page:
http://xxxx.xxxxxx.xxx/admin_web_wiz_forums_configuration.asp
Happens: When im trying to change any, or some of the fields.
Error:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
The UPDATE statement conflicted with the CHECK constraint
"SSMA_CC$tblConfiguration$NewsPad_URL$disallow_zero_length". The
conflict occurred in database "terrangb", table
"dbo.tblConfiguration", column 'NewsPad_URL'.
/forum/admin_web_wiz_forums_configuration.asp, line 141
My solution:
The easiest way around this problem is to click “checked”, that you
have the NewsPad installed, that cancelled the Zero error in SQL.
Topic Options
Post Options
Thanks(0)
... I converted from Access to MSQL with the Microsoft SQL Server: SQL Server 2005 Migration tool
