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!

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...

Join Us at the Builder Bar at .conf24 – Empowering Innovation and Collaboration

What is the Builder Bar? The Builder Bar is more than just a place; it's a hub of creativity, collaboration, ...

Combine Multiline Logs into a Single Event with SOCK - a Guide for Advanced Users

This article is the continuation of the “Combine multiline logs into a single event with SOCK - a step-by-step ...