OraFAQ Forum: Forms » *Connecting to Oracle from Dev Form? How to? *

Home » Developer & Programmer » Forms » *Connecting to Oracle from Dev Form? How to? *

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

*Connecting to Oracle from Dev Form? How to? * [message #84450]

Tue, 16 March 2004 20:27

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

Assume I am now connected to oracle�from dev2000 Form. Now want to close current connection and will connect to another oracle server in different computer having IP 192.123.5.2 using 'System/manager'. I want this will happen when user click a button on devloper200 from. I am using ORACLE 8.0.5.0.0 with Developer2000 Form 6.0.5.0.2.

How Can I do It Pls help me.

Thanks In advance.

Report message to a moderator

Re: *Connecting to Oracle from Dev Form? How to? * [message #84455 is a reply to message #84450]

Wed, 17 March 2004 01:17

simi
Messages: 23
Registered: August 2002

Junior Member

Hi

You can use LOGON buildin procedure to do this

Syntax

LOGON(username VARCHAR2, password VARCHAR2);

Example

LOGON(scott,tiger||'@'||mydb);

Report message to a moderator

Re: *Connecting to Oracle from Dev Form? How to? * [message #84464 is a reply to message #84455]

Wed, 17 March 2004 16:55

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

Thanks SIMI, I need to connect to a oracle host using IP address over internet. So How can I configure '@mydb' which will refer any host if I provide correct username,password and IP address?

Report message to a moderator

Re: *Connecting to Oracle from Dev Form? How to? * [message #84468 is a reply to message #84464]

Thu, 18 March 2004 01:54

simi
Messages: 23
Registered: August 2002

Junior Member

Hi

You should be having the particular IP configured in your TNSNAMES file. You can do it thru Net8easy configuration also.

Thanks

Report message to a moderator

Previous Topic:	security issue/shortcut to mmx :
Next Topic:	on different ports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 08:03:29 CST 2025