Accessing Microsoft WID database using Splunk DB Connect

[mwpalmer]

Has anyone been able to use Splunk DB Connect to access a Microsoft WID database on a Windows 2012 server?

The database can only be accessed by named pipes and it appears that Splunk DB connect cannot connect directly so trying to use a ODBC connection with a sql native client installed. So far it's failing to connect.

Found the following error message.

From the log file C:\Program Files\Splunk\var\log\splunk\dbx when validating the connection parameters.

2013-04-03 10:06:22.791 dbx7114:INFO:BridgeSession - Executing Bridge command: BridgeExecutionInfo{className=com.splunk.dbx.sql.validate.DatabaseValidator}
2013-04-03 10:06:22.839 dbx7114:ERROR:BridgeSession - Exception occured while executing command: java.lang.UnsupportedOperationException
java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcConnection.isValid(Unknown Source)
at com.splunk.dbx.sql.Database.validateConnection(Database.java:411)
at com.splunk.dbx.sql.Database.validateConnectionParameters(Database.java:378)
at com.splunk.dbx.sql.validate.DatabaseValidator.invoke(DatabaseValidator.java:29)
at com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:92)
at com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:30)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2013-04-03 10:06:22.839 dbx7114:INFO:BridgeSession - Execution finished in duration=48 ms with status=1
2013-04-03 10:06:22.869 dbx7114:INFO:ExecutionContext - Execution finished in duration=78 ms

[mwpalmer]

I still don't have any answers on this 😞

[vince2010091]

Hello,

Anybody got an update on this ?

Regards,