Print Thread
Possibility to connect to database via full connect string?
#36041 10/13/09 07:39 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
It is possible to connect to a database, not via an alias in the TNSnames file, but by writing the entire connect string, e.g. to SQL*PLUS:

sqlplus scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=oracle)))

Is it possible to connect to a database by this method via the normal PLD logon (or another way), or does it require that all connection strings are present in the TNSnames file?

I know this is a bit exotic, but I just wondered wink

Re: Possibility to connect to database via full connect string?
Claus Pedersen #36042 10/13/09 08:34 AM
Joined: Sep 1999
Posts: 212
Warszawa,Poland
J
Member
Offline
Member
J
Joined: Sep 1999
Posts: 212
Warszawa,Poland
Yes, without any problem.


Joachim Rupik

Browser Extender & Plot Window Team
Emberiza Software s.c.
---------------------------------------------------------
Browser Extender home: http://www.browserextender.com
Re: Possibility to connect to database via full connect string?
Joachim Rupik #36044 10/13/09 08:42 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
OK thanks, I missed the fact that the Database dropdown was a writeable combo-dropdown.

Re: Possibility to connect to database via full connect string?
Claus Pedersen #36045 10/13/09 09:04 AM
Joined: Sep 1999
Posts: 212
Warszawa,Poland
J
Member
Offline
Member
J
Joined: Sep 1999
Posts: 212
Warszawa,Poland
You can always write a whole connect string in a first field (username) on Logon dialog.


Joachim Rupik

Browser Extender & Plot Window Team
Emberiza Software s.c.
---------------------------------------------------------
Browser Extender home: http://www.browserextender.com

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.098s Queries: 14 (0.049s) Memory: 2.5130 MB (Peak: 3.0424 MB) Data Comp: Off Server Time: 2024-05-19 00:36:59 UTC
Valid HTML 5 and Valid CSS