ODBC : The file is already described

delessinesb — Fri, 02 Apr 2021 08:53:57 GMT

Hello,

ODBC connectors are used to access different databases on different servers and it works well. On the other hand, when we try to connect to the "VMG_Gestion" database, we get the following error :

Connector connect error: SQL SqlState: S1000, ErrorCode:0, ErrorMsg: Le fichier Matériel_Type est déjà décrit.

IEWDHF=32.2

Module=WDHF

Version=22.0.85.1

Sorry, it's in french, but in summary : the file Matériel_Type is already described. We get this error directly with the "LIB CONNECT TO 'VMG_Gestion (prqlik_Ivanmieghem)';" instruction.

Namely that the file name "Matériel_Type" already exists in another database connected by another connexion VMG_Helpdesk.

Would you have an idea of how to fix this problem ? I tried to delete the VMG_Helpdesk connection, to recreate a new connection "VMG_Gestion2" but we still have the same error in adding it. Namely that the descritpion of the file "Matériel_Type" of the VMG_Helpdesk connection can be deleted, but I don't know how to do it...

Thank you for your help.

topic ODBC : The file is already described in Connectivity & Data Prep

ODBC : The file is already described