| Author |
 Topic  |
|
|
ahmedhn
Starting Member
2 Posts |
 Posted - 15 October 2005 : 04:58:34
|
Hi,
Am having a permission problem I believe since I moved my Access Database to SQL Server 2000. I did the migration as instructed in the forum. But When I do the DTS in SQL server and move all the data to SQL server, I am able to get into the forum and read the data but I cannot post anything to the database. I cannot post to the forum and I cannot register as I get an error msg. By the way, I have 2 separate servers, before it was all on one server, now I separated them into 2, one is the webserver where the discussion files reside, and the other is the database server where the database of the discussion forum on SQL server resides. SO I believe there is a problem in permissioning if am not wrong which I don’t know how to fix so require your help on that plz. The following is the error I get when I try to submit anything to the forum after the migration process.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'TOPIC_ID', table 'FORUM.dbo.FORUM_TOPICS'; column does not allow nulls. INSERT fails.
/FORUM/post_info.asp, line 889
When I run the Setup.asp, I get 13 critical errors with the Insert command which means I cannot post because again of a permissioning problem I think. Can you plz guide me through fixing this problem?. Thank you.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 October 2005 : 05:10:12
|
That error message means that the migration was not correctly completed. Setup.asp needs to be completed with sucess and then and only then can you transfer the data using DTS.
Did setup fail because of permission problems (the INSERT fail error is not a permissions problem)? Maybe. If you post the error message I may be able to tell you.
Right now it seems to me that you need to start from the beginning again: run setup.asp without errors and then transfer the data using DTS. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
ahmedhn
Starting Member
2 Posts |
Posted - 22 October 2005 : 10:20:32
|
Here is the error I get:
Error: -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'GROUP_KEY', table 'Discussion.dbo.FORUM_GROUPS'; column does not allow nulls. INSERT fails.
strSql: INSERT INTO FORUM_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)
Error: -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
strSql: INSERT INTO FORUM_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
