Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Code diff between access & sql version
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Code diff between access & sql version

 Post Reply Post Reply
Author
boogie View Drop Down
Newbie
Newbie


Joined: 17 May 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote boogie Quote  Post ReplyReply Direct Link To This Post Topic: Code diff between access & sql version
    Posted: 17 May 2003 at 6:34am

I modded the forum application to integrate with my asp site to combine registration processes and some other things. I developed my site with the access version of 7.1 on my local site. Now I'm going to deploy it on sql server on a remote site. Is the only difference between the two versions is that the Access version includes an access db while sql includes the sql server db creation script.

I've seen the posts that say all that is necessary to upgrade between the two is changing the connection type in common.asp and the sql server connection script. Are there any subtle buried differences in the two versions that I need to ferret out?

Or can I just remove the Access database and slap the msSQL_server_setup.asp file into the Access version and have the same thing as the sql server version?



Edited by boogie
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 May 2003 at 9:46am
You need to also change a variable in the common.asp files that tells the forum code which database type you are using.
Back to Top
boogie View Drop Down
Newbie
Newbie


Joined: 17 May 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote boogie Quote  Post ReplyReply Direct Link To This Post Posted: 17 May 2003 at 9:59am
Thanks a bunch. This is a really well documented, well built forum. I plan to register it as soon as I get the sql server up and running.
Back to Top
 Post Reply Post Reply

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.