SQL2000 Error

Comersus Version: 607
Database type: SQL Server
Frequency: Permanent issue

I just recently moved my web site and sql2000 database to a new provider. I moved the database using SQL Server import/export utility. I am now getting the following error:
Temporary error

Sorry for the inconvenience. Error in sessionFunctions, error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'idDbSession', table 'pumpwor_comersus.pumpwor_comersus.dbSession' column does not allow nulls. INSERT fails. – Err.Number:-2147217900 – SQL:SELECT idDbSessionCart FROM dbSessionCart WHERE idDbSession=0 AND cartOpen=-1 ORDER BY idDbSessionCart

Can anyone help?

This article was posted in Uncategorized and tagged , . Bookmark the permalink. Follow comments with the RSS feed for this post. Post a Comment or leave a trackback: Trackback URL.

One Response to "SQL2000 Error"

  1. Comersus (Rollins) says:

    It seems that the transfer did not respect database field properties. You can use SQLServerStructure.txt file to check each file type.

    You can also contact Comersus to request a quote for this manual verification.


Leave a Reply

Your email address will not be published. Required fields are marked *

© 2017 Comersus Forum. All Rights Reserved.
Powered by WordPress. Download Free Shopping Cart Now
porno porno izle porno izle