ahkDBA - 64-bit windows tip

Put simple Tips and Tricks that are not entire Tutorials in this forum
burque505
Posts: 388
Joined: 22 Jan 2017, 19:37

ahkDBA - 64-bit windows tip

17 May 2018, 18:34

Those of you who use (or try to use) ahkDBA, especially on 64-bit Windows, may have noticed problems due to the retirement of Microsoft.Jet.OLEDB.4.0.
Get the 2010 Access Database Engine redistributable.
For installation problems, see here. You may have to search a bit for solutions matching your mix of 32-bitness and 64-bitness, and you Office versions, if any. Some solutions involve a command line install with either /quiet, or /passive. You may see an error similar to this:
OLEDB.PNG
OLEDB.PNG (90.79 KiB) Viewed 48 times

There are lots of solutions available online for this, again depending on your setup.

If you download the github package above, there is an example script, DBAExampleOOP.ahk
Once you've successfully installed the Access Database Engine, replace

Code: [Select all] [Download] GeSHi © Codebox Plus

connectionStrings := A_ScriptDir "\Test\TestDB.sqlite||Server=localhost;Port=3306;Database=test;Uid=root;Pwd=toor;|Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" A_ScriptDir "\Test\TestDB.mdb"

with

Code: [Select all] [Download] GeSHi © Codebox Plus

connectionStrings := A_ScriptDir "\Test\TestDB.sqlite||Server=localhost;Port=3306;Database=test;Uid=root;Pwd=toor;|Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" A_ScriptDir "\Test\TestDB.mdb"


Run DBAExampleOOP.ahk.
Voila, mdb connectivity again.
Regards,
burque505

Return to “Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 0 guests