Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Time out problem while executing a querry ...
#1
Not Solved
Hi,

The QTP is connected to Oracle try ODBC. Now while my script runs a querry , which takes 30 - 40 secs for its execution, the qtp throws a time out. And the connection is lost.

Can anyone pls help me with this prob?
Reply
#2
Not Solved
can you paste whetever you have tried, it will help us to find out the issue if any.

Reply
#3
Not Solved
Yes sure, here is the code...............

Code:
Dim dsn_name, db_name, db_user, db_pwd, DB_String
   Dim Table_Rows, Row_Select
        dsn_name = Environment("Dsn_Name")
        db_name = Environment("Db_Name")
        db_user = Environment("Db_User")
        db_pwd = Environment("Db_Pwd")
        DB_String = "DSN="&dsn_name&"; UID="&db_user&"; PWD="&db_pwd&"; DBQ="&db_name&"; DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;"
        Set con = createobject ("ADODB.Connection")
        Set rs = createobject("ADODB.Recordset")
        con.open DB_String
        DB_Query = "select  *  from debkart"
        Set rs = con.Execute(DB_Query)


Now after the execution of con.execute , QTP is giving time out problem.

Pls help.


Code:
Dim dsn_name, db_name, db_user, db_pwd, DB_String
   Dim Table_Rows, Row_Select
        dsn_name = Environment("Dsn_Name")
        db_name = Environment("Db_Name")
        db_user = Environment("Db_User")
        db_pwd = Environment("Db_Pwd")
        DB_String = "DSN="&dsn_name&"; UID="&db_user&"; PWD="&db_pwd&"; DBQ="&db_name&"; DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;"
        Set con = createobject ("ADODB.Connection")
        Set rs = createobject("ADODB.Recordset")
        con.open DB_String
        DB_Query = "select  *  from debkart"
        Set rs = con.Execute(DB_Query)


ow after the execution of con.execute , QTP is giving time out problem.

Pls help.
Reply
#4
Not Solved
I am not able to understand the DB_string, anyways can you try below and let me know if this works?
Code:
rs.Open DB_Query, ConObj,adLockPessimistic

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  error when executing an UFT automation script alexalloza 0 1,522 10-30-2018, 06:17 PM
Last Post: alexalloza
  Executing via create "RES"xx folder? nishitd 0 1,231 03-07-2018, 01:09 AM
Last Post: nishitd
  QTP-Re-executing script after completion of all iterations JwalantBhatt0602 1 2,681 03-24-2016, 12:37 AM
Last Post: JwalantBhatt0602
  QTP is getting closed after executing first test in MTM(Batch) Shyama 0 2,130 10-07-2014, 07:26 PM
Last Post: Shyama
  How to call testscript after executing previous one. upadhyay40 3 3,686 04-27-2014, 10:14 PM
Last Post: Wigi

Forum Jump:


Users browsing this thread: 1 Guest(s)