How to connect a Mitsubishi PLC to an SQL Database

[@chanthong6835]

Can I use plc Mitsubishi FX series? And can receive from database real-time?

[@astonosoro600]

We been having communication timeouts any ideas why this keep happening?

[@sql4automation584]

Hi! There could be several reasons for that. Can you write us an email to [e-mail] so we can help you better? Thanks!

[@souradeepbasu2129]

Can we do the same with Oracle database sever?If yes what is the purpose of doing & how to program?

[@sql4automation584]

Hi Souradeep, yes Oracle should work. SQL4Automation can be used with all databases which support ODBC. To set it up you would just have to download the ODBC-Driver for the Oracle database and configure it in the ODBC manager (see 4:24). The rest of the programming should be the same in general.

[@ns435]

Hi. I want to connect about 50 PLCs with MSQL. Read and write to database. So, is this system stability? Because i use for industrial.

[@sql4automation584]

Hi! We haven't tested this many links with Mitsubishi on one connector, but it should work. You would need at least 50 links. It probably depends a lot on how much data you need to send and receive. If you do get performance problems you could always distribute the links on multiple connectors on different devices. The connections are very stable if configured correctly.

[@ns435]

@@sql4automation584 Thanks for your information. I took your sample to load the PLC FX5UC-32MT. But it shows an error so it can't be loaded. Lots of errors in that sample program. Do you have any way to correct those errors? GXW3 ver 1.105K.

[@sql4automation584]

@@ns435 Hi, can you contact us on [e-mail] so we can support you better? Maybe we could help you via TeamViewer or Teams. Thanks!

[@ns435]

@@sql4automation584 Dear Sir. I tried again with the PLC having new firmware and queried with SQL. When executing the commands for the first time, everything went smoothly. But when I tried to execute the command again, an issue occurred. SA4cofig: Test of connection plc failed. GXW3: error code H3401. Cause: Data that cannot be converted was input in an applied instruction. I have contacted you via email, please respond.

[@diegomartinez7209]

Hi, can be the connection with GX Works2 or only GX Works3

[@sql4automation584]

Hi, we've only tested it with GX Works3. So I'm afraid I don't know, if it works with GX Works2.

[@thanhpn7188]

Your solution so great! Can i test this code with simulator ? i can't find how to connect PLC simulator with LAN. can you help me for this test? thanks a lot!

[@sql4automation584]

Hi Thanh, thank you! I don't know a way to run this code without a physical PLC. But maybe if you ask Mitsubishi directly, they know if it's possible. If you can acquire a physical PLC however, I'm glad to give you some help if needed.