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!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...