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)
Thanks,
Yoni.
On Tuesday, August 3, 2021 at 5:40:36 PM UTC+3 Jeremy Evans wrote:
> On Tue, Aug 3, 2021 at 4:47 AM Yoni Eilon <[email protected]> wrote:
>
>> Hi,
>>
>> I'm still trying to solve this issue... Now I'm trying to use iODBC
>> Manager driver (libiodbc) instead of unixODBC.
>>
>> However, when I try to use *Sequel.connect *with the "driver" parameter
>> receiving the path to the Snowflake driver
>> (/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib on MacOS), I
>> get this error:
>> *IM003 [iODBC][Driver Manager]Specified driver could not be loaded*
>>
>> Does Sequel work with other ODBC drivers on MacOS, such as libidobc, or
>> only with unixODBC?
>>
>
> Sequel's odbc adapter should work in any case where the underlying ruby
> odbc driver works. If you can get a connection using the ruby odbc driver,
> then you should also be able to get Sequel's odbc adapter to work. If you
> cannot get a connection using the ruby odbc adapter, there is no way that
> Sequel's odbc adapter will work. As to the question of whether the ruby
> odbc driver supports libidobc or unixODBC, you would have to ask the
> developers of the ruby odbc driver.
>
> 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/4846962d-7fab-4556-b97e-b287a360aabdn%40googlegroups.com.
