I have this sproc wich needs just one parameter for input, but when i call it from asp.net hte sproc returns no error but doesn&#039;t do the work either. <BR>This is weird because when i run it from DBArtisan or another sql client works just fine. <BR>My sproc just do some inserts..selects, but when check the tables for inserts theres nothing when called from asp.net <BR>here&#039;s how I call it from asp.net: <BR><BR>[code language="VB.NET"]<BR> Dim cmm As New Odbc.OdbcCommand("{Call " & sprocName & " (?)}", Conn) <BR> Dim prm As Odbc.OdbcParameter <BR><BR> cmm.CommandType = CommandType.StoredProcedure <BR><BR> prm = cmm.Parameters.Add("@ParamName",Odbc.OdbcType.Int) <BR> prm.Value = 96 <BR><BR> cmm.ExecuteNonQuery <BR>[/code]<BR><BR>Help needed, please. <BR><BR>PD: My others sproc with no param worked fine