Hey guys,
I'm using dotnetCart and have been trying to import my locally "working" database to the remote server. First of all, I have little experiences in regard to MS SQL database, just know how to change tables and that, so that's mainly the reason I purchased a shopping cart anyway.
Okay, I read this particular thread as it is fairly similar to my problem.
http://support.jodohost.com/showthread.php?t=2534&highlight=null
I too have "Cannot insert the value NULL into column 'CustomerID', table 'tablename.dbo.Customers'; column does not allow nulls. INSERT fails. The statement has been terminated. [Customer Table]" and also another same error with the OrderAddresses column in the OrderAddress table whenever I try to "Submit an Order".
For testing purposes, I tried to use DTS import/export from a local database to another local database. All settings were default when attempting to use the wizard. That is, "Append rows to destination table" is SELECTED and "enable identity insert" is UNSELECTED.
Unfortunately, the errors occur. I tried doing "set CustomerID field source to <ignore>" as well. (also found this possible solution in other forum). But it fails to import the database properly.
Since the developers of the shopping cart wouldn't support this (they say it is a database settings related, not their problem), I really need help to get this going. Can anyone please recommend any solutions or any people/places I can turn to get some more help?
Thank you.
I'm using dotnetCart and have been trying to import my locally "working" database to the remote server. First of all, I have little experiences in regard to MS SQL database, just know how to change tables and that, so that's mainly the reason I purchased a shopping cart anyway.
Okay, I read this particular thread as it is fairly similar to my problem.
http://support.jodohost.com/showthread.php?t=2534&highlight=null
I too have "Cannot insert the value NULL into column 'CustomerID', table 'tablename.dbo.Customers'; column does not allow nulls. INSERT fails. The statement has been terminated. [Customer Table]" and also another same error with the OrderAddresses column in the OrderAddress table whenever I try to "Submit an Order".
For testing purposes, I tried to use DTS import/export from a local database to another local database. All settings were default when attempting to use the wizard. That is, "Append rows to destination table" is SELECTED and "enable identity insert" is UNSELECTED.
Unfortunately, the errors occur. I tried doing "set CustomerID field source to <ignore>" as well. (also found this possible solution in other forum). But it fails to import the database properly.
Since the developers of the shopping cart wouldn't support this (they say it is a database settings related, not their problem), I really need help to get this going. Can anyone please recommend any solutions or any people/places I can turn to get some more help?
Thank you.