Hi PickleRick Thank you for your reply. I am running Splunk Enterprise 10.4 with DB Connect 4.3. I have downloaded UCanAccess 5.0.1 and attempted the following: - Within the DB Connect app, added the UCanAccess drivers (5 JAR files) to the drivers folder. In the local folder, created a db_connection_types.conf and added the following: [ucanaccess]
displayName = Microsoft Access
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = net.ucanaccess.jdbc.UcanaccessDriver
jdbcUrlFormat = jdbc:ucanaccess://<database>
port = 0
testQuery = SELECT 1 I have also done this without the serviceClass line. Anything else causes an errors with SplunkWeb. - I have also created a separate app with a default folder and db_connection_types.conf as above within it. Also within this app I created lib folder, placed the drivers (JAR files) within that. Alternatively I have tried creating a subfolder such as dbxdrivers and placed the drivers there, in an attempt to mimic the SQL drivers from Splunk. Any thoughts?
... View more