im_odbc ConnectionString question
ghostcat
Hello,
I am attempting to use the im_odbc module to gather table data from mssql into nagios log server.
conf snippet
<Input in>
Module im_odbc
ConnectionString DSN=mysql://USERNAME:PASSWORD@IPADDRESS:PORT;database=DATABASENAME;
SQL Select RecordNumber as id, DateOccured as EventTime, data as Message from logtable WHERE RecordNumber > ?
SavePos TRUE
</Input>
<Output out>
Module om_tcp
Host IPADDRESS
Port 1337
OutputType Binary
</Output>
<Route 1>
Path in => out
</Route>
Error
ERROR im_odbc couldn't connect to the database, IM010:1:0:[Microsoft][ODBC Driver Manager] Data source name too long
Please Help!
Thanks
GC.
