Ask questions. Get answers. Find technical product solutions from passionate experts in the NXLog community.
MS SQL SavePos is not used
Robert000 created
Hello, I send data from MS SQL to SysLog, i use im_dbi+freetds and even if i have set SavePos it always starts from the beginning at startup.
After starting the service
2022-02-15 11:19:32 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > -1
When it is already running, the id is used.
2022-02-15 11:19:35 DEBUG im_dbi sql: SELECT * FROM *** WHERE id > 116407
-rw-r--r-- 1 nxlog nxlog 64 Feb 15 11:20 configcache.dat
OS: Ubuntu 20.04, last NXLog CE 3.0.2272
<Input sql_send>
Module im_dbi
SavePos TRUE
PollInterval 10
Driver freetds
Option host ***
Option username ***
Option password ***
Option dbname ***
SQL SELECT * FROM ***
</Input>
Robert000 created