AGG Software Forums
November 25, 2024, 03:29:15 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: TCP/IP data logger - storing events to different MSSQL tables  (Read 11954 times)
mramo
Newbie
*

Karma: +0/-0
Posts: 1


View Profile
« on: December 05, 2010, 07:37:00 PM »

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.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: June 20, 2013, 10:00:00 AM »

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.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines