[Sqlrelay-discussion] Connecting from Ruby to FreeTDS to Microsoft SQL Server 7.0

[Ben G. <me...@be...>]

Hi,

I am working on setting up a new Debian 3.1 server. So far, I can use 
sqlrsh to query my database but I can't access the same sqlrelay connect 
via Ruby.. Would any of you know what I'm doing wrong? I've even copied 
my Ruby code to a Debian Woody server (which uses a Sybase driver 
instead of FreeTDS) and it works.

Thank you,
Ben Gribaudo

Example: (usernane/password/socket/port replaced with dummy values)
================================================
I can run this:
# sqlrsh localhost 8000 /tmp/name.socket user pass
SQLRShell - Version 0.22
       Connected to: localhost:8000 as user

       type help; for a help.

0> select * from sysobjects;
name                           id        xtype uid info status      
base_schema_ver replinfo parent_obj crdate                   ftcatid 
schema_ver stats_schema_ver type userstat sysstat indexdel 
refdate                  version deltrig    instrig    updtrig    
seltrig category cache
============================================================================================================================================================================================================================================================================================ 

sysobjects                     1         S     1   25   -2147483645 
68              0        0          Fri Nov 13 03:00:19 1998 0       
64         4                S    1        113  [...]

but if I try to run

require('sqlrelay')

puts "HERE!"
con=SQLRConnection.new("localhost",8000,"/tmp/name.socket","user","pass",0,1) 

cur=SQLRCursor.new(con)
cur.sendQuery("select * from sysobjects")
con.endSession()

for row in 0..cur.rowCount()-1 do
       rowarray=cur.getRow(row)
           for col in 0..cur.colCount() do
                puts rowarray[col]
             puts ","
          end
       puts "\n"
end

all I get is "HERE!" and then I'm back at a shell prompt.