All Apps and Add-ons

DBX Connection to Microsoft Access

kmattern
Builder

I would like to use the DBX connector to query a numberof Microsoft Access databases via ODBC. Is this possible. I set up an ODBC System DSN on my Splunk server to point to the mdb file. When I click the "Fetch Database Names" button I get the mdb in the list. I select that and click on Save. that generates teh following message:

Encountered the following error while trying to save: In handler 'dbx-databases': Error connecting to database: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Am I missing something or is Access not supported? I have no problem talking to a SQL Server fifty miles away.

1 Solution

ziegfried
Influencer

If you set up the System DSN with a *.mdb file on a network-mapped/mounted drive (ie. not a local drive) and the Splunk Service is running under the local system account it may not have permission to access this file.

Please try setting up a System DSN with a mdb file on a local drive (eg. C:). If that works, you might be able to adjust permissions on the mapped drive to allow access from the local system account.

View solution in original post

ziegfried
Influencer

If you set up the System DSN with a *.mdb file on a network-mapped/mounted drive (ie. not a local drive) and the Splunk Service is running under the local system account it may not have permission to access this file.

Please try setting up a System DSN with a mdb file on a local drive (eg. C:). If that works, you might be able to adjust permissions on the mapped drive to allow access from the local system account.

kmattern
Builder

Thanks. It was indeed permissions on the shared drive.

0 Karma

DaveSavage
Builder

I didn't see M/soft access in the supported list BUT the plug-in is v flexible...providing the custom properties are considered, and ODBC / JDBC has been placed in the $SPLUNK_HOME/etc/apps/dbx/bin/lib.
Sounds 'physical' with the path error...

0 Karma
Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...