Hi,
I’m getting the following error while using the ODBC for MSSQL 7.0.

“Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt, SQL state S1000 in SQLExecDirect”

Following is my script.

$conn = odbc_connect(“dsn_name”,”user”,”pwd”);

$sql_sel = “select field1 from m_one”;

$lr_sel = odbc_exec($conn,$sql_sel)

$lint =0;

while(odbc_fetch_row($lr_sel))
{
	$sql_ins = “insert into m_two values(‘“.odbc_result($lr_sel,’field1’).”’,’”.$lint.”’)”;
	odbc_exec($conn,$sql_ins); //Error is shown in this statement
	$lint++;
}

What is the actual problem and what can be the solution for this.

I will be very thankful if anyone helps me.

Regards,
Krishna.

    Write a Reply...