Jump to content

Search the Community

Showing results for tags 'SQL'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Our Community
    • Come on in!
  • News and Announcements
    • Latest Release! UniLogic Spring 2020--Loadcell, BACnet IP Server and more!
    • VisiLogic:9.8.64 - Link to mobile app, Ladder: 2x the Space!
    • New!!! ***** U90 Ladder*****
  • UniStream HMI + PLC Programmable Controllers & UniLogic Software
    • UniStream: Hardware
    • UniLogic Software
    • UniLogic UDFBs
    • Industry 4.0, IioT, MQTT, OPC UA
  • Vision, Samba, Jazz and M90 PLC + HMIs & Software
    • Vision & Samba PLC + HMI Controllers & VisiLogic Software
    • Jazz, M91 PLCs and U90Ladder
  • Software Utilities
    • SD Card Suite
    • Remote Operator
    • Remote Access
    • DataXport and DataXls
    • UniDownloader
    • UniOPC
    • UniDDE
  • Utilities for .net and Visual Studio
    • Unitronics PCOM Protocol
    • COM Object ActiveX .dll
    • .NET driver
  • Project Design
    • ...I have a project...what hardware do I need?
  • User Application Stories
    • Just finished a great project?
  • Tips and Tricks
    • Best Programming Practices
    • Tips and Tricks
  • Job Board
    • Projects seeking Programmers
    • Programmers seeking Projects
  • General Discussion
    • We're Listening...
    • The Lounge
  • News and Announcements Copy


  • Community Calendar


  • Unitronics' Blog: PLCs, HMIs and more
  • Saragani's Blog
  • Simon's Blog
  • Ash Neilson's Blog
  • Joe Tauser's Blog
  • Unitronics en Español
  • Powered by AMPS
  • Alldrives UK's Blog
  • Unitronics, Howman Style
  • PLCNewbie's Blog
  • Telestar Automation Blog
  • Webinars Collection
  • Tim's Corner
  • Blog
  • TELESTAR (Italian)
  • i4 Automation
  • i4 Automation (UK)
  • Unistream UDFB's


  • From Headquarters: Sample Applications
    • From Headquarters: VisiLogic
    • From Unitronics: U90 Ladder applications
  • User-submitted Applications
    • From Users: VisiLogic applications
    • From Users: U90 Applications


  • Articles
    • Forum Integration
    • Frontpage
  • Pages
  • Miscellaneous
    • Databases
    • Templates
    • Media


  • New Features
  • Other

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 22 results

  1. Hello, I would like to push and retrieve data to and from the the internet directly from my Unistream. I tried to connect to a server on Amazon, a working database (MSSQL) we are using in another project. But when doing a simple query I get error: "20009 Unable to connect to data source Unable to connect: Adaptive server is unavailable or does not exists" Anyone here who could give me a hint on what I need to do? The Database is set up as "SQL Server" with IP-number and instance name, database name, user name and password. Another question is if I can use ot
  2. Hi All, I have a unistream pro to play with for a few weeks, thought id spend the time trying to use the SQL client functionality for the first time. I have followed the installation instructions in the help files for express 2012 and have downloaded one of the examples 'SUniStream_070_SQL' Is there any documentation on this particular example?
  3. Hi, I need help to tackle a problem, Cyclic i write data into an table, this works like a charm. However at random events there is some kind of data corruption. All 4 columns are written with a large number. When i Look into the PLC the data is 100% correct. Making a SQL trace data is incomming wrong, please refer at the attachement This is just in one of the 1000 times. Changing the write interval does not help. We use CAT6 shieleded cable. Thanks in advance!
  4. Hi All, I have created an stored procedure in an SQL server. I would like to create a table whith a variable name. EXEC CreateTable[:Test] It creates always a table with the same name. The name between brackets [] This Test parameter should be variable, how can I archieve this?
  5. Hi all Is it possible for the Unistream series to respond to an external SQL Query. I have a client that has a database that wants to request data from the PLC instead of the PLC pushing data to the database?
  6. Hello everyone, In the code below I`m targeting a database called t_lg202001 which refers to a log table of a specific year and month. In this case January 2020. See code below: SELECT a.EVTLGUID, a.DEVDT, a.USRID, c.NM, b.NM FROM t_lg202001 a JOIN t_evttyp b ON a.EVT = b.EVT JOIN t_usr c ON a.USRID = c.USRID WHERE a.USRID IS NOT NULL ORDER BY a.EVTLGUID DESC LIMIT 1; As my target table is going to be update every month as the years goes by I need to change this line of code for every single month and afterwards years. i.e: t_lg202001 = January 2020. t_lg202002
  7. Hello everybody, I'm new to the Unitronics world. I have to synchronize the PLC clock and the idea is to read the time zone and the UTC from the MySQL database and set the time with the Set PLC date/time elements. However, sometimes the updating functions hang, with the status 1, and date and times are not set. The tags RtcDateSql, RtcTimeSql and RtcTzFromSql contain the right values, and they are updated correctly everytime RtcQueryTrigger is pulled up. I have done some test, anyway I wasn't able to find the reason this function sometimes works and sometimes not. Am I doing someth
  8. Hello, I noticed that unilogic has a function named " SQL_QUERY " for executing SQL queries using c language. I can see that it needs to be passed an array of a struct called " SQLParamData_t ". This struct it seems that it has three fields: one for the data type, another one for the data length and finally a third for the data itself. From some try and error I deduced some of this data types values (I hope correctly): unsigned char 1 signed int 4 unsigned int 5 volatile char* 10 Any ideas where I can find the rest of them, for example the value for vola
  9. Hi guys, we need help for write data in SQL table , for build report. We don't be how type for use this variable. I try string (all types), but not work. In anexx my table where need write . Thanks in advance.
  10. Will the Unistream SQL drivers connect to MS SQL 2000 or am I just wasting my time? I can connect to MySQL 8.0 and SQLEXPRESS 14.0. (I know - just upgrade already...) Thanks, Norm
  11. Trying to connect to a Azure sql server running the latest version of SQL server. I can connect using telnet and SSMS no problems. The unistream can connect to a local host using sql express. However when i connect using the same info. I get error which is the pic attached. I am kinda at a impasse. So what server on the unistream line compatible with?
  12. Dear All, I am starting for the first time to work with DB in a server PC using SQL (SQL server) query. I am using the SQL example...all works fine...I do the connection...I create the table...I am able to insert, update, get and cancel the "info" with this DB...what I saw and I don't understood is that if I send a query to have some information refered at a specific ID (...WHERE employeID =?) and this ID is not present in the DB the query result, BIT about query success, is turned as "1" ...I was expecting that the "fail BIT" arise !? Maybe this is correct, sorry I don't know d
  13. Dear Friends, I require a sample program of SQL connection with UniStream PLC and how to run queries.
  14. Hello, I would like to connect my UniStream to the internet via Ethernet cable that is connected to my router. This is to send SQL statement to my SQL database. Right now I am able to download/upload ladder logic to the PLC via the current communication setup I mentioned. Is there any settings that I need to do before it is able to go online (internet) in order for me to send the SQL statement? Thank you.
  15. Any help on using the block for reading the data from data table into SQL rows would be appreciated. I could not find enough document on using this ladder element in the help section. I can read successfully execute the query and read the data from the database to the data table.
  16. I am trying to set up the connection between PLC and a local database for the first time. Tried many times but an unsuccessful attempt. I think I might be making mistake in configuring the connection parameters in UniLogic. In my case I am using SQL server. Can somebody help me to explain the database connection parameters? I have attached my settings below.
  17. Hi everybody, I'm struggling to make a controller to submit data from a controller USP-070-B10/B08 to a MySql Database that stays on Amanzon cloud. I made a project using Unilogic v 1.19.83 same as the one in the controller. Did the connections and queries I wanted but nothing happens. it looks like it's not communicating at all with the database. I'm not even seeing a connection in my server manager. There is any tutorial, hints or something somewhere to guide me (I attached some screens as well)? Thanks
  18. Hi, I'm using UniStream with UniLogic (19.2). I'm unsure on how to use the "SQL Query" function block. the "SQL Query" has 3 fields: Query - Input, SQL query to execute. Parameters - Input, query parameter Outputs - Output , query output When I write the next query: Insert into Agua (Tiempo) Values (T_Agua) How does the PLC knows the direction of the database? What do I put in the Parameters and Outputs fields? Is there any file or webinar that I can check regarding this topic?
  19. So. You may be smack in the middle of your first Smart Factory project...or you may be wondering what all the hype is about..or, you may be looking around for a brand of programmable controllers that will talk to an ERP SQL database. No matter what your particular scenario is, we invite you to attend our webinar to learn how easy it is to communicate data via SQL, from the production floor up to management levels using Unitronics All-in-One PLC + HMI controllers. To sign up, click here
  20. We invite you to take part in our webinar: SQL - Adding a Piece to the Industry 4.0 / Smart Factory Puzzle. UniStream PLC + HMI controllers support MS SQL and My SQL, server and can connect to SQL databases. This enables you to set up UniLogic to communicate SQL data ERP/MRP servers - sign up to learn how!
  21. Hello, Does Unilogic support data transfer to SQL server ? Thank's, Itzik.
  22. Is there any automated way to get data from a database such as SQL into a V350 in an automated way? It would be nice to go from an external database into a Data Table. Anyone with experience in this area?
  • Create New...