MySQL Forums
Forum List  »  Connector/ODBC

ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Got error 134 from table handler
Posted by: Chris Olson
Date: November 11, 2004 10:04AM

This is C# code in an ASP web server situation (not my choice) -

The code around the error is:

else // search time has expired and page has been resubmitted
// ...transfer to results page...
{
String sql = "select searches_parts.searchid, searches_parts.msgid, responses_parts.msgid, responses_parts.msgid, recycler_config.alias from searches_parts, responses_parts, recycler_config where searches_parts.searchid = " + Request.QueryString["SearchId"] + " and responses_parts.msgid = searches_parts.msgid and recycler_config.alias = responses_parts.alias";
OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
DataSet ds = new DataSet();
--> da.Fill(ds);

DataTable dataTable = ds.Tables[0];

// if we didn't get enough results on the first try, re-send to everybody
if ((Request.QueryString["SearchAll"]==null) && (dataTable.Rows.Count < (20*Convert.ToInt32(Request.Form["__NUMPARTS"]))))
{
conn.Close();
Server.Transfer("~/default.aspx?SearchState=" + Convert.ToString((int)SearchStates.SubmitRequest) + "&SearchId=" + Request.QueryString["SearchId"] + "&SearchAll=" + dataTable.Rows.Count.ToString() + "&NumParts=" + Request.Form["__NUMPARTS"].ToString() + "&ResCount=" + dataTable.Rows.Count);
}

conn.Close();
Server.Transfer("~/default.aspx?SearchState=" + Convert.ToString((int)SearchStates.DisplayResults) + "&SearchId=" + Request.QueryString["SearchId"] + ((Request.QueryString["SearchAll"]==null)?(""):("&SearchAll=1")) + "&NumParts=" + Request.Form["__NUMPARTS"].ToString());
}

Any ideas?

Options: ReplyQuote


Subject
Written By
Posted
ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Got error 134 from table handler
November 11, 2004 10:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.