I'm trying to connect Snowflake Data Warehouse using Sequel gem and
snowflake ODBC driver.
db =
Sequel.odbc(:drvconnect=>'driver={<PATH>/snowflake_odbc/lib/libSnowflake.so};server=abc.snowflakecomputing.com;role=sysadmin;database=TestDB;warehouse=LOAD_WH;user:admin;
password:password')
But I'm getting an error below and not able to figure it out.
<Sequel::DatabaseConnectionError: ODBC::Error: IM002 (0) [unixODBC][Driver
Manager]Data source name not found, and no default driver specified>
Can some please help me out in solving an issue?
Thanks
Saiyam Agarwal
On Friday, July 5, 2013 at 7:45:30 PM UTC+5:30, Wesley Staples wrote:
>
> Can anyone show me the correct syntax to use to make an odbc connection to
> an iseries / as400 database without using a DSN?
>
> I have tried Sequel.connect(:ADAPTER=>'odbc',:DRIVER=>'Client Access ODBC
> Driver (32-bit)',:SERVER=>'server ip',:UID=>'username',:PWD=>'pass') and I
> get the error message:
> c:/ruby192/lib/ruby/site_ruby/1.9.1/rubygems/core_ext/kernel_require.rb:45:in
> `require': LoadError: no such file to load -- sequel/adapters/
> (Sequel::AdapterNotFound)
>
> The reson I need a DSN-less connection is so I can modify the "default
> library" parameter.
>
> if anyone can show me how to specify a library/file that would probably
> work too and I could just use a DSN. I have tried:
>
> tabl = DB["QSYS2/SYSTABLES"].where("something here")
> tabl = DB["QSYS2.SYSTABLES"].where("something here")
>
> any syntax I try results in an error like table qsys2/systables not found
> in library *libl
>
> I have to go into my dsn and set qsys2 to be the default library then use
> DB[:SYSTABLES] for it to work.
>
--
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.
