Splunk Enterprise

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

Omar
Explorer

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
Get Updates on the Splunk Community!

Customer Experience | Splunk 2024: New Onboarding Resources

In 2023, we were routinely reminded that the digital world is ever-evolving and susceptible to new ...

Celebrate CX Day with Splunk: Take our interactive quiz, join our LinkedIn Live ...

Today and every day, Splunk celebrates the importance of customer experience throughout our product, ...

How to Get Started with Splunk Data Management Pipeline Builders (Edge Processor & ...

If you want to gain full control over your growing data volumes, check out Splunk’s Data Management pipeline ...