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"
Article ID: KB0079226
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All versions |
Description
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
Environment
Resolution
\\<MachineName>\<foldername>\Filename
Example : \\SPOTSUPTSS55\msaccess\ADS_MS_Access.accdb
Issue/Introduction
Feedback
