Unable to create Oracle-ODBC DSN under Windows 64 bit with REMOTE Oracle DB
980316Dec 17 2012 — edited Dec 18 2012Hi,
I am unable to create a DSN on my Windows XP 64 bit machine, I execute oradbac.exe from c:\windows\sysWOW64, after that
1) ODBC Data source Administrator dialog comes
2) I go to System DSN-> ADD button- Selects
3) Oracle in OraClient11g_home1->Finish
4) Oracle ODBC Driver Configuration dialog pops up
I enter my Datasource name,Description , TNS Service Name (What should I enter ? currently some JUNK characters are coming in the Combobox/droplist)
My Remote Database User name and password.
When I click Test connection I am getting error TNS : could not resolve the connect identifier specified
remember I am trying to connect to REMOTE database inside LAN.
I am also shocked I am not getting Port option where to add the server port
My server is Oracle 9i and on my remote machine I have Oracle 9i Client version and Oracle 11G client installed, I am able to coonnect to server using SQL Developer, but facing issue only while creating DSN.
Thanks