From: Stephen Anderson <anderson@...>
Date: 2001-08-20T07:17:29+09:00
Subject: [ruby-talk:19995] DBI remote access question

Hello all,

I want to give my Ruby programs on a Red Hat Linux box the ability to
run SQL against
an AIX box running DB2.  The Red Hat box does not have DB2 installed at
this time.
The AIX box does not have Ruby installed.  I'm told another application
is communicating with this database using ODBC on a given port number.

DBI appears to be the toolkit for this job, and I'm trying to use the
sqlsh.rb example
program to test my installation and names.  So far I've had no success.

"ruby sqlsh.rb 'dbi:Mysql:database=test;host=localhost' sa ''" works
against a local Mysql database.

"ruby sqlsh.rb 'dbi:odbc:database=LSDB;host=<hostname>' username
password"
returns: "#<DBI::DatabaseError: S1090 (0) [unixODBC][Driver
Manager]Invalid string or buffer length>"

If I tunnel the ODBC port I was told from my local box to the DB2
server,
and run "ruby sqlsh.rb 'dbi:ODBC:database=LSDB;host=localhost' username
password"I get:
"#<DBI::DatabaseError: IM002 (0) [unixODBC][Driver Manager]Data source
name not found, and no default driver specified>".

Also tunneling: "ruby sqlsh.rb 'dbi:ODBC:LSDB' username password"
returns "#<DBI::DatabaseError: IM002 (0) [unixODBC][Driver Manager]Data
source name not found, and no default driver specified>"

Does this look like I'm using bad arguments to sqlsh.rb?  tunneling the
wrong port on my end?  have ODBC configured wrong?  need to use
proxyserver.rb?

If I need to use the proxyserver.rb, how do I do so with sqlsh.rb, or in
my own code?

Any help or advice is GREATLY appreciated since I'd really rather not
have to go back to Java for this project.

Thanks!