I am trying to connect Database for the first time from my laptop. How to setup DB/ODBC or any perquisite setup before start working in DB. I know the use of all the activities in Studio to connect DB and perform operation, but need detailed information about the Prerequisite. Please note DB is not present in local machine, but I need to access it from local machine.
ERROR : Data source name not found and no default driver specified
- Prerequisite for DB Connection (Before working on connect/disconnect etc. activities?
- What details of DB are required? (Like hostaname, UN, PW or type of Server etc.)?