On Wednesday, March 16, 2016 at 6:18:14 PM UTC-7, Jeremy Woertink wrote:
>
> Hey, I know this is a few years later, but I'm hoping you can help me. I
> have the same issue. I need to connect to an AS/400 system, but I'm not
> familiar with ODBC or AS/400. I don't understand the error I'm getting...
>
>
> require 'sequel'
> db = Sequel.odbc(drvconnect: 'driver={IBM i Access ODBC
> Driver};system=MYHOST;uid=MYUSERNAME;password=MYPASSWORD;')
> tables = db[:QSYS2__SYSTABLES].where("TABLE_NAME like ?", "SYS%")
> tables.each { |r| puts r[:table_name] }
>
> #=> Sequel::DatabaseConnectionError: ODBC::Error: IM002 (0)
> [unixODBC][Driver Manager]Data source name not found, and no default driver
> specified
>
> What's a "Data source name", and how do I specify it
>
I have no experience with AS/400, so I'm not sure. This doesn't appear a
Sequel issue. Please see if you can get a connection using ruby-odbc
directly. If you can post how get a connection with ruby-odbc, but can't
get it working with Sequel, I should be able to help getting it to work
with Sequel.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
