Thanks for you reply Panagoitis!
> First thing that comes to mind is checking if timestamp used by nxlog is
properly formatted. What happens if you run the query manually?
How do you mean "manually"? We have ran the query from PowerShell
successfully.
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
Does this datetime format come from nxlog debug log?
The DateTime format comes from MS SQL Server. Displayed in Editor window.
The NXLog debug log only contains the error message "Invalid precision
value".
NXLog is successful when we change the query and use AdminId as id.
Any more hints what can be wrong?
/ Erik
2017-03-01 22:34 GMT+01:00 Panagiotis Atmatzidis <a...@convalesco.org>:
> Hi Eric,
>
> On 1 Mar 2017, at 22:10, Erik Boström <erik.g.bost...@gmail.com> wrote:
>
> 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)”.
>
>
> MS documentation[1] for HYA104 says:
>
> "The value specified for the argument ColumnSize or DecimalDigits was
> outside the range of values supported by the data source for a column of
> the SQL data type specified by the ParameterType argument.”
>
> First thing that comes to mind is checking if timestamp used by nxlog is
> properly formatted. What happens if you run the query manually?
>
>
> 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
>
>
> Does this datetime format come from nxlog debug log?
>
> Thanks for any assistance.
>
> Kind regards, Erik
>
>
>
> [1] https://docs.microsoft.com/en-us/sql/odbc/reference/
> syntax/sqlbindparameter-function
>
> --
> Panagiotis (atmosx) Atmatzidis
>
> email: a...@convalesco.org
> URL: http://www.convalesco.org
> GnuPG ID: 0x1A7BFEC5
> gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5
>
> "Everyone thinks of changing the world, but no one thinks of changing
> himself.” - Leo Tolstoy
>
>
>
>
>
>
>
------------------------------------------------------------------------------
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
