topic Re: Access DB through Microsoft SQL JDBC connector? in Data & Schema Discussions

Access DB through Microsoft SQL JDBC connector?

marcpaige — Tue, 04 Apr 2023 17:20:26 GMT

Can an Access DB be added as a Microsoft SQL database?

Re: Access DB through Microsoft SQL JDBC connector?

SreehariReddy — Thu, 06 Apr 2023 16:00:07 GMT

Hi Marcpaige,

No, Access DB can not be connected as MS SQL database connector.

However, with the help of Incorta Data Connector's, 'Custom CData' we can connect. And for connecting to Access, the Custom CData Connector requires a JAR file of Access JDBC driver.

More details can be found here: https://docs.incorta.com/cloud/references-connectors-custom-cdata

Thanks

Sreehari Reddy

Re: Access DB through Microsoft SQL JDBC connector?

marcpaige — Thu, 06 Apr 2023 16:35:33 GMT

Thanks Sreehari. Do you have any more information on the JAR file for Access?