Sumanta Das wrote: > hi..... can any body help me? > i want to insert data into sql server(2005)database... > i have a int value to pass...... > how can i send it to the stored procedure > ..... > here IndID is the integer value but when i want to pass it... it is > showing the follwing error: > > > DBI::DatabaseError: Execute > OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server > Error converting data type varchar to int //// here also showing > scalar > variable must be declared if > single > quote taken off > HRESULT error code:0x80020009 > Exception occurred.: exec SP_peopleinsert > '@fname','@mname','@lname','@sex','@dob','@IndID' > > > > > thanx for helping... in advance i need it urgently.... plz helppp -- Posted via http://www.ruby-forum.com/.