https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354257#M42841 <P>Try using this syntax:</P> <P>|dbxquery connection="$ConnectionName$" shortnames=t query="SELECT * FROM $Database.Schema.Table$"</P> Tue, 07 Nov 2017 21:18:44 GMT bhicks32 2017-11-07T21:18:44Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354254#M42838 <P>Hello,</P> <P>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:</P> <P>Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.</P> <P>Thank you for your help.</P> Tue, 07 Nov 2017 17:05:55 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354254#M42838 UNI_Splunk 2017-11-07T17:05:55Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354255#M42839 <P>Hello,</P> <P>Can you provide the search query you are currently using?</P> <P>Thanks.</P> Tue, 07 Nov 2017 20:11:15 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354255#M42839 bhicks32 2017-11-07T20:11:15Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354256#M42840 <P>SELECT * FROM "Database"."Shema"."Table"</P> Tue, 07 Nov 2017 21:10:04 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354256#M42840 UNI_Splunk 2017-11-07T21:10:04Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354257#M42841 <P>Try using this syntax:</P> <P>|dbxquery connection="$ConnectionName$" shortnames=t query="SELECT * FROM $Database.Schema.Table$"</P> Tue, 07 Nov 2017 21:18:44 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354257#M42841 bhicks32 2017-11-07T21:18:44Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354258#M42842 <P>Alway the same error </P> <P>Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255.</P> Wed, 08 Nov 2017 02:44:44 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-3-1-1-Error-in-dbxquery-command-with-Server/m-p/354258#M42842 UNI_Splunk 2017-11-08T02:44:44Z