Hi ,
 
We are experienceing the following Problem..

We are executing a store procedure from within Axapta on the Database. The procedure kicks but terminates halve way through (it creates halve of the records). We have tested this with various database store procedures (simple and complex) and all seems to run into the same problem. If executed directly on the Database (not from Axapta) the procedures run 100% correct.

 It seems as if the Axapta connection ‘times out’ after a few seconds.

// The job Is As Follows.

static void ***_StoredProc(Args _args)
{
    Connection  Con;
    Statement   Stmt;
    
    Con  = new Connection();
    Stmt   = connection.createStatement();
 
    Stmt.executeUpdate(‘Stroed Procedure’);

     Stmt.commit();

   
}

Can someone help me out in this regards?.

Many Thanks,

Subbu

SDBC


Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'

Sharing the knowledge on Axapta.



Yahoo! Groups Links

Reply via email to