Phase Out Generic Connections
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11010
Printed Date: 30 March 2026 at 1:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Phase Out Generic Connections
Posted By: Sxar
Subject: Phase Out Generic Connections
Date Posted: 27 June 2004 at 10:40am
|
I just thought of something. Why doesnt borg phase out the Generic Connection to Microsoft Access and use only the Jet SQL connection. Jet SQL Connection is much faster than the generic connection and there would be almost no reason to include the generic connection into the next version. Also using Jet SQL borg could set up complete setup scripts for the WebWizForums. Using CREATE TABLE, the Setup Scripts would be able to create tables and name the Database. What do you think? I might even write the scripts myself! |
Replies:
Posted By: Semikolon
Date Posted: 28 June 2004 at 7:11am
|
you can't set up the complete WWF database like it is now with Access..
unless you find a way to create boolean fields and probably some other
things then the generic access driver is there for those who get problems with the Jet OLEDB Drivers, and if I'm not wrong, the Jet OLEDB Driver is the default, so why bother removing the generic? |
Posted By: Sxar
Date Posted: 28 June 2004 at 8:26am
|
I understand there is not to much of a problem in removing the generic driver, its only one or two lines of code to remove. The main advantage is Jet SQL is faster (This is True). Also the syntax of Jet SQL allows you to do more things than you could with the generic version, there are more functions that could be implimented as the Jet SQL syntax is similar to MySQL. Populating a Database in ASP: Creating a Database in ASP: Tutorial on Jet SQL: |