TCP/IP data logger - storing events to different MSSQL tables

Started by mramo, December 05, 2010, 04:37:00 PM

Previous topic - Next topic

mramo

Hi all,

I'm using the Advanced TCP/IP data logger in a way that I'm receiving some event messages from another system via TCP port and storing them to the MS SQL database table (via ODBC connection). For one type of events everything works fine (I'm able to properly parse the data and store it into the table). The problem I have is that I'm receiving several different types of events from the same source which I'd need to store to specific tables within the SQL database. For each of the events I assume I'd need to create specific parsing rules and define binding rules in the ODBC connection module? The problem is that within the existing connection this is not possible and if I try to create a new connection towards the same IP on the same port it's not possible to configure it (which is logical). Is there some kind of plugin available for such cases which I'm not aware of or how should I configure this?

Thank you in advance for your answers.

Arthur Grasin

Unfortunately, our software can't write different events to different tables. You can implement this task using a stored procedure in MSSQL. The SQL Database Prof. plugin can call a stored procedure and the procedure will write data to a necessary table.
If you like my work, please take a few seconds and add feedback about our site or our software [here]