Access connection string

Andres Esteban 156 Puntos de reputación
2024-01-29T17:30:13.4166667+00:00

I am trying to connect an Access database I have in OneDrive to Azure Data Factory so I can copy it to my Data WareHouse. I have created a Self-Hosted integration runtime environment. However, when I try to connect my database I am not able to give it the correct connection string: I have tried with: Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=https://onedrive.com/path_for_your_database.accdb; I always get a failure and the last one I got is: ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver]General error Cannot open registry key 'Temporary (volatile) Ace DSN for process XXXXX'. ERROR [IM006] [Microsoft] [ODBC Driver Manager] SQLSetConnectAttr Driver Error ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver]General error Cannot open key 'Temporary (volatile) Ace DSN for process XXXXX' in the Registry. ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver] Microsoft Access database engine cannot open or write to the '(unknown)' file. Another user has already opened it exclusively or needs permission to view and write data. Could someone help me to know how to create the correct connection string when hosted in a shared folder on one drive?

0 comentarios No hay comentarios
{count} votos

Su respuesta

Las respuestas se pueden marcar como respuestas aceptadas por el autor de la pregunta, lo que ayuda a los usuarios a conocer la respuesta que resolvió el problema del autor.