All Apps and Add-ons

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

UNI_Splunk
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
1 Solution

bhicks32
Explorer

Hello,

Can you provide the search query you are currently using?

Thanks.

View solution in original post

0 Karma

bhicks32
Explorer

Hello,

Can you provide the search query you are currently using?

Thanks.

0 Karma

bhicks32
Explorer

Try using this syntax:

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

0 Karma

UNI_Splunk
New Member

Alway the same error

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

0 Karma

UNI_Splunk
New Member

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

0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...