I can't get it working with the ODBC::Database.new.drvconnect either. The
only way I've been able to get this to work is just using `isql`. I don't
know much about this stuff, but I assume that isql pulls from the
/etc/odbc.ini config.
When I do straight ODBC I get the same error as I do with Sequel. I'm sure
it's not a "sequel" issue, but I can't find any other forums where people
are using ruby and odbc :/ Gonna try jruby with jdbc and hope I get
something with that.
On Wednesday, March 16, 2016 at 6:38:39 PM UTC-7, Jeremy Evans wrote:
>
> 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.
