SQLExecDirectA Call Hangs Up On SQL Server 2000

Hi,

I am trying to execute a stored procedure on SQL server 2000 Developer edition through ODBC. I am using a VC++ client for the same. The stored procedure has 51 parameters. The issue is that the response on method SQLExecDirect is not consistent. At times it will return success or failure based on parameter values, otherwise it just hangs up. The code snippet is like -


// get database handle

// get statement handle


//call sql bind parameter


// set memory for query string and copy it


// strcpy(sqlString,"{call pi_ml_*******(?, ?, 2, 0, 0, ?, ?, 100,'2007-05-04 19:37:37.357', '2007-05-04 19:37:37.357', 1, 1, 72, ?, 72, ?, ?, ?,0, 0, ?, 0, NULL, NULL, 0, 0, 0, 0, ?, '2007-05-04 19:37:37.357', ?, ?, ?, 0, 0, ?, ?, 0, NULL, ?, ?, 0, NULL, NULL,NULL, NULL, 0, NULL,NULL, 0, 0, 0)}");



//call sqlexecDirectA( for an ANSI build)


returnVal = SQLExecDirectA(hstmt, (UCHAR*)sqlString, SQL_NTS);




It appears to be some locking issue but I am the only user for the database. This code works perfectly fine for other stored procedures. I have tested the parameters on SQL analyzer store procedure execution utility.




Thanks,

Peeyush