Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Step by Step v7.x Access to v8.01 SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedStep by Step v7.x Access to v8.01 SQL
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
superlative View Drop Down
Groupie
Groupie

Not Comparative, I m Superlative :)

Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125 		Direct Link To This Post Posted: 18 April 2006 at 6:47pm
Hi Fatih;
 
Thanks for your descriptions. When I upsize my access to SQL I can not see any problem. But I see some unnecessary fields in upsized SQL db. I compare Original SQL db and upsized DB. I stop working DB's. Currently I change design and settings. After this is completed i try again upsize to DB. I want to tell you the best way for your below step :
 
Originally posted by fatih.koz fatih.koz wrote:



Uploading to public server and going online

- Do general maintenance on local sql server
- Backup the database
- Zip it ;)
- Upload to public sql server
- Create a blank database with same details for V8
- Restore your full database
- Upload v8 SQL to public server
- Test

 
instead of this step, I use this way :
  • Tested and working SQL DB (Local)
  • I open my Enterprise Manager
  • Action menu > New SQL Server Registration
  • Enter hosting companie's access information (user-pass-IP address)
  • Then Now you can see your hosting companys all SQL DB's
  • Click your DB (in hosting companie's SQL server)
  • Then run DTS
  • You can easly transfer your local server db to hosting companie server db)

Back to Top
superlative View Drop Down
Groupie
Groupie

Not Comparative, I m Superlative :)

Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125 		Direct Link To This Post Posted: 23 April 2006 at 10:16pm
I succesfuly upgrade my 8.01 access db to SQL but when i try to see a topic i recieve this error :
 




Microsoft VBScript runtime error '800a01f4' 

Variable is undefined: 'strTxtDirectLinkToThisPost' 

/forum/forum_posts.asp, line 891
 
any idea ?

Back to Top
superlative View Drop Down
Groupie
Groupie

Not Comparative, I m Superlative :)

Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125 		Direct Link To This Post Posted: 23 April 2006 at 10:31pm
Sorry guys, when i translate forum, I delete Const strTxtDirectLinkToThisPost in the language file. (missing) Problem resolved.

Back to Top
superlative View Drop Down
Groupie
Groupie

Not Comparative, I m Superlative :)

Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125 		Direct Link To This Post Posted: 23 April 2006 at 10:43pm
strTxtDirectLinkToThisPost is not working. I check the forum_posts.asp line 891, Direct link to this post text doesnt appear. Because img alt tag is bullet andonly appear image alt tag. May be fixed further versions. Correct line is here :
 
Quote
Response.Write("<a href=""forum_posts.asp?TID=" & lngTopicID & "&PID=" & lngMessageID & strQsSID2 & "#" & lngMessageID & """><img src=""" & strImagePath & "bullet.gif"" border=""0"" align=""absmiddle"" alt=""" & strTxtDirectLinkToThisPost & """/></a> ")


Edited by superlative - 23 April 2006 at 10:44pm

Back to Top
superlative View Drop Down
Groupie
Groupie

Not Comparative, I m Superlative :)

Joined: 26 November 2004
Location: Turkey
Status: Offline
Points: 125 		Direct Link To This Post Posted: 20 May 2006 at 6:57pm
Hi again,
 
I successfully migrate my forum WWF v7.7a access to WWF v8.01 SQL version at yesterday. I translate my forum to Turkish and user can select english or turkish. Necronom's topic's is very helpfully for me. You can benefit from this topic :
 

Back to Top
 Post Reply Post Reply Page  <12

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.