Hi I was runnigh WWF 7 Access version, and I've tryed updating to WWF 7.5 SQL server.

So I've migrated my old database access, and when i run my new SQL server forum all seems to go ok until I try to post a new message. The I get a quite strange error

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 línea 746

I Don't know wich can be the error. Any Suggestions?

I have done both things (I've also execite de MSsql_server_setup.asp)

I can browse th forum , but when trying to post it gives me this error.

I will try to convert my database again and will tell you

Thanks!

Thanks Borg I also had tryed this.

Now I have made some progress:

what i did was to migrate the database and then execute Mssql_server_setup.

Now. I have firstly executed the MSsql_server_setup and after this I migrated the database. It gave some errors, but Now I can post, but the problem is that the users were not migrated; so there are no users in the forum and i can not log in.

Any Idea of how to migrate users and to go trough the error!

Thanks again!

Thanks again Borg;

But I am not finding anything about this issue with the search function even when I have tryed it for several minutes! - maybe due to my bad english and my vocabulary limitations -

I will continue trying to find something about this issue; but meanwhile could someone give a link to the topic in wich this issue is solutioned - I swear you that I've tryed hard but i can't findit -

Thans a lot!

Thanks huwnet, but I can't find it.

But I was able to fix it. I will post what I've done, so the people having this error in the future, will have two opportunitys of finding it:

• Use DTS to migrate the tables tblAuthor, tblGroups, tblGuests
• Run the msSQL_server_setup.asp script -it will return some errors, doesn't seem to matter-
• Use DTS to migrate all tables now -except the tables of the first step-

I don't now if it is a clean solution, but all seems to work fine.

Thank you very much for you hel Borg and huwnet

Lazaro wrote: Thanks huwnet, but I can't find it. But I was able to fix it. I will post what I've done, so the people having this error in the future, will have two opportunitys of finding it: Use DTS to migrate the tables tblAuthor, tblGroups, tblGuests Run the msSQL_server_setup.asp script -it will return some errors, doesn't seem to matter- Use DTS to migrate all tables now -except the tables of the first step- I don't now if it is a clean solution, but all seems to work fine. Thank you very much for you hel Borg and huwnet

I did exactly as you described in your steps I had few errors when running ms_sql setup as you told but during step 3 all tables went well except 2 tables and I got the errors below:

did you get the same problem?? and does it effects the forum or do I miss functionality or performance??

thnx for you suggestion

It is true I had some tables not enabled identity insert I did that by all tables but by step 3 it still gave the smae errors by the two tables.

ain step 2 I get these errors:

Error Creating the Table tblAuthor (it may already exsist)

Error Creating the Table tblGroup (it may already exsist)

Error Creating the Table tblGuestName (it may already exsist)

Error Creating the Relationship between the tblAuthor and tblGroup tables (it may already exsist)

Error Creating the Relationship between the tblBuddyList and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblEmailNotify and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblPMMessage and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblThread, tblTopic and tblAuthor tables (it may already exsist)

Error entering default values in the Table tblGroup

Error entering default values in the Table tblAuthor

SQL Server database is set up, but with Error!

 After tying 3 times still getting the error in DTS with 2 tables

I tested the forum and everything seems ok but I get followin errors while testing:

insert new user registeration
after filling register form and hit submit I get:

Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'Author_ID', table 'iforumnl.iforumadmin.tblAuthor'; column does not allow nulls. INSERT fails.

/iforum/register.asp, line 904

Delete post:

Active Server Pages error 'ASP 0116'

Missing close of script delimiter

/iforum/delete_post.asp, line 4

The Script block lacks the close of script tag (%>).

in admin section klik on SQL_db statistics

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'master.iforumadmin.spt_values'.

/iforum/admin/sql_server_db_stats.asp, line 24

Information:

MS-SQL 2000 server
hosting: securemate.net
WWF version 7.6
DB name: iforumnl
DB user: iforumadmin (=owner)

I solved two of the errors above:

insert registration: error solved
by editing the table design thru enterprise manager. you have to make the column author_id in table author to integer with auto increment = 1

delete error solved
I just uploaded the file delete_post.asp again and it worked. that is strange though because the old file worked fine with the access version !!!

I still have the error of DB statistics (I uploaded the file again but doesn't work)

new error New user
A new registered user gets problems while try to do these things:
- view the profile
- send pm or read pm that new user send
- post new message
and more problems

all those problems seems occurs because of default values in table author like join_date = now() and it should be getdate() for ms-sql
same thing with column no of posts etc...
I fixed the problem with new registration by editing table desing my self,  is there an better way to convert the table author into ms-sql?? instead of having to edit all columns manually??  are there other tables that will need editing??

thanks in advance