Stored Procedure + sql server 2005 + insertion

[Sumanta Das]

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:atabaseError: 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

 

[Sumanta Das]

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:atabaseError: 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

 

[Robert Klemme]

i need it urgently.... plz helppp

Don't push people. All of us do this for the fun of it.

Where is your Ruby code?

robert