# Ruby + sql server **URL:** \ **Category:** Ruby\ **Created:** [March 30, 2007, 1:56pm UTC](https://www.ruby-forum.com/t/ruby-sql-server/90626 "2007-03-30T13:56:13Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Faby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/bbe5ce/32.png) [@Faby](https://www.ruby-forum.com/u/Faby)\ **Post date:** [March 30, 2007, 1:56pm UTC](https://www.ruby-forum.com/t/ruby-sql-server/90626/1 "2007-03-30T13:56:13Z")
Hi, I would like to execute a stored procedure using ruby and sql server 2000 with DBI and ODBC. Can anyone give me an example on how to do it? Thanks ---
**Author:** ![Faby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/bbe5ce/32.png) [@Faby](https://www.ruby-forum.com/u/Faby)\ **Post date:** [April 1, 2007, 5:02pm UTC](https://www.ruby-forum.com/t/ruby-sql-server/90626/2 "2007-04-01T17:02:30Z")
On 3/30/07, Faby [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Hi, > I would like to execute a stored procedure using ruby and sql server > 2000 with DBI and ODBC. > Can anyone give me an example on how to do it? > Thanks Probably the simplest way is use ruby-dbi to open a connection, and then run the “EXEC ” SQL as a regular statement. You should find plenty of resources on the web about using ruby-dbi. ---
**Author:** ![Faby](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/bbe5ce/32.png) [@Faby](https://www.ruby-forum.com/u/Faby)\ **Post date:** [April 4, 2007, 11:01pm UTC](https://www.ruby-forum.com/t/ruby-sql-server/90626/3 "2007-04-04T23:01:11Z")
On Mar 30, 6:51 am, “Faby” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Hi, > I would like to execute a stored procedure using ruby and sql server > 2000 with DBI and ODBC. > Can anyone give me an example on how to do it? > Thanks Here is what worked for me: I made an ODBC System DSN named ruby to the DB & Server I wanted to connect to. so my ruby script looks like this: require “dbi” db = DBI.connect(‘dbi:ODBC:ruby’, ‘sa’, ‘UMsys#07’) storedproc = “EXEC createUser @userName=bob, @password=bob” stmt = db.prepare(storedproc) stmt.execute puts “User Created” stmt.finish db.disconnect Hope that helps…