My previous error has been solved by relocating the MS Access database to another folder.
After compilation, it works on my laptop. But when I run the installer version and had it installed on my flashdrive, WIN 10, I got the following error message even I tried making multiple copies of instances of the database file into different folders.
[size="4"]Fatal error: Failed to create COM object `ADODB.Connection': The specified module could not be found. in E:\Installed\www\connections\Connection.php on line 661[/size]
When transferring the installed version on my flashdrive while connected to my laptop, all is ok running smoothly.
I tried in my other laptop with same WIN 10 and on the same flashdrive, installed with the same installer version. The error shown above appeared.
What does FAILED TO CREATE COM OBJECT mean?
I did another test and here's a result:
[size="4"]It runs on my laptop with WIN 10 64-bit. But it doesnt run on my other laptop that has WIN 10 64-bit even I installed it giving me the same error as FAILED TO CREATE COM OBJECT.
But when I run it on WIN 7 PRO, 64-bit in 2 different machines, same OS as WIN 7 Pro 64-bit, it run well without error.
So wondering, what's the desktop PC with WIN 7 Pro 64-bit has the same with my laptop WIN 10 64 bit, but doesnt work on another of my laptop that has WIN 10 Pro 64-bit.
[/size]
Hoping for another help as I intend to install the same to other PCs of different OS's.
Thanks.
-----------------------------------------------------------------------------------------
September 12
My problem got worst.
I upgraded my Windows Pro 2016, licensed of course and re-installed the Database Engine 64-bit
The PHP Runner Enterprise run but using the same code I had, failed to COMPILE properly.
Tried manually selecting the connection string, tried all, none worked.
Worst. when I tried to run the previously compiled PHP Runner using MS Access, from my flashdrive never worked and giving me the usual error in ADODB connection.
But using the same flashdrive with the installed PHP Runner app on my other laptop under WIN 7 PRO, it run very well with no error.
Tried to re-install in my laptop the 64bit Database Engine, still doesnt work.
I am using MSAccess 64 bit in WIn 10
Anybody can help me?
I cannot anymore compile properly inside PHP Runner Enterprise, running locally even trying all kinds of connections, doesnt work?
Thanks
----------
September 12 Midnight
Here's what I did. At least on my side I found an alternative solution that I can share to those who might encounter the same problem.
I downgraded the MS Access database to being MDB
With this, PHP Runner was able to compile properly and launch the app. And it worked on my laptop again under WIN 10 64 bit
I will still see if it works in other PCs.
So the problem lies in the connection string of higher version of database. Seems like. Or if someone can clear my mind.
Thanks ...
------------------------
September 13 945PM
I did try running the compiled PHP Runner using the downgraded MS Access database, "MDB" file, onto my other laptop that has Win 10, 64bit.
It worked!
Is there one installer that contains all the ADO engines from MDB to 2016 and above MS Access including all MYSQL? Or a set of installers, can we name them? so we can correct this error?
Seems that I have not found the correct installer that will allow me to, unless I am forced to downgrade the MSAccess 2016 to lowest version as MDB file.
Sorry, am not an expert on this. Just asking, no offense meant. As I am still interested how I can make my 2016 MS Access database files work in PHP Runner and work in either 32 or 64 bit.
Thanks
