Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Upsizing hell.....................:)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upsizing hell.....................:)

 Post Reply Post Reply Page  <123
Author
lodogg View Drop Down
Groupie
Groupie


Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
Post Options Post Options   Thanks (0) Thanks(0)   Quote lodogg Quote  Post ReplyReply Direct Link To This Post Posted: 13 January 2004 at 2:03pm

Sure..

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

This what I did and it worked for me?

Just trying to have some fun and learn in the process.
Come have Some Fun
Back to Top
otti View Drop Down
Newbie
Newbie
Avatar

Joined: 10 June 2003
Location: Netherlands
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote otti Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
lodogg View Drop Down
Groupie
Groupie


Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
Post Options Post Options   Thanks (0) Thanks(0)   Quote lodogg Quote  Post ReplyReply Direct Link To This Post 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

Just trying to have some fun and learn in the process.
Come have Some Fun
Back to Top
nguyencno5 View Drop Down
Groupie
Groupie


Joined: 26 November 2003
Status: Offline
Points: 62
Post Options Post Options   Thanks (0) Thanks(0)   Quote nguyencno5 Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
otti View Drop Down
Newbie
Newbie
Avatar

Joined: 10 June 2003
Location: Netherlands
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote otti Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Badaboem View Drop Down
Senior Member
Senior Member


Joined: 12 April 2002
Location: Netherlands
Status: Offline
Points: 600
Post Options Post Options   Thanks (0) Thanks(0)   Quote Badaboem Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  <123

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.