Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create Oracle-ODBC DSN under Windows 64 bit with REMOTE Oracle DB

980316Dec 17 2012 — edited Dec 18 2012
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2013
Added on Dec 17 2012
6 comments
14,455 views