SQLBindPatrameter error - Page 1 | Log collection solutions

#1 tothr2 2 years ago

<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

Permalink

#2 carlos.caro Nxlog ✓ 1 year ago

#1 tothr2

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

Hi Richard,

Since your question refers to the im_odbc input module which is available on NXLog EE only, please consider our Enterprise Support Services, open a ticket and our team will gladly assist you. Additionally, you can access the online documentation for more information.

Thanks,
Carlos.