Ruby + sql server

ruby-talk
1

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

2

Probably the simplest way is use ruby-dbi to open a connection, and
then run the "EXEC <your stored procedure>" SQL as a regular
statement. You should find plenty of resources on the web about using
ruby-dbi.

···

On 3/30/07, Faby <stardust99_fr@yahoo.fr> 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

--
* J *
  ~

3

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

···

On Mar 30, 6:51 am, "Faby" <stardust99...@yahoo.fr> 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