On Mon, Aug 9, 2021 at 12:56 PM Yoni Eilon <[email protected]> wrote:
> Hi Jeremy,
>
> Thanks for the reply, still trying to check I'm able to connect using the
> Ruby ODBC driver.
>
> In the mean time, I tried to connect using "Sequel.odbc" method instead of
> "Sequel.connect", like this:
> *db = Sequel.odbc('SnowflakeDSII', user: 'XXXX, password: 'YYYYY')*
>
> And this does work... Any idea why this works and "connect" doesn't?
Needless to say the DSN I point to in the ".odbc" method is the same as the
> one I pass as the "driver" parameter of the "connect" method (in this case,
> it's the path to Snowflake's ODBC driver on
> Mac: /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib)
>
Passing the :driver option when connecting via ODBC changes the behavior to
use ::ODBC::Database.new.drvconnect. If you want to use ODBC.connect, you
shouldn't pass the :driver option. If you want to use Sequel.connect
instead of Sequel.odbc, you could try:
Sequel.connect('odbc:///SnowflakeDSII?user=XXX&password=YYY')
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 view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/CADGZSSffkrcQQcGLK%2BVnnhX_zyPKgKY9YLoyXgVrHvgYDX%2BT8w%40mail.gmail.com.
