Dbi odbc problem

Hello Everyone,

I’m currently trying to connect to a couple ODBC data sources via the
DBI module. When trying to connect to the first source, everything works
perfectly. When trying to connect to the second I receive the following
error:

C:/Ruby193/lib/ruby/gems/1.9.1/gems/dbd-odbc-0.2.5/lib/dbd/odbc/driver.rb:36:in
‘rescue in connect’ : HY000 (1) Missing connection parameters
(DBI:DatabaseError)

my code is as follows:


require ‘dbi’
conn=DBI.connect(‘DBI:ODBC:my_dsn_name’,‘uid1’,‘pwd1’)


The first data source is a SQLExpress data source and the second is a
jBASE data source.

Some extra info:
I have also written a small module in VB that can connect without
problems to both data sources using the VB ODBC library. However, when I
try to connect using that module without specifying the DSN anywhere
except for in the connection string, the same error is generated.

Any help would be appreciated!

Thanks

bump…

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs