All Apps and Add-ons
Highlighted

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

New Member

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.

0 Karma
Highlighted

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

Explorer

Hello,

Can you provide the search query you are currently using?

Thanks.

View solution in original post

0 Karma
Highlighted

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

New Member

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

0 Karma
Highlighted

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

Explorer

Try using this syntax:

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

0 Karma
Highlighted

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

New Member

Alway the same error

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

0 Karma