PLCSQL Link technical forum

Contact owners and managers

1–11 of 11

Please feel free to post any question you may have regarding PLCSQL Link to this support forum. Questions are welcome in English, German, Danish, Swedish and Norwegian.

Any feature requests or comments are welcome as well. You may also have a look around in the existing posts and answers.

0 selected

PLCSQL Link technical forum, f...@plcsql.com3

3/25/19

How do I insert data in a SQL table, that are not normalized, from the PLC?

This is the same file except for MYSQL

unread,

How do I insert data in a SQL table, that are not normalized, from the PLC?

This is the same file except for MYSQL

3/25/19

f...@plcsql.com

10/17/18

How do I create new recipe data in the MYSQL Server?

You can use the MYSQL Stored Procedure sp_SaveParams, which is included in the sample PLCSQL Link

unread,

How do I create new recipe data in the MYSQL Server?

You can use the MYSQL Stored Procedure sp_SaveParams, which is included in the sample PLCSQL Link

10/17/18

Anders Jorsal, f...@plcsql.com3

10/16/18

How do i denormalize the normalized log and recipe data to get them in a regular table?

Attached a Version to handle a View Generator in MySQL Workbench On Saturday, January 9, 2016 at 12:

unread,

How do i denormalize the normalized log and recipe data to get them in a regular table?

Attached a Version to handle a View Generator in MySQL Workbench On Saturday, January 9, 2016 at 12:

10/16/18

10/6/16

My logging from the PLC fails with the error code 3104: "Error converting data type nvarchar to real". How do I handle this?

A possible cause is, that you are trying to log a value that cannot be saved to the SQL Server. See

unread,

My logging from the PLC fails with the error code 3104: "Error converting data type nvarchar to real". How do I handle this?

A possible cause is, that you are trying to log a value that cannot be saved to the SQL Server. See

10/6/16

5/24/16

How do i retrieve data from a conventional table in the PLC?

Our default database structure included in the standard package is based on a normalized architecture

unread,

How do i retrieve data from a conventional table in the PLC?

Our default database structure included in the standard package is based on a normalized architecture

5/24/16

11/26/14

What does the different error/status codes from the PLCSQL Link controller mean?

Here is the complete list of possible error/status codes: 0: SQL_Controller - PLCSQL Link controller

unread,

What does the different error/status codes from the PLCSQL Link controller mean?

Here is the complete list of possible error/status codes: 0: SQL_Controller - PLCSQL Link controller

11/26/14

4/4/13

How do I create new recipe data in the SQL Server?

You can use the SQL Stored Procedure sp_SaveParams, which is included in the sample PLCSQL Link

unread,

How do I create new recipe data in the SQL Server?

You can use the SQL Stored Procedure sp_SaveParams, which is included in the sample PLCSQL Link

4/4/13

11/14/12

I am running my SQL server in VMware or other virtual software. How should i configure the network connection?

We advise you to use Bridge connection, this means the virtual machine will act like your physical

unread,

I am running my SQL server in VMware or other virtual software. How should i configure the network connection?

We advise you to use Bridge connection, this means the virtual machine will act like your physical

11/14/12

11/14/12

How do I Set up a connection to SQL server from a PLC with CP Card, e.g. CP343-1 or CP443-1?

To setup a TCP-IP communication with a SQL server you must use “Netpro”. In opposite to PLCs with

unread,

How do I Set up a connection to SQL server from a PLC with CP Card, e.g. CP343-1 or CP443-1?

To setup a TCP-IP communication with a SQL server you must use “Netpro”. In opposite to PLCs with

11/14/12

11/14/12

How do I get online with my PLC via Ethernet? How to set PG/PC Interface

To get online to the PLC you must set up PG/PC Interfac to the PCs Ethernet card using TCP-IP

unread,

How do I get online with my PLC via Ethernet? How to set PG/PC Interface

To get online to the PLC you must set up PG/PC Interfac to the PCs Ethernet card using TCP-IP

11/14/12

11/14/12

My operator panel is reporting address fault, and the Input / Output fields are showing ###. How do I reconnect tags to a new PLC?

The tags connection, defines which PLC to address. You need to reconnect the tags if the PLC model or

unread,

My operator panel is reporting address fault, and the Input / Output fields are showing ###. How do I reconnect tags to a new PLC?

The tags connection, defines which PLC to address. You need to reconnect the tags if the PLC model or

11/14/12

Search

Clear search

Close search

Google apps

Main menu