DBX Connection to Microsoft Access

[kmattern]

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.

[ziegfried · Accepted solution]

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]

Thanks. It was indeed permissions on the shared drive.

[DaveSavage]

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...