From: Ed Hardy <asm.sol@...>
Date: 2008-11-25T05:39:20+09:00
Subject: ODBC, 'Sql server', XP:  beyond connection

I believe I've connected to Microsofts' SQL Express, however, I'm stuck.

I'm happy this succeeds!
Using Windows XP, 1-Click Installer Ruby/Windows installation (1.86).
Using ODBC, and SQLEXPRESS 2005.

I can read all the columns in a row, but not individual columns with
'rows[]'.

#--CODE--

require 'dbi'
dbh= DBI.connect('DBI:ODBC:driver=SQL
Server;server=ehcomp;database=my_project;uid=sa;pwd=password')

rows= dbh.select_all('select projno,project,projshort from projects')

puts rows[0]  # outputs the three columns on row 0

dbh.disconnect

#---END CODE---

How do I output individual columns with rows?

A lot of things are additionally problematic, like 'fetch' returns an
error, 'execute' returns a 'garbage collection' error.  I've got this
far using 'select_all'.

Is there a windows/ruby/ODBC/SQL server online help somewhere?
-- 
Posted via http://www.ruby-forum.com/.