OK this is driving me nuts i am trying to setup a ODBC connector to an oracle 10.2.0.4.0 DB
I can connect to the DB by cmd line sqlplus username/password and run queries.
But i have downloaded the latest ODBC connector for oracle 11g (does that matter ?)
The field options i have to populate is
Datasource name:
description:
TNS service name
User ID
when i populate these fields i get the error above using the same username and password
here is my TNSnames.ora
# TNSNAMES.ORA generated for eHealth
EHRP-2E2-SITE1_EHEALTH=
(DESCRIPTION=
(ADDRESS= (PROTOCOL = TCP) (HOST= EHRP-2E2-SITE1)(PORT = 1521))
(CONNECT_DATA=(SID=EHEALTH))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EHEALTH))
)
(CONNECT_DATA=
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Help
Thanks.