Splunk DB Connect 3.1.1 -- Error in 'dbxquery' command with Server SQL 2008 R2

[UNI_Splunk]

Hello,

I am presently putting in place a proof of concept of Splunk Enterprise. I'm trying to access a Microsoft SQL 2008R2 server with the DB Connect addons, The conection seems to work because I see my database list and select one. When I just want to make a select on a table to extract the data, here is the error that I get:

Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.

Thank you for your help.

[bhicks32 · Accepted solution]

Hello,

Can you provide the search query you are currently using?

Thanks.

[bhicks32]

Try using this syntax:

|dbxquery connection="$ConnectionName$" shortnames=t query="SELECT * FROM $Database.Schema.Table$"

[UNI_Splunk]

Alway the same error

Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.

[UNI_Splunk]

SELECT * FROM "Database"."Shema"."Table"