Phreeqc COM error 424

[mtmcnall]

Hello,

I am running a new 64 bit windows 10 computer. I have installed both the 32 and 64 bit versions of the COM module from the downloads page.

I keep getting error 424: Object not defined. I am trying the first example from the COM module file path.

Reading through other posts a fix is normally installing the .Net Framework 3.5 from control panel, which I also did, still receiving the error.

Any ideas of how to troubleshoot?

Thanks!

[dlparkhurst]

Are you running the Excel or Python example? Anyway, if you have Excel, try running

C:\Program Files\USGS\IPhreeqcCOM 3.6.2-15100\examples\com\excel\runphreeqc.xls

Open the file and run the macro: View->Macros->View macros, and then Run RunPhreeqc

Is this how you got the 424 error? If it fails, send the complete error message.

[mtmcnall]

Hello and thanks for the quick response!

I am running the Excel version and I always use the stated filepath to run the code, to limit any errors that I would bring into the code. But anyways, attached is the error I receive and when you press Debug, the script instantly receives an error with the Phreeqc.ErrorString line.

Thanks again.

[dlparkhurst]

First, have you checked that your IPhreeqcCOM versions were installed? Right-click on Windows in the bottom left; Settings->Apps.

IPhreeqcCOM and IPhreeqcCOM x64 should be listed.

Seems unlikely, but there is a note on how to turn on .NET in the operating system listed in the following post.

https://phreeqcusers.org/index.php/topic,1166.msg3693.html#msg3693

If everything still looks right, I'll have to ask Scott Chartlon for help.

[mtmcnall]

Both COM versions have been installed correctly as seen in the image below.

Additionally, the .Net Framework 3.5 has been installed with the system rebooted and upon running still receiving the same message.

I have contacted my IT administrator for help and the only thing he could possibly think is that the version of office 365 installed is 32 bit version, as this was installed on all our company devices. Do you think this is the problem? He asked me to try to solve the issue by any other means prior to changing the office 365 installation.

Thanks.

[charlton]

Can you open a command prompt window (by typing cmd into the search bar).  Then change to the directory that you saved LoadDatabase.vbs to and try running the command 'cscript LoadDatabase.vbs' and let us know the results?

[mtmcnall]

Hello Charlton,

I downloaded the database file you sent and tried to run the command. Please see attached image for the results.

Thanks

[charlton]

Hello mtmcnall,

I want to see if the download got corrupted somehow. If you have 7-zip installed could you try right-clicking on the msi files and choosing CRC SHA -> SHA-1.  It should look like the attached images below.  If you don't have 7-zip, you can get these values using powershell.  In a powershell window type the following commands:

Get-FileHash .\IPhreeqcCOM-3.6.2-15100-win32.msi -Algorithm SHA1
and
Get-FileHash .\IPhreeqcCOM-3.6.2-15100-x64.msi -Algorithm SHA1

If the values match try right clicking the msi files and selecting Repair

Scott

[mtmcnall]

Scott,

I ran the powershell script and it seems that the installation file was indeed corrupted. I repaired both the 32 bit and 64 bit and now the example files function as intended! Thank-you so much for taking the time to work through this with me, much appreciated!

Mitch

[charlton]

Glad I could help.

Scott