Splunk Enterprise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question

Why am I receiving this exception on Splunk DB Connect - mssql - com.microsoft.sqlserver.jdbc.SQLServerException

Omar
Explorer
‎04-18-2022 01:03 AM

Hello, dears Splunkers,

I'm facing a problem when trying to run a query on Splunk DB Connect to mssql database, I'm connecting to MS SQL server using a connection type: MS-SQL Server Using MS Generic Driver 

I get this Exception: 
com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
No results found.

my Splunk DB Connect is on version: 3.8.0 & Splunk DBX Add-on for Microsoft SQL Server JDBC is on version: 1.1.0

Labels (2)
0 Karma
Reply
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...