FORGEBOX Enterprise 🚀 - Take your ColdFusion (CFML) Development to Modern Times! Learn More...

UCanAccess

v0.7.1 Public

UCanAccess

cfmlbadges cfmlbadges cfmlbadges

Connect to MS Access databases easily with the UCanAccess JDBC driver which supports MS Access files from 2000 through 2016.

Installation

via Forgebox Provider

  1. In your Lucee (Server) Administrator, go to the Extension > Providers page and add https://forgebox.io as a New Extension Provider if not already present
  2. Go to Extension > Applications and look for UCanAccess in the "Not installed" section
  3. Click the extension and install

Manual Installation

  1. Download the the lucee-ucanaccess.lex file
  2. In your Lucee Administrator, go to the Extension > Applications page
  3. Under "Upload new extension", select the lex file and click "Upload"

Usage

The main "trick" to using the driver is configuring your datasource.

  1. The classpath should be net.ucanaccess.jdbc.UcanaccessDriver
  2. The connection string should start with jdbc:ucanaccess: ///
  3. The rest of the connection string should be your full MS Access file path: C:\Users\me\my\AccessDatabase.accdb
msAccessDB = {
   class: "net.ucanaccess.jdbc.UcanaccessDriver",
   connectionString: "jdbc:ucanaccess:  ///C:\Users\me\my\AccessDatabase.accdb"
};

TODO

  • â�Œ Get it working
  • â�Œ Test various datasource options - e.g. connectionLimit, username, password
  • â�Œ Document various connection string options

The Good News

For all have sinned, and come short of the glory of God (Romans 3:23)

But God commendeth his love toward us, in that, while we were yet sinners, Christ died for us. (Romans 5:8)

That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. (Romans 10:9)

Repository

Copyright 2019 (and on) - Michael Born

Here are all the versions for this package. Please note that you can leverage CommandBox package versioning to install any package you like. Please refer to our managing package version guide for more information.

Version Created Last Update Published By Stable Actions
Current
0.7.1 Jul 14 2019 09:05 PM Jul 14 2019 09:05 PM
Version History
0.7.0 Jul 12 2019 09:34 AM Jul 12 2019 09:34 AM

 

No collaborators yet.
   
  • Jul 11 2019 08:35 AM
  • Jul 14 2019 09:05 PM
  • 48
  • 23
  • 2