Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.