Most things work correctly but there are a few errors that I get in certain places on the forums.  Here is what I get when I try to register.  The error occurs after filling in user information and clicking the register button:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Author_ID', table 'InsideStilesForums.dbo.tblAuthor'; column does not allow nulls. INSERT fails.
/webwiz/forum/register.asp, line 821

This next error happens when I try to add a user to my buddy list:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Address_ID', table 'InsideStilesForums.dbo.tblBuddyList'; column does not allow nulls. INSERT fails.
/webwiz/forum/pm_add_buddy.asp, line 152

I checked the SQL tables and it is like the forum isn't trying to put a number in those fields.  Should I allow NULLS in the tables?  Or should I be looking somewhere else?  Please help!

open the db in enterprise manager and change the datatype to int for the id fields mentioned above, then change it to increment...

Well that took care of those problems.  Thanks for your help.

Now I have some new ones that hopefully you can help me with.

After adding a new test user I click on the Members List button and get the following:

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/members.asp, line 341

I also get the following error if I click on the membership admin button on the admin page.  It must have to do with this CLng field or value.

Error Type:
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null: 'CLng'
/webwiz/forum/admin/select_members.asp, line 279

Please help.  Thanks

Often when upsizing from access to sql server unless you get it correct the default values, relationships, etc. are not carried over. This often happenes if you use a DSN to uypsize the database.

Start over again as you do need to get all the default values and raltionships correctly carried over to get the forum to function correctly.

Ok I started from scratch.  Made a new database, ran the MS SQL setup, i comletely configured the forums from the admin page, I registered a test user (so far all is well).

I went to test posting for the first time and I get this:

Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'CuLocation'
/webwiz/forum/post_message.asp, line 590

Any suggestions?

I suggest using a program like http://www.flasfxp.com - www.flasfxp.com to upload your files as it looks like they are becoming corrupted. The forum should run fualtlessly with no errors and much bug testing has been done over the last 3 years to make sure it shouldn't crash.

The file you mention should read:-

.CursorType = 2

and no where should it say CuLocation

THANK YOU THANK YOU

That worked.  That was the only thing that I couldn't do.

Thanks again.