Hi Team,
I am trying to connect to by Oracle DB. i saw lot of post about the same. However am not able to connect. Kindly help with the same. It will be helpful if we have document on the same.
Am using Microsoft ODBC Data Source (ODBC)
In driver: “driver={Microsoft ODBC for Oracle};server=xxxx;uid=xxx; pwd=xxx"
getting Error IM002. Datasource Name not found.
Kindly help. We have lot of Oracle DB automation on hold.
Hi,
Do you have:
the ODBC driver installed in a version compatible with the DB and do you have the Oracle Instant Client installed?
a User DSN created?
Created environment variables for the account?
ORACLE_HOME = C:\app\product\11.2.0\client_1
TNS_ADMIN = C:\app\product\11.2.0\client_1\network\admin
Added tnsnames.ora in: C:\app\product\11.2.0\client_1\network\admin ?
No what mentioned i dont have. Cna you guide me ?
My IT department deals with this.
All I can tell you is that you need to install on a machine (dev, robot) ODBC driver that will be compatible with the Oracle database version on the database server.
The rest of the setup steps are to go through my question list from the previous post:
ashokkarale
manasrlenka25