ahkDBA - 64-bit windows tip

[burque505]

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 (90.79 KiB) Viewed 2128 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

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

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