Forum Stats

  • 3,872,914 Users
  • 2,266,489 Discussions
  • 7,911,381 Comments

Discussions

connection string for Oracle in instantclient11_1 Driver without TNS

1027358
1027358 Member Posts: 2
edited Oct 5, 2014 6:03AM in ODBC

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/[email protected]: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?

This discussion has been closed.