Writing to and reading from databases on servers

[racrowd]

This is something that we are wanting to implement, but I don't have a clue where to start.  I'm building test equipment for our product and I want to eventually be able to gather the test parameters from a database on a server and write the results to another database.  I have a very very basic concept regarding databases, so I was wondering if anybody could provide some help on how to implement this and where to start.  I'm using H2-DM1E.  Thanks in advanced.

[plcnut]

What type of database is it? How much data are you moving at a time? Do you have IIS (Internet Information Services) or possibly WAMP/XAMP on your PC?

If you are starting from scratch on server end, then I would recommend downloading Microsoft Visual Studio Community Edition (it is fully functional and free). You can use it to program your server end communications, and launch it to your IIS server on the PC. This is enabled by simply going in to your 'Add/Remove Programs'>>Turn Windows Features on or off, and then select Internet Information Services, including the Web management tools, as well as World Wide Web Services. Once this is done, then you can begin to build your protocol.

Whenever you get started, then please post back, and I/we will try to help you get it going.



...There is one other very simple option: You can run the Do-more Logger an any PC on your network, and then use a STREAMOUT instruction to send the data to the logger and save it directly to a text/csv file automatically.

[racrowd]

What type of database is it? How much data are you moving at a time? Do you have IIS (Internet Information Services) or possibly WAMP/XAMP on your PC?

If you are starting from scratch on server end, then I would recommend downloading Microsoft Visual Studio Community Edition (it is fully functional and free). You can use it to program your server end communications, and launch it to your IIS server on the PC. This is enabled by simply going in to your 'Add/Remove Programs'>>Turn Windows Features on or off, and then select Internet Information Services, including the Web management tools, as well as World Wide Web Services. Once this is done, then you can begin to build your protocol.

Whenever you get started, then please post back, and I/we will try to help you get it going.



...There is one other very simple option: You can run the Do-more Logger an any PC on your network, and then use a STREAMOUT instruction to send the data to the logger and save it directly to a text/csv file automatically.

Thanks, this is very informative.  It will most likely be a sql database.  I'm thinking that it will be a mixture of about 20 different variables to record (floating point, strings, integers, and some bits).  Later will include pulling about 20 variables into the plc to setup the tests.

So IIS will be the tool for publishing the data in the database to a website?  That's pretty cool.  Alright, now that I know what I have to learn, it is time to go study.  Thanks again.