Hi,
We are evaluating NXLog Enterprise Edition and it works fine except from
reading from a table in MS SQL Server.
The error message we get is:
”ERROR SQLBindParameter failed, HY104:2:0[Microsoft][SQL Server Native
Client 10.0] Invalid precision value (odbc error code: -1)”.
Our NXLog configuration:
<Input ODBC>
Module im_odbc
Connectionstring dsn=DSNNAME;database=Databasename;
SQL Select StartTime as id, AdminId from [Databasename].[view].[view] Where
StartTime > ?
Savepos TRUE
IdIsTimestamp TRUE
</Input>
AdminId is an Int datatype
StartTime is a datetime. Example value is 2016-09-16 08:42:45.433
Thanks for any assistance.
Kind regards, Erik
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
nxlog-ce-users mailing list
nxlog-ce-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nxlog-ce-users
