Thread: Problem with MySql Stored Procedure

hey guys
I am having some problems with trying to get results from MySql sp in .net.
My sp

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_LoginCheck`()
BEGIN
  Select First_Name, Last_Name From tblUserMaster Where Email_Id='xxx';
END

My Code

Code:

Dim Cmd As New OdbcCommand("sp_LoginCheck()", Con)
Cmd.CommandType = CommandType.StoredProcedure

Dim Dtr As OdbcDataReader = Cmd.ExecuteReader()
Cmd.Dispose()

If Dtr.HasRows Then
    Response.Write("Welcome " & Dtr("First_Name") & " " & Dtr("Last_Name"))
Else
    Response.Write("No Results")
End If
Dtr.Close()

My Error

Code:

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sp_LoginCheck()' at line 1

Really have no idea and no experience with MySql and stored procedures.
Can anyone help me

@J, Response.Write(Cmd.CommandText.ToString()) also doesnt write the resultant query

Micky

Thanx J, but his problem isnt related to .net(i think).

No idea what to do
May be RR can give me more insight

no change J

Originally Posted by jmurrayhead

Alright, try creating your procedure using the syntax that rr did with his.

u think my SP is wrong?
i have MySql Administrator, i made my SP using it and it shows no error there!

ok it works, i chnaged to this

Code:

Dim Cmd As New OdbcCommand("call sp_LoginCheck", Con)

Now let me try sending parameters and see, i'll b back with questions