From: Damjan Rems <d_rems@...>
Date: 2008-03-17T19:54:22+09:00
Subject: Re: MSSQL 2005 Stored Procedure?

Alexander Tretjakov wrote:
> Sorry for my bad English.
> Can somebody help me with MSSQL 2005 and stored procedure?

Something to start from.

require 'rubygems'
require 'dbi'

  dbs = DBI.connect('DBI:ODBC:MYDB', 'usr', 'pwd')
  dbs.execute("{call pr_appLogin(2, 'myid', 'mypwd')}")

I have to use this on an database where second login is required to 
update database. pr_appLogin is the name of stored procedure on MSSQL 
2005 server.


by
TheR
-- 
Posted via http://www.ruby-forum.com/.