https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 09:45:08 +0000 Tue, 11 Apr 2006 17:05:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19235 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103873.html#103873 Author: Necronom
Subject: 19235
Posted: 11 April 2006 at 5:05pm

Thank you, this is exaclty what I was looking for!

. necronom .]]> Tue, 11 Apr 2006 17:05:25 +0000 https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103873.html#103873 https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103829.html#103829 Author: WebWiz-Bruce
Subject: 19235
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.
]]> Tue, 11 Apr 2006 12:10:47 +0000 https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103829.html#103829 https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103789.html#103789 Author: Necronom
Subject: 19235
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 .]]> Mon, 10 Apr 2006 21:36:32 +0000 https://forums.webwiz.net/difference-in-code-btwn-access-and-sql_topic19235_post103789.html#103789