0
responses

2022-02-08 04:16:56 INFO [CORE|main] nxlog-5.4.7313-trial started on Windows
2022-02-08 04:16:56 INFO [im_odbc|reading_integer_id] im_odbc successfully connected to the database
2022-02-08 04:16:56 ERROR [im_odbc|reading_integer_id] SQLBindParameter failed, HY104:2:0:[Microsoft][ODBC SQL Server Driver]Invalid precision value (odbc error code: -1)

<Input reading_integer_id>
Module im_odbc
SavePos True
idType integer
ConnectionString Driver={SQL Server}; Server=xxxxxxxx;Database=SCSPDB; \
UID=xxxxt;PWD=xxxxxx;
SQL SELECT Event_ID AS id, * FROM dbo.CSPEVENT_VW WHERE Event_ID > ?
Exec delete($id);
</Input>

Used CAST but still the same error

AskedFebruary 8, 2022 - 11:21am

Answers (0)