Reg : Databse connection in vb 6.0

[praveen09]

Hi all

I have a doubt regarding the query execution time in vb(ODBC) because whenever I run query in VB6.0 interface its taking 5 min to execute a query while I run the same query using java (ODBC) it takes 5 sec to execute the Query

for more details here is my code

dim query as String

query = "371523"
     conn.ConnectionString = "DSN=mydsn;UID=test;PWD=test"
      conn.Open
       Set commandQuery.ActiveConnection = conn
         commandQuery.CommandText = "SELECT A.LAA_APP_ACCOUNTNO_C,A.CUST_ID_N, b.CUSTOMERNAME,c.LSO_OFFICE_NAME_C,A.APP_ID_C FROM LOS_APP_APPLICATIONS A,NBFC_CUSTOMER_M b,LOS_SEC_OFFICE c WHERE A.CUST_ID_N=b.CUST_ID_N AND A.LAA_BRANCHID=c.LSO_OFFICE_CODE_C AND A.APP_ID_C=" & query

       Set rsData = commandQuery.Execute
       
        MsgBox (rsData.EOF)

    conn.Close
    Set conn = Nothing