I have installed Oracle SQL Developer and I have created an MS access database called LD.accdb. I want to connect to my database with the Oracle SQL Developer. My OS is WIn 7 and I run MS Access 2010. I follow the steps as presented in the following link:
https://www.packtpub.com/books/content/ms-access-queries-oracle-sql-developer-12-tool
but when I test my connection from the SQL Developer (see after completing fig.13 in the link above) and test my connection, it fails with the following error message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
So I go to the ODBC Data Source Administrator (Control Panel-->Administrative Tools) and I have tried some things but I have not been successful making my connection successful. Can you help me on that? Thank you very much in advance.
