Web Wiz Forums - Code diff between access & sql version

Print Page | Close Window

Code diff between access & sql version

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2791
Printed Date: 01 April 2026 at 2:21am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Code diff between access & sql version

Posted By: boogie
Subject: Code diff between access & sql version
Date 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?

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: boogie
Date 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.