Hello,
I am currently talking with our Enterprise Oracle 12C with the SQLDeveloper on my Windows 7 desktop. OK, fine for what I am doing. BUT, I want to connect some 3rd party apps to the Oracle big guy, like SAPs Crystal Reports (CR) or Embarcadero's (Borland) Object Pascal, or even my Ada things, either using Oracle drivers, or maybe better using the Windows ODBC wizard definition tools. I cannot get any of this to work, that is the ODBC connector on Win7 to Oracle. My tnsnames.ora file seems OK, though I am not sure the Listener script on the Oracle server is correct. Also, CR may want to connect via a full Oracle Client install on my Win7 desktop, which is not there.
1) How do I download and install the Oracle client (beyond the SQL Developer tool I have been using so far?
2) I should have the server's listener file with same name/value pairs as on the Win7 tnsnames.ora pairs?
3) Anyone have success in connecting 3rd party s/w to big O via ODBC?
Here is parts of tnsnames.ora located at C:\oracle\ora81\network\admin\..
...
CDWDEVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.15.16.17 )(PORT=1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = CDWDEVDB)
)
)
Parts of server listener.ora file
# ---------------------------------
.....
CDWDEVDBLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = cdwdevdb)
(ADDRESS = (PROTOCOL = TCP) (HOST = PT00452E.xxxx.ORG)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCPS)(HOST = PT00452E.xxxx.ORG)(PORT = 2484))
(ADDRESS = (PROTOCOL = NMP) (SERVER = PT00452E)(PIPE = ORAPIPE))
)
)
........
Does the service name in the tnsnames.ora [ here CDWDEVDB ] have to exactly match the listener name? [ Here, I have appended the 'listener' string to the service name.
The ODBC. CR connection wizards don't seem to use the same terminology for the name/value pairs they solicit to connect.
Tks