| Author |
 Topic  |
|
|
austen
Starting Member
9 Posts |
 Posted - 20 June 2001 : 14:08:27
|
I had my boards set up in access and they kept dying, so I moved scrapped them and am starting over trying to instal them in sql server..
I followed the documentation to the best of my ablilty, and set up the db, and seem to be connecting to it ok, but whenever I Try to post a message or create a topic, I get the followign error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'CAT_ID', table 'lobbygodsdb.daytona.FORUM_CATEGORY'; column does not allow nulls. INSERT fails.
Anyone ever seen this before, or have any idea why it's not generating a value? I've completely scrapped everything and reinstalled 3 times now, and I get this every time :(
|
|
|
austen
Starting Member
9 Posts |
Posted - 20 June 2001 : 19:45:38
|
bump
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 June 2001 : 20:48:43
|
| did you let setup.asp create the tables in your SQL DB, or did you upsize or import the Access DB? |
|
|
|
austen
Starting Member
9 Posts |
Posted - 20 June 2001 : 21:28:48
|
I imported my tables from access... setup.asp wasn;t creating them.. should it?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 June 2001 : 21:29:49
|
yes, for it to work correctly you need to let setup.asp setup the tables.
did you try using setup.asp?rc=5 ?
When you are asked for a username/password, you need to use the username/password for your SQL Database, not for the forum. |
|
|
|
austen
Starting Member
9 Posts |
Posted - 20 June 2001 : 23:10:50
|
w00t! that fixed it.. working now
:) thanks! 
|
|
|
| |
Topic |
|
Topic Locked
