I am brand new to sql. I tried to null into design. It worked but didn't get a topic number.????
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 'lanstuff.dbo.FORUM_TOPICS'; column does not allow nulls. INSERT fails.
Imported database from access using mssql import tool. Tried to write topic into forum and got this error. I put null into topic_id in Forum_Topic. Post worked but didn't assign a topic number into database for retrieval.
What is a error Error: -2147217865 I am trying to install databases using setup.asp. I get the Installation of forum-tables in the database.
Database Type: Microsoft Access
Forum Admin UserName/Password:
Here you will choose the Forum Admin UserName & Password that will be entered into the database for the Forum Admin. The password should be something that you can remember, but not something easily guessed by anyone else. Size limit is 25 characters.
YOU ARE THE MAN. Your information worked wonderfully. It also fixed several other feature errors I was having. THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
That's why I recommended that move. The null error itself could be fixed by setting the field as an identity field, but that's not the only error upgrading using Access wizard causes, so I always advise repeating the upgrade process, but doing it in the proper way.
Topic Locked
Posted - 26 July 2005 : 16:41:46
