Web Wiz Support and Community Forums : Upsizing hell.....................:) https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 15:36:40 +0000 Wed, 14 Jan 2004 06:40:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7448 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upsizing hell.....................:) : That&#039;s clearly defined in...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46812.html#46812 Author: Badaboem
Subject: 7448
Posted: 14 January 2004 at 6:40am

That's clearly defined in the ms_sql_setup.asp file. You can delete the part that creates tables etc. It should eliminate the issue that it creates double values under the smut and configuration table, along with the double administrator name that is created.

Just comment out everything except for the creation of stored procedures..this will only work if you use the upsizing method from access.



Edited by Badaboem]]> Wed, 14 Jan 2004 06:40:41 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46812.html#46812 <![CDATA[Upsizing hell.....................:) : I still getting the weired problem...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46807.html#46807 Author: otti
Subject: 7448
Posted: 14 January 2004 at 6:13am

I still getting the weired problem that all posts are created by forum administrator??!!!

if I use DST (import data from mssql) then I got errors because of duplicate keys etc...  is it possible to get a custimezed version of ms_sql_setup.asp for the import. I mean that the script only creates the db and the stored procedures and that the import tool creates the tables??!!!

please help and thanks in advance

]]> Wed, 14 Jan 2004 06:13:06 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46807.html#46807 <![CDATA[Upsizing hell.....................:) : does the server need to set permission...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46755.html#46755 Author: nguyencno5
Subject: 7448
Posted: 13 January 2004 at 11:27pm

does the server need to set permission DBO so that I can write table from access to SQL?

thanks!
]]> Tue, 13 Jan 2004 23:27:13 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46755.html#46755 <![CDATA[Upsizing hell.....................:) : You got me... I&#039;m by know...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46714.html#46714 Author: lodogg
Subject: 7448
Posted: 13 January 2004 at 6:15pm

You got me... I'm by know means a sql guru I wish I was:(  Those steps worked for me.  I would try different methods of importing and see if that works?  Are you using SQL 2000?

 

Thanks

Lo

]]> Tue, 13 Jan 2004 18:15:01 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46714.html#46714 <![CDATA[Upsizing hell.....................:) : lodogg wrote: Sure.. http...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46690.html#46690 Author: otti
Subject: 7448
Posted: 13 January 2004 at 4:27pm

Originally posted by lodogg lodogg wrote:

Sure..

http://www.lodogg.com/upsizing.htm

This what I did and it worked for me?

I followed the steps as described everything seems to go well exept the errors when running ms_sql_setup.asp but that is already known.

after I run the script I could see al the forum topics and categories but I couldnt see the messages posted in a forum. it gives all 0 I Re-sync Topic and Post Count in admin but gives the same. when I click on a topic from last forum posts I get the error that dont have permession to get in the forum??!!! I am login in as administrator...

please help cause I really tried everything know, upsize gives problems and import data also...

I really need this cause my access db become getting to large and I am moving to an other hosting for mssql (www.securemate.net)

thanks in advance,

ps: I use wwf 7.6 and ms-sql_2000



Edited by otti]]> Tue, 13 Jan 2004 16:27:24 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46690.html#46690 <![CDATA[Upsizing hell.....................:) : Sure.. http://www.lodogg.com/upsizing.htm This...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46656.html#46656 Author: lodogg
Subject: 7448
Posted: 13 January 2004 at 2:03pm

Sure..

http://www.lodogg.com/upsizing.htm

This what I did and it worked for me?

]]> Tue, 13 Jan 2004 14:03:56 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46656.html#46656 <![CDATA[Upsizing hell.....................:) : is there any reference page that...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post46605.html#46605 Author: nguyencno5
Subject: 7448
Posted: 13 January 2004 at 10:06am

is there any reference page that show step by step procedure?  Ireally need this as soon as possible.  I'm running WWF 7.7 andaverage 10 new users each day and posts are increasing extremelyfast. 

thanks in advance.

I also use JODO host, I have no idea wat or how to set up SQL DB.  Access was easy because it's has a physical path.

]]> Tue, 13 Jan 2004 10:06:37 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post46605.html#46605 <![CDATA[Upsizing hell.....................:) : I think it creates an admin account...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post45453.html#45453 Author: lodogg
Subject: 7448
Posted: 08 January 2004 at 3:06pm

I think it creates an admin account because it's a new install of the forum really?  I think it has something to do with the stored procedures?  But who knows I'm not a developer

 

As long as it works

]]> Thu, 08 Jan 2004 15:06:56 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post45453.html#45453 <![CDATA[Upsizing hell.....................:) : Well it works fine. Just not sure...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post45447.html#45447 Author: Joey805
Subject: 7448
Posted: 08 January 2004 at 2:42pm

Well it works fine. Just not sure why it created an admin account???]]> Thu, 08 Jan 2004 14:42:13 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post45447.html#45447 <![CDATA[Upsizing hell.....................:) : Hmm...that&#039;s weird..same...]]> https://forums.webwiz.net/upsizing-hell_topic7448_post45437.html#45437 Author: Badaboem
Subject: 7448
Posted: 08 January 2004 at 2:07pm

Hmm...that's weird..same issue here.

Did someone succeeded completely, and how?

]]> Thu, 08 Jan 2004 14:07:06 +0000 https://forums.webwiz.net/upsizing-hell_topic7448_post45437.html#45437