We have Oracle DB without tnsnames.ora.
We are able to connect to the DB using sqlplus from a command line with the following connection string:
username/Password@DomainAdress:Port/DataBaseName.DomainAdress
SYS/****@computerName.Domain.net:1523/DataBaseName.computerName.Domain.net
If we try to connect from the command line only with the DB name and not the FQDN – the connection fails.
We would like to connect using Driver={Oracle in instantclient11_1} We tried the following connection string:
Driver={Oracle in instantclient11_1};Dbq= computerName.Domain.net:1523/ DataBaseName.computerName.Domain.net;Uid=SYS;Pwd=**** as sysdba
We got the following Error:
[Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
What should be the right connection string for Oracle in instantclient11_1 Driver?