ahkDBA - 64-bit windows tip
Posted: 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: 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
with
Run DBAExampleOOP.ahk.
Voila, mdb connectivity again.
Regards,
burque505
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: 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"
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"
Voila, mdb connectivity again.
Regards,
burque505