Home » Developer & Programmer » Forms » *Connecting to Oracle from Dev Form? How to? *
*Connecting to Oracle from Dev Form? How to? * [message #84450] Tue, 16 March 2004 20:27 Go to next message
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.
Re: *Connecting to Oracle from Dev Form? How to? * [message #84455 is a reply to message #84450] Wed, 17 March 2004 01:17 Go to previous messageGo to next message
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);
Re: *Connecting to Oracle from Dev Form? How to? * [message #84464 is a reply to message #84455] Wed, 17 March 2004 16:55 Go to previous messageGo to next message
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?
Re: *Connecting to Oracle from Dev Form? How to? * [message #84468 is a reply to message #84464] Thu, 18 March 2004 01:54 Go to previous message
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
Previous Topic: security issue/shortcut to mmx :
Next Topic: on different ports
Goto Forum:
  


Current Time: Fri Mar 29 09:56:06 CDT 2024