Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Phase Out Generic Connections
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Phase Out Generic Connections

 Post Reply Post Reply
Author
Sxar View Drop Down
Newbie
Newbie
Avatar

Joined: 25 December 2003
Location: Australia
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote Sxar Quote  Post ReplyReply Direct Link To This Post Topic: Phase Out Generic Connections
    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!



Edited by Sxar
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
Sxar View Drop Down
Newbie
Newbie
Avatar

Joined: 25 December 2003
Location: Australia
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote Sxar Quote  Post ReplyReply Direct Link To This Post 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:
http://members.lycos.co.uk/zhanshan2002/asp/dbcreatesql.html

Creating a Database in ASP:
http://www.sqldts.com/default.aspx?288

Tutorial on Jet SQL:
http://www.devguru.com/technologies/jetsql/quickref/jet_sql_ intro.html



Edited by Sxar
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.