From: Sumanta Das <sumantacaptain@...>
Date: 2008-07-04T20:10:02+09:00
Subject: Stored Procedure + sql server 2005 + insertion

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
-- 
Posted via http://www.ruby-forum.com/.