Hi everybody,
I am on trouble with my first Oracle InstantClient installation.
I need to connect my Microsoft Access application to the Oracle database (of TCPOS software) to read some tables.
My application front-end needs to run onto each user's computer (while back-end is stored onto a network drive) so I have to configure the windows ODBC driver to view the TCPOS's tables.
1) I have installed instantclient-basic-win-x86-64-11.2.0.1.0.zip and instant-odbc-win-x86-64-11.2.0.1.0.zip (according to computer's architecture) running the unzipped files from C:\Oracle;
2) I have created the system variable TNS_ADMIN setting its value to C:\Oracle;
3) I have added to the system variable PATH the folder with my Instant Client's files (C:\Oracle)
4) I have created into the C:\Oracle folder the TNSNAMES.ORA file with the following content (after checking my computer's IP address):
ORCL_TCPOS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.64)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
5) In the same folder (C:\Oracle) I have created the SQLNET.ORA file with the following content:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
6) From Windows ODBC administration I have added the new user DSN and I have condigured it with:
Data Source Name = Oracle TCPOS
TNS Service Name = ORCL_TCPOS
User ID = tcpos
7) execuitng the connection test appear the following error message:
Unable to connect
SQLState=S1000
[Oracle][ODBC][ORA]ORA-12541: TNS:no listener
What's wrong or what I missed in this procedure?
Thanks in advance for each help to solve my problem.