Hello,<BR><BR>I am getting the following error when running my code:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E0C)<BR>Command text was not set for the command object.<BR>/dgv2test/register.asp, line 306<BR><BR>the sequel statement runs fine in my database though, i am running Oracle 8i Personal Edition. I can't figure out what it the problem. The full code is below:<BR><BR>if strUniqueEmail = "1" then<BR>'## Forum_SQL<BR>strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS "<BR>strSql = strSql & " WHERE M_EMAIL = '" & Trim(chkString(Request.Form("Email"),"SQLString")) &"';"<BR>'On Error Resume Next<BR>set rs = my_Conn.Execute(TopSQL(strSql,1))<BR><BR>response. write(strSql)<BR><BR>Thats the code, it runs fine when i take the output of the response.write code below it. I am not sure what this error means as I am unable to find much information on it on Google Search. Is there some other site that explains these errors?<BR><BR>Thank you for your help I appreciate it.