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
 iget error when i upgraded
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ez4arab
Junior Member

479 Posts

Posted - 29 June 2002 :  12:26:09  Show Profile  Visit Ez4arab's Homepage
i have up grad from accece to mssql. i have import tables from accece to mssql i get these error

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

Cannot insert the value NULL into column 'MEMBER_ID', table 'ez4aljish.ez4aljish.FORUM_MEMBERS'; column does not allow nulls. INSERT fails.

/forum/register.asp, line 202

+++++++++++++++++++++++++++++++++++++++++++++

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

Cannot insert the value NULL into column 'MEMBER_ID', table 'ez4aljish.ez4aljish.FORUM_MEMBERS'; column does not allow nulls. INSERT fails.

/forum/register.asp, line 536

+++++++++++++++++++++++++++++++++++++++++++++

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

Invalid column name 'M_RECMAIL'.

/forum/pop_profile.asp, line 790

+++++++++++++++++++++++++++++++++++++++++++++

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

Cannot insert the value NULL into column 'FORUM_ID', table 'ez4aljish.ez4aljish.FORUM_FORUM'; column does not allow nulls. INSERT fails.

/forum/post_info.asp, line 1114
+++++++++++++++++++++++++++++++++++++++++++++

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

Cannot insert the value NULL into column 'ID', table 'ez4aljish.ez4aljish.FORUM_CONFIG_NEW'; column does not allow nulls. INSERT fails.

/forum/inc_functions.asp, line 2299


how can i slove this problem

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 June 2002 :  12:57:33  Show Profile
Have you tried to search in these forums for instructions on how to upgrade from Access to SQL Server? If you would, you'd avoid these problems.

You cannot use the Access Upgrade Wizard for that. The recomended upgrade process is explained here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=30301 (obviously you don't have to run the dbs file for Active Users if you haven't the mod installed.

Delete your SQL Server database or the existing tables and do it again using the process explained in the link above.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs


Edited by - ruirib on 29 June 2002 12:58:30
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 4.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07