forums.frontrange.com

[1]

Recently we upgrade from version 6.7 to version 7. My old code used DLL, it was working before and now return loadBDE error -4, so I try to switch to XML for testing. Here is my XML string:

<GMAPI call=\"LoadAPI\">
   <data name=\"User\">TOMD</data>
   <data name=\"Password\">abcd</data>
   <data name=\"SysDir\">h:\\goldmine7\\</data>
   <data name=\"GoldDir\">Goldmine7:</data>
   <data name=\"ComDir\">Goldmine7:</data>
   <data name=\"SQLUser\">sa</data>
   <data name=\"SQLPassword\"></data>
</GMAPI>

and result of the ExecuteCommand is:

<GMAPI call=\"LoadAPI\">
   <status code=\"-31703\">The call passed was not recognised as valid.</status>
</GMAPI>

Could anyone help me with this error, the XML string is correct, I've also test with CommonDir instead of ComDir but error is the same.

Thank a lot for your help,
Tom

[1]

as you can see in the sticky post http://forums.frontrange.com/viewtopic.php?t=25 BDE -4 --  Failed to validate password , so check your username/password!

[1]

Thank Sebatian, I'm careful check for that because my password is very simple but it's still fail. Actually, I used *DDE_LOGIN_CREDENTIALS* and the error is -4, if I pass in user name TOMD and pass: abcd, it returned error -5, I copied all the exe and dll from my server to override my local folder, run again and it returned the error -20 (datadict.xml is not correct), I overrided the datadict.xml from the server, the error is still -20. Another thing is that, anytime I run install Goldmine locally, it is error out that my install can not install locally in workstation, but it runs when I copy the dll and exe over from server.

Thanks a lot for your help.
Tom

[1]

hmm, did you try to unload any BDE application before you try the DLL-things ?
if not, give it a try :)

[1]

Thank you Sebastian, anyway.
I found the trouble that cause the error -4, that's because my exe and dll files version in the Windows\system32 folder did not match with those files in the server, I copied it over that solved my trouble, I can use API LoadBDE login to the Goldmine, but I still want to solve my trouble with GMXML by using GMAPI call = "LoadAPI", it still returns error:
<GMAPI call=\"LoadAPI\">
   <status code=\"-31703\">The call passed was not recognised as valid.</status>
</GMAPI>

TomD

[1]

i think you use the
GoldMine.UI.ExecuteCommand function to execute your login.

UI is similear to DDE (interact with loaded application)

you have to use the
GoldMine.GoldMineData.ExecuteCommand
for your LoadAPI Command.

[1]

You seem to be running the original release of GM7 - upgrade to the latest.

[1]

Yes, Sebastian.
I used:
strXML = "<GMAPI call=\"LoadAPI\">" +
  "<data name=\"User\">*DDE_LOGIN_CREDENTIALS*</data>" +
  "<data name=\"Password\">" + strDDEPass + "</data>" +
  "<data name=\"SysDir\">" + strSysDir + "</data>" +
  "<data name=\"GoldDir\">" + strGoldDir + "</data>" +
  "<data name=\"ComDir\">" + strCommdir + "</data>" +
  "<data name=\"SQLUser\">" + SQL_USERID + "</data>" +
  "<data name=\"SQLPassword\">" + SQL_USERPWD + "</data>" +
"</GMAPI>";
strResult = GoldMine.UIClass.ExecuteCommand(strXML);
the result as I showed you:
 <GMAPI call=\"LoadAPI\">
   <status code=\"-31703\">The call passed was not recognised as valid.</status>
 </GMAPI>"

ExecuteCommand is successful if I use:
<GMAPI call=\"GetLoginCredentials\"></GMAPI>
because when I pass the result from GetLoginCredentials to the LoadBDE (API command from Gm7s32.dll). I also have good result for strSysDir with:
<GMAPI call=\"Macro\"><data name=\"Macro\">&amp;SysDir</data></GMAPI>

Regards,
TomD

[1]

Please look here

[1]

Hi John,
I have gmw7.exe --> GoldMine 7.0 for Windows 98/2000/XP, version: 7.0.60526.0
Does it the latest upgrade?

Regards,
TomD

[1]

that's correct.

actually - delete the copies of all GM dlls in your Windows/System32 directory, then run GMW7.exe (the main GM exe) and login once with admin level rights - this will put everything you need where you need it.

If you have installed GM7 locally to the default location (%programfiles%/goldmine/goldmine), then go into the GM install dir and run regsvr32.exe against gmxmlapi.dll to be sure.