Difference in Code btwn Access and SQL
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=19235
Printed Date: 12 April 2026 at 9:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Difference in Code btwn Access and SQL
Posted By: Necronom
Subject: Difference in Code btwn Access and SQL
Date Posted: 10 April 2006 at 9:36pm
first off, b0rg, you're the man! =)
I have been running your forum code for about 4 years now, and love it even more with every release. I am currently in the process of migrating a heavily modified v7.x access db and code to the new v8.1.1. sql. Yes, i know this is a crazy task, but it's worth it =)
My main question is:
Is there any code difference between the access version of 8.1.1 and SQL 8.1.1? I know the database connection file has the one comment difference to select sql over access, but other than that, is there any reason I can't just modify my database connections file of an access version when I convert it to SQL?
Thanks!
. necronom .
-------------
http://www.BodyMod.org - Body Modification Organization
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 11 April 2006 at 12:10pm
The code base is the same, the only difference, like you say is the selection of the database type and connection string in the database connection file.
To keep things simple all other changes are done within the forum engine by detecting what database type you are using then dynamically creating the appropriate SQL query.
|
Posted By: Necronom
Date Posted: 11 April 2006 at 5:05pm
Thank you, this is exaclty what I was looking for!
. necronom .
-------------
http://www.BodyMod.org - Body Modification Organization
|
|