tag:blogger.com,1999:blog-913534236606046272.post5986487697318748281..comments2023-12-12T19:23:36.544+13:00Comments on movex blog: Interfacing Excel with M3 via APIsAlhttp://www.blogger.com/profile/06469996988980345250noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-913534236606046272.post-32933799541653391662023-12-12T19:23:36.544+13:002023-12-12T19:23:36.544+13:00Hi Al, I know this is an old post. A few years ag...Hi Al, I know this is an old post. A few years ago, I developed an Excel file to call PPS370MI. All worked well. I am now confronted with having to do this again, but this time to a Cloud version on M3. Do you have anything for that version of Movex?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-68087156163317914652022-02-13T15:54:38.696+13:002022-02-13T15:54:38.696+13:00This needs to be downloaded from the Infor support...This needs to be downloaded from the Infor support downloads site. I can see this here:<br /><br />Enterprise Resource Planning\M3 Core\M3 Core Options\M3 Core Integration Tools - M3 API ToolsAl Johnsonhttps://www.blogger.com/profile/12728083455378232837noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-79130530126104799682022-02-10T23:59:08.541+13:002022-02-10T23:59:08.541+13:00hi
where in can found the dll "MvxSockX_SVRx...hi<br /><br />where in can found the dll "MvxSockX_SVRx64.dll" i search it but i don't find it anywhere<br /><br />thanks<br />Francoisfrancoishttps://www.blogger.com/profile/08300917134587627040noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-50258374277944658912020-10-15T19:33:27.496+13:002020-10-15T19:33:27.496+13:00Hard to know sorry. Without access to your system...Hard to know sorry. Without access to your system or a screen share session to see the problem and debug it there's many potential problems including:<br />- network access<br />- wrong server name<br />- wrong port number<br />etc.Al Johnsonhttps://www.blogger.com/profile/12728083455378232837noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-23739109178529065462020-10-13T21:05:02.187+13:002020-10-13T21:05:02.187+13:00Hi,
Kindly help.
When i am using M3 EDU-CreateMo ,...Hi,<br />Kindly help.<br />When i am using M3 EDU-CreateMo , in that when i click on Create button it throughs me error "An error occurred in Connecting to the M3 API(MvxSockInit) "<br /><br />Kindly let me know what i should check in M3Anonymoushttps://www.blogger.com/profile/07083382110971787219noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-14879396407874081962017-09-30T00:01:17.927+13:002017-09-30T00:01:17.927+13:00You may not have registered the dll. Try doing tha...You may not have registered the dll. Try doing that and then try again.Alhttps://www.blogger.com/profile/06469996988980345250noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-56818016185126249552017-09-29T22:23:49.186+13:002017-09-29T22:23:49.186+13:00Hi,
When I tried to use FCS350, one of my compute...Hi,<br /><br />When I tried to use FCS350, one of my computer (its working in some machines) getting "Run time error 429", ActiveX component cant create object". Any reason for this. Kindly tell me.Anonymoushttps://www.blogger.com/profile/15116310558633771177noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-14588096919813688682017-04-14T14:12:58.097+12:002017-04-14T14:12:58.097+12:00Hi Farhat,
We installed MvxAPI in Windows 10 64 b...Hi Farhat,<br /><br />We installed MvxAPI in Windows 10 64 bit and we face "429 activex error" issue.<br />So we download MvxSockX_SVRx64.dll and MvxSockNx64 from Info Xtreme website.<br />During registering the dll file, we face new error message as below<br /><br />Command: regsvr32 MvxSockX_SVRx64.dll<br />Error message:<br />The module "MvxSockX_SVRx64.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005.<br /><br />Can you guide us to fix this problem?<br /><br />thank you!<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-43430629802306734542017-02-12T11:54:05.244+13:002017-02-12T11:54:05.244+13:00That and ensuring the dll is registered within Exc...That and ensuring the dll is registered within Excel as well should be all that is needed to make this work.Alhttps://www.blogger.com/profile/06469996988980345250noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-58499531601644221252017-02-07T02:00:45.766+13:002017-02-07T02:00:45.766+13:00Hi farhat,
so do I see it right, that you have man...Hi farhat,<br />so do I see it right, that you have managed it to run 64bit Excel with MvxSockX API/VB? Adding means register MvxSockX_SVRx64.dll with regsvr32? Anything else? HendrikAhttps://www.blogger.com/profile/13474837490556182526noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-15722066654282216862016-11-18T20:23:11.120+13:002016-11-18T20:23:11.120+13:00Hi,
i solved this problem by adding 64bit version ...Hi,<br />i solved this problem by adding 64bit version of MvxSockX_SVR.dll(name of dll file -MvxSockX_SVRx64.dll,MvxSockNx64).farhathttps://www.blogger.com/profile/12641023433827468198noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-79876783385433308102016-11-18T03:25:16.713+13:002016-11-18T03:25:16.713+13:00HI,
i am getting 429 activex error-on "sock.M...HI,<br />i am getting 429 activex error-on "sock.MvxSockConnect" the same code working fine if i used 32bit excel.<br />but it dont work with 64bit ms office(excel).<br />i tried all possible way including register dll file.<br />it seems MvxSockX_SVR.dll file does not support 64bit excel while create com and activex component.<br />i searched a lot to change 32bit dll files in 64bit but not successes.<br /><br />as per my search these dll file written in c language so it is difficult to me write code in c language.<br /><br />please help with workaround(except 32bit MSoffice installer).<br /><br />appropriate quick response, please help as i require it urgently.<br /><br />Thanks <br /> farhathttps://www.blogger.com/profile/12641023433827468198noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-6647725905524199472016-08-24T23:57:48.639+12:002016-08-24T23:57:48.639+12:00I had the same issue. Trick is that the MvxAPI pac...I had the same issue. Trick is that the MvxAPI package has to be installed into C:\Program Files\MvxAPI not to root of C: drive. Once this package is installed in "Program Files" you have to manually register library MvxSockX_SVR.dll via command "regsvr32 C:\Program Files\MvxApi\MvxSockX_SVR.dll" and that´s it.Anonymoushttps://www.blogger.com/profile/02539391150540691014noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-91327138313916453482016-02-25T22:07:47.926+13:002016-02-25T22:07:47.926+13:00I have the same problem with OLEDB/ODBC connection...I have the same problem with OLEDB/ODBC connection error after using the API.<br />Commenting the mvxSockClose seems to prevent the error, but is it a best practice ?Floppynoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-28893478046972096252016-02-18T12:59:44.435+13:002016-02-18T12:59:44.435+13:00I created a similar tool a few years back :-)I created a similar tool a few years back :-)Al Johnsonhttps://www.blogger.com/profile/12728083455378232837noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-68987006624087198592016-01-22T11:13:52.159+13:002016-01-22T11:13:52.159+13:00Hello all, my post is litle bit late but all the i...Hello all, my post is litle bit late but all the info about the API's is available when you install the M3 API Tools. I created an Excel Workbook that acts like a shell around the API's. I need around 5 persons to test it in different environments. Here is my site: <br />http://adsl429174.wix.com/upload-m3-apiAnonymoushttps://www.blogger.com/profile/08961700988319728942noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-91080717332553100472015-12-18T11:08:03.114+13:002015-12-18T11:08:03.114+13:00You may need to register the dll.
e.g.
C:\MvxAPI&...You may need to register the dll.<br />e.g.<br /><br />C:\MvxAPI>regsvr32 MvxSockX_SVR.dllAl Johnsonhttps://www.blogger.com/profile/12728083455378232837noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-23494291639085071762014-07-11T23:28:27.461+12:002014-07-11T23:28:27.461+12:00MRS001MRS001Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-39110791508991753922014-07-01T00:56:15.012+12:002014-07-01T00:56:15.012+12:00Hi is there a API documentasion for Movex/M3? Wher...Hi is there a API documentasion for Movex/M3? Where can I find it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-38992026300443332372014-05-07T22:02:00.861+12:002014-05-07T22:02:00.861+12:00Hello El Kondor, are you solve this problem? I hav...Hello El Kondor, are you solve this problem? I have the same message error with Movex API "rc = Sock.MvxSockConnect("192.168.100.130", "16800", "M3SRVADM", "M3LAWSON", "PPS370MI", "")"<br /><br />Thank you for your reply<br /><br />JosepAnonymoushttps://www.blogger.com/profile/02542299527618924648noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-57094366621333054312014-01-17T03:59:26.870+13:002014-01-17T03:59:26.870+13:00Hello, I'm trying to test your solution in my ...Hello, I'm trying to test your solution in my M3 10 version. I followed all your instruction in Excel but when I try to run the code I receive the Error 429: ActiveX Component can't create object. on the instruction "rc = Sock.MvxSockConnect("AS400", 16800, "User", "password", "PDS090MI", "")". Can you figured out what am I doing wrong?<br />Thank you for your replyEl Kondorhttps://www.blogger.com/profile/05383692021374812743noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-49968223670064564482012-04-19T15:39:49.493+12:002012-04-19T15:39:49.493+12:00Thanks a Lot.. Its Really Helpful. :)Thanks a Lot.. Its Really Helpful. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-30225491233079271772011-10-13T20:13:44.696+13:002011-10-13T20:13:44.696+13:00Closing the API connection after having performed ...Closing the API connection after having performed the ODBC call seams to work better ! Thanks a lot.<br />Cheers, Sébastien.Sebhttps://www.blogger.com/profile/06796924453012749624noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-22851226956240913682011-10-13T07:38:27.295+13:002011-10-13T07:38:27.295+13:00I have never had this problem before. However, wh...I have never had this problem before. However, why don't you try leaving the API connection open, perform the ODBC call, then close the API connection. Cheers, Al.Alhttps://www.blogger.com/profile/06469996988980345250noreply@blogger.comtag:blogger.com,1999:blog-913534236606046272.post-14242804625243772512011-10-13T04:36:16.878+13:002011-10-13T04:36:16.878+13:00I also have the problem with ODBC connection after...I also have the problem with ODBC connection after a MvxSockClose. Did anybody have found a solution for that? (I've tried to wait 1 sec before connecting but it doesn't work)Sebhttps://www.blogger.com/profile/06796924453012749624noreply@blogger.com