MSSQL

3
responses

jacas

Trouble with NXlog Enterprise and SQL ODBC audit file.

Hello NXlog world!
I'm having some challenges to pull data from a SQL 2012 (running on W2K16) database using the im-odbc connector.
This is my input:

nxlog,
im_odbc,
MSSQL,

AskedOctober 16, 2019 - 8:58pm

2
responses

Lauxna

im_odbc - incorrect syntax and ERROR id column not found or its type is unsupported

Hello,

I hope someone can help me. I need to pick application logs from a few MSSQL database tables. 3 of 4 works perfect -there are no issues getting the data, but one table is causing issues.

Below you can see input I am using. As you can see, there is one column name with the Danish character, however, I am not sure if only this is causing trouble. The error I receive is:

im_odbc,
MSSQL,

AskedApril 9, 2019 - 11:11am

You are here

MSSQL

Trouble with NXlog Enterprise and SQL ODBC audit file.

im_odbc - incorrect syntax and ERROR id column not found or its type is unsupported