Forums | Admin Discussion Forums: open-discussion Start New Thread Nested Flat Threaded Ultimate Show 25 Show 50 Show 75 Show 100   By: Chris Cropley RE: Connect Ruby to SQL Server 2008 R2 [ reply ]   2010-04-01 08:22 I have found a solution and it was very easy to solve. The ODBC Administrator in Windows 7 creates DSN's using 64 bit Drivers. What I needed to do was run the 32 bit ODBC Administrator and create the DSN's again. By: Chris Cropley RE: Connect Ruby to SQL Server 2008 R2 [ reply ]   2010-03-30 20:35 The only successful verification I have had is through the native ODBC setup application, when I set up the BRIDGE_CC DSN. You have made a good suggestion, I will try another tool to verify the driver is good. Please excuse my ignorance, what do you mean by the DBI can leverage it? By: Erik Hollensbe RE: Connect Ruby to SQL Server 2008 R2 [ reply ]   2010-03-30 16:03 Have you tried connecting with another ODBC tool? That message seems to indicate your underlying ODBC driver is broken, not that DBI can't leverage it. By: Chris Cropley Connect Ruby to SQL Server 2008 R2 [ reply ]   2010-03-30 15:54 I am posting this request for help because I am completely at a loss. I have trawled through various forums and I am still unable to find a solution. I may just be a (to coin a Homer Simpson phrase) stoopid head! Put simply I am trying to connect Ruby to SQL Server DB Engine running on the network. I am running Windows 7 and we are running SQL Server 2008 R2. Here is my Ruby setup. C:\Ruby\bin>gem list *** LOCAL GEMS *** actionmailer (2.3.5) actionpack (2.3.5) activerecord (2.3.5) activerecord-sqlserver-adapter (2.3.4) activeresource (2.3.5) activesupport (2.3.5) dbd-odbc (0.2.5) dbi (0.4.3) deprecated (2.0.1) fxri (0.3.6) fxruby (1.6.16) hpricot (0.6.164) log4r (1.0.5) ptools (1.1.6) rack (1.0.1) rails (2.3.5) rake (0.8.7, 0.8.1) ruby-opengl (0.60.0) test-unit (2.0.1) win32-api (1.2.1, 1.2.0) win32-clipboard (0.4.4) win32-dir (0.3.2) win32-eventlog (0.5.0) win32-file (0.5.5) win32-file-stat (1.3.1) win32-process (0.5.9) win32-sapi (0.1.4) win32-sound (0.4.1) windows-api (0.2.4) windows-pr (0.9.3) C:\Ruby\bin> I have a very simple connect script with the following lines. require "dbi" conn = DBI.connect('DBI:ODBC:BRIDGE_CC', 'XXX\XXXX', 'XXXX') I get the following error when this command is executed. C:/Ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect': IM014 (0) [Micr osoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (DBI::DatabaseError) from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:448:in `connect' from C:/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:221:in `connect' from C:/Data Syncronisation/Test Framework/FrameworkSetUp.rb:55 I have a BRIDGE_CC setup in my 'System DSN' tab in ODBC Data Source Administrator application. I dont think I need to install ruby on rails since I am not writing any application per se. I want to use Ruby for our data driven testing. Any help would be greatly appreciated.