Hi,
I am getting 'ORA 12154: TNS could not resolve the connect identifier specified' while trying to connect to oracle DSN through excel VB.
I am using below statement in excel VB to call DSN.
cnn.Open "OCI_DRMPHUB_DSN", "DRMHUB_RO_BKRHFMJE", "pass"
I tested DSN and the connection was successful. Attached the screenshot.
Please let me know what is missing that I am getting ORA 12154 error.
Thanks in advance