S7 and MySQL

Hedeby

Member

H

Join Date

Oct 2011

Location

Give

Posts

5

• Jan 9, 2012

• #1

Hello

Is it possible with SCL or a standard block to send and receive data from a MySQL server, via a CP 343-1 Lean card?

It supports TCP/IP connection, but do i need additional software for it to work. The server also supports php.

 

JesperMP

Lifetime Supporting Member + Moderator

Join Date

Feb 2003

Location

ᚴᚬᛒᛅᚾᚼᚬᚠᚾ

Posts

16,320

• Jan 9, 2012

• #2

Hej Lasse.

No, it is not directly possible with the CP343-1 LEAN as far as I know.

There is a special version of the CP343-1 called ERPC. It is a solution to send data directly to SQL databases:
http://www.plctalk.net/qanda/showthread.php?t=66351

 

Hedeby

Member

OP

H

Join Date

Oct 2011

Location

Give

Posts

5

• Jan 9, 2012

• #3

Yes, that one I know about, but it is expensive, and I already have a LEAN card, so I thought there might be a workaround...

 

JesperMP

Lifetime Supporting Member + Moderator

Join Date

Feb 2003

Location

ᚴᚬᛒᛅᚾᚼᚬᚠᚾ

Posts

16,320

• Jan 9, 2012

• #4

I think that you can send any kind low-level data to any partner via the send/receive interface.
For example, I know that someone have made their own Modbus TCP code that works without Siemens canned library.
But I also think it is a lot of work.

If you get any success with this, I would like to know

 

Hedeby

Member

OP

H

Join Date

Oct 2011

Location

Give

Posts

5

• Jan 9, 2012

• #5

I think I will go with the S7.Net lib from CodePlex.com, and make an ASP.NET app, that does the trick...

http://www.plctalk.net/qanda/showthread.php?t=65768