# Stored Procedure + sql server 2005 + insertion

**URL:** <https://www.ruby-forum.com/t/stored-procedure-sql-server-2005-insertion/142198>\
**Category:** Ruby\
**Created:** [July 4, 2008, 1:13pm UTC](https://www.ruby-forum.com/t/stored-procedure-sql-server-2005-insertion/142198 "2008-07-04T13:13:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sumantacaptain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8491ac/32.png) [@sumantacaptain](https://www.ruby-forum.com/u/sumantacaptain)\
**Post date:** [July 4, 2008, 1:13pm UTC](https://www.ruby-forum.com/t/stored-procedure-sql-server-2005-insertion/142198/1 "2008-07-04T13:13:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sumantacaptain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8491ac/32.png) [@sumantacaptain](https://www.ruby-forum.com/u/sumantacaptain)\
**Post date:** [July 4, 2008, 1:14pm UTC](https://www.ruby-forum.com/t/stored-procedure-sql-server-2005-insertion/142198/2 "2008-07-04T13:14:52Z")

</div>

Sumanta D. 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

---

<div class="post-metadata">

**Author:** ![sumantacaptain](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8491ac/32.png) [@sumantacaptain](https://www.ruby-forum.com/u/sumantacaptain)\
**Post date:** [July 4, 2008, 6:05pm UTC](https://www.ruby-forum.com/t/stored-procedure-sql-server-2005-insertion/142198/3 "2008-07-04T18:05:36Z")

</div>

On 04.07.2008 13:11, Sumanta D. wrote:

> > DBI::DatabaseError: Execute
> > 
> > thanx for helping… in advance
> 
> 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