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

nguyencno5 wrote:  Can you guys also help me on this.. I still getting the error below when running WWForum (registration new user). Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Author_ID', table 'mySQL_database_name.dbo.tblAuthor'; column does not allow nulls. INSERT fails. Thanks in advance!

I am also trying to get my access db working on ms-sql the error you get I got also. I solved it 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

wow.. thank you all very very much!!!!

you guys are all big help!!.. i'm trying it right now.. if anything else come up I know where to find help

If you have IIS and the .net framework on your local PC MS "Web Data Administrator" to manage MS SQL DB's from a browser . Free and very slick.

http://www.microsoft.com/downloads/details.aspx?familyid=f0d 03472-5e6c-459e-a6d8-6745a729c3c9&languageid=f49e8428-70 71-4979-8a67-3cffcb0c2524&displaylang=en

for Access DB's using asp , try Stp Database - http://www.stpworks.com/DesktopDefault.aspx?tabid=8&tabi ndex=4&stpdl=view&ItemID=1

Badaboem wrote: How do I do it is a completely different question compared to where do I find it  + use google...you'd be surprised how much you can find by just searching. http://support.jodohost.com/showthread.php?t=157 it seems they don't have an ''online tool'' to view database contents. Download as described above.

Im probably wrong, but I believe the Visual Studio came with a "Version 7" of Ent Manager ... and this wont connect to SQL2000.

Try this for some options

http://www.aspfaq.com/show.asp?id=2442

You might also find this site useful http://www.aspenterprisemanager.com/ they ahve an online version of their alpha release

PS

YOu can download the EVal version of SQL Server ... which will have Ent Manager ... but it will be illegal to use Ent Manager beyond the trial date .... but I'll leave that up to you

http://www.microsoft.com/sql/evaluation/trial/default.asp

How do I do it is a completely different question compared to where do I find it  + use google...you'd be surprised how much you can find by just searching.

http://support.jodohost.com/showthread.php?t=157

it seems they don't have an ''online tool'' to view database contents. Download as described above.