topic Receiving an Error while connecting MS Access DB via ODBC in Qlik Cloud in Data Movement & Streaming

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

Saranya_Durairaj — Wed, 19 Mar 2025 21:48:59 GMT

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

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

samuel898 — Wed, 31 Jul 2024 04:12:41 GMT

@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

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

goos_it — Thu, 26 Sep 2024 07:39:26 GMT

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

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

Sonja_Bauernfeind — Thu, 26 Sep 2024 10:49:23 GMT

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

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

NadiaB — Thu, 26 Sep 2024 12:50:31 GMT

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-failing-with-Please/ta-p/2135007

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

Hope it helps!