Search the Community
Showing results for tags 'sql'.
Found 11 results
-
Hi All I am trying to connect Cognex OPC Server with Mircrosoft SQL Server (SMSS). Do you have any idea how to do that? I couldn't find relevant information online.
-
Hi everyone, I am new here, currently I am working with AVEVA System Platform SCADA project where SCADA Data need to upload to a database frequently. so I setup a server remotely with database and tables (using Microsoft SQL server Management Studio). and using AVEVA System Platform SQL Data object i made a connection to the remote database and table and also add Attributes same as table Column. now I don't know how to use this SQL Data Object in My SCADA, how can i make it automatically insert My SCADA Data (selected data) to Database Table. Please Help me.
-
TRENDS ARE NOT SHOWING ON MY FTVIEW SE V8 . AS DATALOG MODEL STARTS IT SHOWS UNABLE TO MAKE CONNECTION IN DIAGNOSTIC VIEWER . YOU CAN CHECK THE SCREENSHOT FOR THE SAME . I THINK DATALOG MODEL IS NOT ABLE TO CONNECT TO SQL DATABASE . WHAT MIGHT BE THE PROBLEM ? Please Help Guys .....
-
Hi all, I would like to logg data from Mitsubishi PLC to MSSQL via OPC Kepware, but I have issues to see values correctly I simulate Mitsubishi PLC on OPC, I see values on OPC client correctly ... but when I logg data to MSSQL db via DataLogger I have issues with data ... any of data are displaye as 0, string data as NULL ... What is wrong ? In attached files you can see datatypes on OPC and MSSQL. Thank you
-
Dear Everyone can help i have a batching system of about 12 materials and i need to generate a report for all batches in the day in runtime, i tried using SQL with Cicode but sometimes i can't find some material's data or to be Zeros. did any one here know a way to do that?? vijeo citect 7.4 thank you -
Hi All, I have a system contains 1 PLC mitsubishi Q series , 1 HMI Got2000. Now, I want get data from sql server and use it for my system. My plan: I use 1 PC connect sql server and transfer data from PC to HMI or PLC. As I know, Mitsubishi have tool MX component, can set value directly PLC. But I'm not sure. Can you have any idea, help me resolve my problem.?
-
I have an application in the Visu+ Scada System, from Phoenix Contact, which makes a query in the SQL Server 2014 database. While the database was empty, queries were made perfectly, after 4 months the database grew up absurdly and then stopped running the query, returning the following error: Query timeout exceeded. I have a general table with 210 variables being written every 20 seconds. The query is made by updating the parameters in another single row table, it generates a trigger that copies the requested query to a third table and it is plotted on a chart in the supervisory system. The error occurs when Visu+ sends the parameters to be updated in the second table, returning "Query timeout exceeded.". However, when I update directly through SQL Server, it updates, generates the trigger and performs the requested query. Could someone help me solve this timeout problem, please? Thank you very much in advance!! -
I'm very new to PLCs and this sort of thing, so bear with me... Right now I have an SQL server that contains data that I want available on an Allen Bradley PLC. I've already gotten the connection into KepServer working and it generated the tags from the data. I'm able to access all of the data and use it fine with an OPC Client that's on the computer, but I'm unsure of where to go from here. I want these tags populated on the PLC via this OPC server and to remain updated. How do I get the PLC to grab these tags and do that now that they're available via OPC? -
Hi, I work as an industrial programmer primarily dealing with Allen Bradley, Mitsubishi, and Omron PLC's as well as various peripheral devices. I would like to begin the process of learning computer programming as it pertains to the manufacturing industry. I'd like to learn how to write databases (SQL, etc) and VB apps and eventually I'd like to be able to write applications that can communicate with PLC's and other devices (although the last one would be a ways down the road). I have very little experience with computer programming so I don't really know where to start. What language should I learn first? What free software is available to learn with? What resources do you recommend I use? I've downloaded Visual Basic Express and found some introductory courses online that I've just started but if there is something else I should've started with I'm open to suggestions. Thanks -
I was just curious on which type of data historians are considered fast at retrieving historical data. For example, if I wanted to trend a tag at a one second interval to review an event that took place a year ago and compare that to the same tag in real-time, what historian does this the fastest?
-
Hi Friends, I am working on a small project that needs to log data from energy-meters (about 200) onto a SQL database. I have written a function for logging in Cicode that is connecting to a DSN with multiple tables. It gets the customer's Id, one by one in a loop from one table assigns the readings, and logs it to another table. Problem observed with my method is that the loop does not move beyond the first entry in the Cust_ID table. I suspect that there may be a need to use different handles for different tables. OR - The TagRead() function is blocking further execution of the loop. PS:- The use of SqlNext(hSql) has worked well in a similar function to load combo-boxes with All Cust_IDs. Something causes the While loop to end Greatly will appreciate any help in resolving the error. PS:- The use of SqlNext(hSql) has worked well in a similar function to load combo-boxes with All Cust_IDs. Something causes the While loop to end Greatly will appreciate any help in resolving the error.
