Home » Developer & Programmer » Forms » Auto connect the data base
Auto connect the data base [message #228388] Mon, 02 April 2007 19:54 Go to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Sir,
i have developed a software,but a proble is occur,
i want a user connect data base auto it mean autologin.
i write a procedure and call this proceduer when new form instance
but it not work,

PROCEDURE getData IS
connection_id EXEC_SQL.CONNTYPE;
cursorID EXEC_SQL.CURSTYPE;
BEGIN
connection_id := EXEC_SQL.OPEN_CONNECTION('carhaat/carhaat@raihan');
cursorID := EXEC_SQL.OPEN_CURSOR(connection_id);
END;

another way i have tried it

logon('carhaat','carhaat'||'@'||'raihan'); ///carhaat=user,carhaat=password,raihan=database///

but this way i have failed,any body give me a better and
easy solution,please give me example.
Re: Auto connect the data base [message #228419 is a reply to message #228388] Tue, 03 April 2007 00:07 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Which version of Forms are you using? What is the command that you are using to start your Form?

David
Re: Auto connect the data base [message #228530 is a reply to message #228419] Tue, 03 April 2007 05:17 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Developer 6i and oracle 9i

please reply with coding and step
Re: Auto connect the data base [message #228655 is a reply to message #228419] Tue, 03 April 2007 10:02 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Thakn u,
My frontend Developer 6i and backend oracle9i.
my start form in the desktop of mycomputer,
start form properties i write down
ifrun60 ?????????????????,(this is the process to my start form)








Re: Auto connect the data base [message #228716 is a reply to message #228655] Tue, 03 April 2007 21:02 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'ifrun'. Look at http://www.orafaq.com/forum/m/146785/67467/?srch=ifrun#msg_146785

The feature you need to use is 'userid'.

David
Previous Topic: AutoGenerated No in Tabular Form
Next Topic: comparision problem........
Goto Forum:
  


Current Time: Thu Dec 05 19:18:49 CST 2024