First of all, Hi, I'm impressed ;)

I needed something like this as quick solution for our site [GRH] and this suites me pretty well.

I created the sql database and imported the data from the mdb. I ran into some little problems which I've fixed (mainly NULLs written to a RS) I've now encounterd a new one.

ADODB.Recordset (0x800A0CB3) Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /forum/post_message.asp, line 603 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.1.4322)

I tried all different kinds of locktypes, none worked. Maybe the problem is something else; is it normal that I have so many problems installing it on an IIS6/MSSQL2k? (Web Wiz Forums version 7.6)

thx for the reply, didn't help much tho.

I deleted the tables and procedures, created new ones using the sql script. Imported the data from the mdb and then I logged into the admin panel.

After login, I decided to add a new category (forum cat), this error occured:

Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E2F) Cannot insert the value NULL into column 'Cat_order', table 'GolfResv.dbo.tblCategory'; column does not allow nulls. INSERT fails. /forum/admin/category_details.asp, line 88

Am I doing something wrong when importing or what is happening? Why can't I get it to work?

-boRg-, can you give me a link to the previous version so I can try that? Or simply tell me if I'm doing something wrong :(

set the default value of cat_order to 0 and allowing nulls now, fixed that one.

when adding a forum, I get this:

Microsoft OLE DB Provider for SQL Server (0x80040E2F) Cannot insert the value NULL into column 'No_of_posts', table 'GolfResv.dbo.tblForum'; column does not allow nulls. INSERT fails. /forum/admin/forum_details.asp, line 194

Am I suppose to fix the forum code 1-by-1 or what's the deal here? Please someone advise me and tell me what's going on, I'm on a deadline here and would really like to implement your forum but I'll have to move on if I can't get this resolved.

PS: I'm on an NT5/MSSQL environment now.

Phat wrote: It's your update to the sql server not the forum code. Can you make a new sql database and not import from access? Or at least try making a new sql database to make sure it is working correclty on your server.

I figured it's not the forum code, that's why I stopped debugging it.

I'm going to recreate the database using the provided script and I will NOT import the Access database this time. Just one question: How do I go about the default admin account? That was the reason why I imported the data of the access database to the sql structure created by the .sql script.