Skip to Main Content
Forums

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!

connection string for Oracle in instantclient11_1 Driver without TNS

1027358Oct 5 2014 — edited Oct 5 2014

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?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2014
Added on Oct 5 2014
#odbc, #windows-and-net
0 comments
1,011 views