Description:

Getting Error : "[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" 
while creating MS Access ODBC Data Source in TIBCO Data Virtualization

Error Message:
Unable to obtain a connection from the connection pool for data source "/shared/msaccessnetwork".
SQL State = S1009  SQL Error Code = -1023  [data-2911001]
Cause: [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.
com.compositesw.cdms.webapi.WebapiException: Unable to obtain a connection from the connection pool for data source "/shared/msaccessnetwork".
SQL State = S1009  SQL Error Code = -1023  [data-2911001]
Cause: [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.
[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.
Version Information: Studio 7.0.2.00.00, Build ID Build: f8f3b07-2016-02-26, Server 7.0.2.00.00b

Getting Error : "[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"

All Supported Operating Systems

Use the fully qualified name in the database name when creating the DSN in ODBC Administator as shown in attached snapshot (DSNDatabaseName.PNG)

\\<MachineName>\<foldername>\Filename

Example : \\SPOTSUPTSS55\msaccess\ADS_MS_Access.accdb