I need to connect to a MS Access DB that is on a server directory of a company network i.e. \server02\DINAMICO\DATI\EOSSRL\datixp.mdb
I made the new ODBC (both 64 and 32 versions) and in theory it work by itself.
I installed also AccessDatabaseEngine_2010_x64.exe as suggested on connection form.
Then I created a new connection into SC using first Generic ODBC , giving the name of ODBC created but SC gives me back this error when I click on test connection button
odbc_connect(): SQL 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., SQL state S1009 in SQLConnect
The ODBC is correct because if I try to use double or single quote around “\server02\DINAMICO\DATI\EOSSRL” it doesn’t work already on ODBC saving.
Then again I tried to use Ms Access specific connection type but the same error arises.
Is there a fix or workaround ? For me it’s unbelievable … but everyday there is a new issue …