https://forge.codesys.com/forge/talk/Engineering/thread/01f2196599/2020-02-27T14:09:15.286000ZRecent posts to codesys mysql connection for free2020-02-27T14:09:15.286000Z2020-02-27T14:09:15.286000Zeschwellingerhttps://forge.codesys.com/u/eschwellinger/https://forge.codesys.com79a626b811194d5084c4c9ced8de921f3eb95a88

<div class="markdown_content"><p>Hi,<br/> this has nothing to do with the CODESYS development system,<br/> I would recommend to use always the 64Bit Version for this.</p> <p>His problem is, that he try to use the RTE plc as 64bit version, as result he get this errors.<br/> probably these mysql libs need to be adapted to be platform indempendent (usable for 32bit and 64bit runtime systems)</p> <p>Use interface lib CmpError2 and SysTypes2 instead of CmpError and SysTypes, but namespaces are the same: RTS_INVALID_HANDLE is now in SysTypes and no longer in CmpErrors! There may be more interface libs that need to be raised.<br/> Replace 32 Bit Pointer Variables with 64 Bit (__XWORD or Alias XWORD) </p> <p>BR<br/> Edwin</p></div>

2020-02-27T14:09:14.969000Z2020-02-27T14:09:14.969000ZdFxhttps://forge.codesys.com/u/dfx/https://forge.codesys.comb78356107f7b3ed93febb0d5cd852c30a04ba764

<div class="markdown_content"><p>You changed the target arch going for RTE 64bits. Just stay in 32 bits then … <a class="" href="https://store.codesys.com/codesys.html?___store=en#All%20versions" rel="nofollow">https://store.codesys.com/codesys.html?___store=en#All%20versions</a></p></div>

2020-02-27T14:09:14.007000Z2020-02-27T14:09:14.007000Zmos89@yahoo.comhttps://forge.codesys.com/u/mos89-yahoo-com/https://forge.codesys.com73434992ba2b726f11c327983494fa417a820fb6

<div class="markdown_content"><blockquote> <p><strong>dFx hat geschrieben:</strong><br/> That may be because DWORD is 32 bits, and you are working on 64bits version, which suppose that pointers are 64 bits long.<br/> Change for a 32 bit version or adapt the code to be 64 bits compatible.</p> </blockquote> <p>hi,</p> <p>As i see each time there is an update code is not any more portable, i understand that 32 to 64 bit is a big change but the goal of codesys is to keep the code independant of hardware, or do i miss something</p></div>

2020-02-27T14:09:13.684000Z2020-02-27T14:09:13.684000ZdFxhttps://forge.codesys.com/u/dfx/https://forge.codesys.com8d9d89d47cdae288569064fb3839eb10675eef97

<div class="markdown_content"><p>That may be because DWORD is 32 bits, and you are working on 64bits version, which suppose that pointers are 64 bits long.<br/> Change for a 32 bit version or adapt the code to be 64 bits compatible.</p></div>

2020-02-27T14:09:13.360000Z2020-02-27T14:09:13.360000Zmos89@yahoo.comhttps://forge.codesys.com/u/mos89-yahoo-com/https://forge.codesys.comf92109da8a6ec260326872db3da08090a6744713

<div class="markdown_content"><p>Hi <br/> I found a sample programm done for raspberry Pi to connect to mysql DB:<br/> <a class="" href="https://www.youtube.com/watch?v=CxTWELke8dU" rel="nofollow">https://www.youtube.com/watch?v=CxTWELke8dU</a><br/> from PASK PLC</p> <p>I try to test it in my application on RTE 64 bit and i have some error on Precompile files<br/> C0032: Cannot convert type 'POINTER TO BYTE' to type 'DWORD'<br/> C0032: Cannot convert type 'POINTER TO BYTE' to type 'DWORD'<br/> C0032: Cannot convert type 'DWORD' to type 'POINTER TO BYTE'</p> <p>Any idea ?</p></div>