connecting DB using ODBC in Windows Service
-
hi all, I am workingin a windows where i need to insert data into the Db using ODBC connection.I used stored procedure to insert data. here is the code EventType,Eventdate,vehicle I declared correctly and getting correct values also
System.Data.Odbc.OdbcCommand Emp = new System.Data.Odbc.OdbcCommand("DBO.INSRTEVNT", mycon); addEmp.CommandType = CommandType.StoredProcedure; Emp.Parameters.Add("@EventType", System.Data.Odbc.OdbcType.Int).Value = **EventType;** Emp.Parameters.Add("@EventTime",System.Data.Odbc.OdbcType.DateTime).Value = **EventDateTime**; Emp.Parameters.Add("@Vehi", System.Data.Odbc.OdbcType.VarChar).Value = **Vehicle**; Emp.ExecuteNonQuery();but when i execute the code,the data are not inserting and throwing exception. here it is ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'DBO.INSRTEVNT' expects parameter '@EventType', which was not supplied. but I passed correct data only.. Plz give me suggestions to resolve the problem. Thanks in advance.cheers sangeet
-
hi all, I am workingin a windows where i need to insert data into the Db using ODBC connection.I used stored procedure to insert data. here is the code EventType,Eventdate,vehicle I declared correctly and getting correct values also
System.Data.Odbc.OdbcCommand Emp = new System.Data.Odbc.OdbcCommand("DBO.INSRTEVNT", mycon); addEmp.CommandType = CommandType.StoredProcedure; Emp.Parameters.Add("@EventType", System.Data.Odbc.OdbcType.Int).Value = **EventType;** Emp.Parameters.Add("@EventTime",System.Data.Odbc.OdbcType.DateTime).Value = **EventDateTime**; Emp.Parameters.Add("@Vehi", System.Data.Odbc.OdbcType.VarChar).Value = **Vehicle**; Emp.ExecuteNonQuery();but when i execute the code,the data are not inserting and throwing exception. here it is ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'DBO.INSRTEVNT' expects parameter '@EventType', which was not supplied. but I passed correct data only.. Plz give me suggestions to resolve the problem. Thanks in advance.cheers sangeet
Try this code if ur getting that 3 value in textbox like this otherwise based on ur input change the id name..., Dim strInsertproc As String strInsertproc = "INSRTEVNT'" & txteventype.text & "','" & txteventtime.Text & "','" & txtvehi.text & "'" sqlcmd = New SqlCommand(strInsertproc, sqlconn) sqlcmd.Connection.Open() sqlcmd.ExecuteNonQuery() sqlcmd.Connection.Close() sqlcmd.Dispose() lblMsg.Text = "Record Inserted............"
Magesh
-
hi all, I am workingin a windows where i need to insert data into the Db using ODBC connection.I used stored procedure to insert data. here is the code EventType,Eventdate,vehicle I declared correctly and getting correct values also
System.Data.Odbc.OdbcCommand Emp = new System.Data.Odbc.OdbcCommand("DBO.INSRTEVNT", mycon); addEmp.CommandType = CommandType.StoredProcedure; Emp.Parameters.Add("@EventType", System.Data.Odbc.OdbcType.Int).Value = **EventType;** Emp.Parameters.Add("@EventTime",System.Data.Odbc.OdbcType.DateTime).Value = **EventDateTime**; Emp.Parameters.Add("@Vehi", System.Data.Odbc.OdbcType.VarChar).Value = **Vehicle**; Emp.ExecuteNonQuery();but when i execute the code,the data are not inserting and throwing exception. here it is ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'DBO.INSRTEVNT' expects parameter '@EventType', which was not supplied. but I passed correct data only.. Plz give me suggestions to resolve the problem. Thanks in advance.cheers sangeet
hi try to add parameters in the following way Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventType", System.Data.Odbc.OdbcType.Int)); Emp.Parameters("@EventType").Value = EventType; Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventTime",System.Data.Odbc.OdbcType.DateTime)); Emp.Parameters("@EventTime").Value = EventDateTime; Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@Vehi", System.Data.Odbc.OdbcType.VarChar, 100)); Emp.Parameters("@Vehi").Value = Vehicle; Emp.ExecuteNonQuery();
-
hi try to add parameters in the following way Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventType", System.Data.Odbc.OdbcType.Int)); Emp.Parameters("@EventType").Value = EventType; Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventTime",System.Data.Odbc.OdbcType.DateTime)); Emp.Parameters("@EventTime").Value = EventDateTime; Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@Vehi", System.Data.Odbc.OdbcType.VarChar, 100)); Emp.Parameters("@Vehi").Value = Vehicle; Emp.ExecuteNonQuery();
thanks for ur reply .. i tired the code. but still am getting the same error. ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'INSRTEVNT' expects parameter '@EventType', which was not supplied. plz give me suggestions
cheers sangeet