Create Access Data Connection

ashipp2010 — Wed, 15 Dec 2021 17:31:37 GMT

Good Morning,

Ihave a remote share that has an access database on it in the accdb format. I am trying to create a data connection to that access DB.

I installed the most recent ODCB drivers for Access, but when I try to add the file via ODBC it fails because it requires setting the file path via mapped drive, which isn't supported. Is there a way to set it directly to the share without mapping the drive? ie. \\servername\filename.accdb?

I also tried to add via Ole DB, but the connection failed. When I click test connection it throws the generic error "Connection failed".

Thanks for any feedback!

Re: Create Access Data Connection

Anil_Babu_Samineni — Sat, 31 Aug 2019 02:56:20 GMT

I may think this way, Create ODBC Driver for that for all nodes and use that driver to connect DB while creating connection in the script.

topic Re: Create Access Data Connection in Connectivity & Data Prep

Create Access Data Connection

Re: Create Access Data Connection