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 <[email protected]> wrote: > 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 <[email protected]> wrote: > >> 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 <[email protected]> wrote: >> >>> >>> >>> 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 <[email protected]> wrote: >>> > you have to download the dbi files and configure them on your machine. >>> > >>> > On Fri, Oct 30, 2009 at 12:30 PM, Pritam <[email protected]> wrote: >>> > >>> > > 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 C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:233:in >>> `_get_full_driver' >>> > > from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:219:in `connect' >>> > > from database.rb:5 >>> > >>> > > I went to the location(C:/Ruby/lib/ruby/site_ruby/1.8/dbd/) as >>> > > indicated in the error, and could find only find ODBC and Proxy >>> > > folders and not ADO. >>> > > Do i need to download and copy the ADO.rb file in this location in >>> > > order to access the SQL database? >>> > > If yes, where can i find this file... >>> > >>> > > Thanks in advance >>> > >>> > > On Oct 29, 4:56 pm, SMF SMF <[email protected]> wrote: >>> > > > 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 field >>> > > > #puts row[1] # the second field >>> > > > end >>> > > > end >>> > >>> > > > No idea, about framework or architecture >>> > >>> > > > ---- >>> > > > Thanks >>> > >>> > > > On Thu, Oct 29, 2009 at 5:03 PM, Pritam <[email protected]> >>> wrote: >>> > >>> > > > > Hi guys, >>> > >>> > > > > I am new to ruby programming, and I need help in developing data >>> > > > > driven framework which uses sql database for retrieving data. I >>> have >>> > > > > seen a lot of examples over internet which showed how to do it >>> using >>> > > > > excel and open source applications. >>> > >>> > > > > To start with I need information for the following. >>> > >>> > > > > 1. How to connect to a sql database using ruby/watir scripts? >>> > > > > 2. What sought of architecture am I looking for? >>> > >>> > > > > Thanks in advance. >>> >> >> >> >> >> > -- Sent from my mobile device Thanks. Wesley Chen. For life, the easier, the better. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Watir General" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/watir-general?hl=en -~----------~----~----~----~------~----~------~--~---
