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