Converting access forum to sql server --

I have no problem with the basics but am getting stuck in one spot. When using DTS to import tblAuthor into the SQL database, I keep getting an unspecified error.

The table gets created, but no data gets populated. I've tried every way I can think of with no success.  All other tables and stored procedures import successfully.

I've done a search of forum topics but can't find a related solution post.

Thx,

Ben Peskoe

Are you running this on your local machine?
When running DTS import, make sure you are not using Windows authentication to login to the database and instead login with any username that you have given DBO permissions to.

The biggest issue of using dts for this forum are the many relationships, You need to know what table to improt first. If you import the tblAuthor but do not yet have the tblGroups it will confilct. An order as follows that has always worked for me:
tblBanList, tblConfigurations,tblDateTimeFormat,tblSmut,tblPoll, tblPollChoice,tblGroup,tblAuthor, tblEmailNotify,tblPMMessage, tblBuddyList, tblCategory,tblForum, tblPermissions, tblTopic, tblThread and tblGuestname.

Now this list is sure not static but like I said it worked for me and you will not get any PK errors.

Open up enterprise manager, click + to open the tree structured extensions of your local server until you get to databases and click on the database you created or upsized for Web Wiz forums. If you click on that database you'll see all tables. Rest see image.

i mean where can I find Enterprise Manager.. obviously I can't find it in my hosting company.

Thanks!

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 - 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.

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 - http://www.microsoft.com/sql/evaluation/trial/default.asp

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 - 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 - http://www.aspfaq.com/show.asp?id=2442

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

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=f0d03472-5e6c-459e-a6d8-6745a729c3c9&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylang=en - 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&tabindex=4&stpdl=view&ItemID=1 - http://www.stpworks.com/DesktopDefault.aspx?tabid=8&tabi ndex=4&stpdl=view&ItemID=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

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

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