Hi,
Thank you for your reply.
I have executed the code that you have given, but i got the following
error.
C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:368:in `load_driver': Could not
load driver (no such file to load -- C:/Ruby/lib/ruby/site_ruby/1.8/
dbd/ADO) (DBI::InterfaceError)
from
you have to download the dbi files and configure them on your machine.
On Fri, Oct 30, 2009 at 12:30 PM, Pritam pmaha...@gmail.com wrote:
Hi,
Thank you for your reply.
I have executed the code that you have given, but i got the following
error.
Hi,
Thank you very much.now am able to connect to the database and
retrieve the data...
Thanks again.
On Oct 30, 12:25 pm, SMF SMF shaikm.fi...@gmail.com wrote:
you have to download the dbi files and configure them on your machine.
On Fri, Oct 30, 2009 at 12:30 PM, Pritam
Hi Pritam,
No problem. Could you please do one favor, can you post the
steps/configuration you followed to connect to database that will helpful to
others also.
Thanks,
smf
On Fri, Oct 30, 2009 at 1:58 PM, Pritam pmaha...@gmail.com wrote:
Hi,
Thank you very much.now am able to connect
Yes, it works, but I have to change Uid as User ID, Pw as password.
Thanks.
Wesley Chen.
For life, the easier, the better.
On Fri, Oct 30, 2009 at 4:53 PM, SMF SMF shaikm.fi...@gmail.com wrote:
Hi Pritam,
No problem. Could you please do one favor, can you post the
steps/configuration you
If the sql server port is not the default one 1433, how can we set
it? In the connect string, can we set any other attribute?
On 10/30/09, Wesley Chen cjq@gmail.com wrote:
Yes, it works, but I have to change Uid as User ID, Pw as password.
Thanks.
Wesley Chen.
For life, the easier, the
@googlegroups.com [mailto:watir-gene...@googlegroups.com]
On Behalf Of Wesley Chen
Sent: Friday, October 30, 2009 2:41 PM
To: watir-general@googlegroups.com
Subject: [wtr-general] Re: Data driven framework using SQL database
Yes, it works, but I have to change Uid as User ID, Pw as password.
Thanks
Hi,
Try this article to connect sql database http://bit.ly/2G9Z3E
http://bit.ly/2G9Z3EThanks
On Thu, Oct 29, 2009 at 5:03 PM, Pritam pmaha...@gmail.com wrote:
Hi guys,
I am new to ruby programming, and I need help in developing data
driven framework which uses sql database for
Hi Pritam,
Answer to your *question 1.*
require 'dbi'
DB =
Provider=SQLOLEDB.1;Server=servername;Database=DBname;Uid=userid;Pw=password
sql = select LoginID from Login WHERE UserName ='xyz'
DBI.connect(DBI:ADO:#{DB}) do | dbh |
dbh.select_all( sql ) do |row|
puts row[0] # the first
