(Type your message here)

--------------------------------
From: shubha rao
I have create MYSQL Procedure, it created successfully

CREATE PROCEDURE `infosearch`.`sp_info_QLink1`()
begin
Select distinct PFC.* from pre_form_col1 PFC, Quest_Link WHERE
PFC.rowid = Qlink1 ORDER BY 1;
end

Now, I am trying to invoke from asp.net

try
{
OdbcConnection Conn=new OdbcConnection("DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=Infosearch;UID=r oot;PASSWORD=real;OPTION=3");
Conn.Open();
OdbcCommand cmd=new OdbcCommand("sp_info_QLink1",Conn);
cmd.CommandType=CommandType.StoredProcedure;
OdbcDataReader dr=cmd.ExecuteReader();
}catch(Exception ee){ee=ee;}

It is raising the exception 'SELECT in a stored procedure must have INTO'

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>HQk5Sel6gUGvhrHeOqhd8w==</Id>