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.