Receiving an Error while connecting MS Access DB via ODBC in Qlik Cloud

[Saranya_Durairaj]

Hi All,

Recently, we upgraded the data gateway to 1.6.7 on the DEV server.. After that, we are trying to connect to the MS access database via ODBC, but getting below error,

Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message:
Please check the values for Username‚ Password‚ Host and other properties. Description: General error - ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.

However, the same database connection working in Production server with version 1.6.6.

Kindly advice any solution for that.

Thanks,

Saranya

[samuel898]

---

@Saranya_Durairaj wrote:

Hi All,

Recently, we upgraded the data gateway to 1.6.7 on the DEV server.. After that, we are trying to connect to the MS access database via ODBC, but getting below error,

Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message:
Please check the values for Username‚ Password‚ Host and other properties. Description: General error - ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data. Spotify Pie

However, the same database connection working in Production server with version 1.6.6.

Kindly advice any solution for that.

Thanks,

Saranya

---

Hello,

I'm also facing this issue after upgrading the data gateway to 1.6.7. When trying to connect to the MS Access database via ODBC, I get an error stating that the database is either opened exclusively by another user or I need permission to view and write its data. The same connection works fine on the Production server with version 1.6.6. Any advice or solutions would be greatly appreciated.

Best regards,

samuel898

[goos_it]

Hi,

Some answer from the Qlik Support would be great here, because MS Access is not mentioned in Qlik Data Gateway specification at all. Is it possible to connect to this kind of DB or not, and if yes, how is it done? I get a similar error when trying to connect with 1.6.6 as OP describes. Maybe @Sonja_Bauernfeind or one of your colleagues can look into this?

BR Stephan

[Sonja_Bauernfeind]

Hello @goos_it 

I've reached out to our subject matter experts, though it may be necessary to log a ticket. 

Looking back at investigations on the same error, the root cause was always related to permissions. Specifically, permission issues related to writing data to a file when that data was stored on a share or a different drive. You'd need to verify the permissions.

All the best,
Sonja 

[NadiaB]

Hi @Saranya_Durairaj 

I was wondering if you have already ShowErrorDetailMessage enabled or ODBC debug level enable in your DAG ( ODBC_LOG_LEVEL=DEBUG in C:\ProgramData\Qlik\Gateway\<GATEWAY-INSTALL-DIR>\configuration.properties , the parameter is there it just need to be reconfigured)

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Data-Gateway-Direct-Access-Reloads-fail...

This error tends to be generic, but the ODBC logs can be more specific (include a longer more descriptive message).

Hope it helps!