File used by another process on Tableau (cannot open file)

[simonaubertbd]

What happens?

Error message on Tableau when I try to read a duckdb database with ODBC. The only process that uses it seems to be Tableau itself !

To Reproduce

1/Create an odbc connection to a duckdb file

2/Try to connect to it on Tableau

Environment (please complete the following information):

• OS: Windows 10
• DuckDB Version: 0.4.0
• DuckDB Client: ODBC

Identity Disclosure:

• Full Name: Simon AUBERT
• Affiliation: B&D

[Mytherin]

@tiagokepe could you have a look?

[tiagokepe]

@tiagokepe could you have a look?

For sure, I will take a look at.

@simonaubertbd Could you provide the ODBC trace file?

[simonaubertbd]

Sure.

Please note I have the same issue with Alteryx : if I try to use the odbc connection with Alteryx, I have to totally close Alteryx to free the file. SQL.LOG

Best regards,

Simon

[djouallah]

same problem here, tried it with Tableau

[github-actions[bot]]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[simonaubertbd]

@tiagokepe Hello. Could you have a look again please?

[Mytherin]

Could you confirm the issue is still a problem with the latest version of DuckDB (v0.8.1)?

[simonaubertbd]

Hello @Mytherin

Yes, I can confirm that !

Does someone managed to use it ? Best regards,

Simon

[github-actions[bot]]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[simonaubertbd]

Hello @Mytherin sorry to bother you with that again. Any news?

[Mause]

What's the most recent version you've tried with?

[simonaubertbd]

@Mause DuckDB v0.9.2 3c695d7ba9 (last available) with the last ODBC driver (I guess but the version does not display in the odbc admin window) Tableau 2023.3 (the last available too)

But the error message has somehow evolved (sorry, I can't use the github code balise because of the backticks in the message itself

Unable to complete action class `anonymous namespace'::ConstructProtocolTask::Execute() caught std::exception: IO Error: Cannot open file "c:\users\saubert\onedrive - business & decision\documents\travail_duckdb\titi.duckdb": Le processus ne peut pas acc�der au fichier car ce fichier est utilis� par un autre processus.

Best regards,

Simon

[simonaubertbd]

@Mause Ok, I made some progress : I thought the error message comes from the fact that it is a folder that's linked to my onedrive. I copy/paste on my c:/ outside of my onedrive repository and I still have the message. here are my odbc trace logs SQL.LOG

[maiadegraaf]

The ODBC driver now accepts config arguments, including setting the database to READ_ONLY mode, as of https://github.com/duckdb/duckdb/pull/10692. This could potentially be a solution here.