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 <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
signature.asc
Description: Message signed with OpenPGP
------------------------------------------------------------------------------ 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
