Edit Question - KnowledgeHub

Title Body

I Have a problem with a prepared statement in C#: OdbcCommand cmd = sql.CreateCommand(); cmd.CommandText = "SELECT UNIQUE_ID FROM userdetails WHERE USER_ID = ?"; cmd.Parameters.Add("@USER_ID", OdbcType.VarChar, 250).Value = email; (of course email contains a valid email address, with @ sign). This code returns a random error - "The connection has been disabled" {"ERROR [01000] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). ERROR [08S01] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation."} However if I run my code without a prepared statement, meaning: cmd.CommandText = "SELECT UNIQUE_ID FROM userdetails WHERE USER_ID = '"+email+"'"; Everything works perfectly. Maybe it's related to the fact that I have a @ sign in the parametrized value? I tend to think I'm not the first one trying to create a prepared statement with an email address... I have no idea what's wrong! Other prepared statements work normally... Can you please help? :) Thanks, Nili

Tags (comma-separated) Cancel