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? Thanks, Yoni. On Wednesday, July 7, 2021 at 6:05:07 PM UTC+3 Jeremy Evans wrote: > On Wed, Jul 7, 2021 at 6:11 AM Yoni Eilon <[email protected]> wrote: > >> We use Sequel to query Snowflake from Ruby code using the ruby-odbc gem. >> >> When there is a problem with the query in Snowflake, we don't get back an >> understandable error from the Sequel, but just a general ODBC error, with >> something that looks like an SQLSTATE code. >> >> For example, when I run this query on Snowflake, trying to query a non >> existent table named "bla": >> >> *res = conn.fetch("select * from bla").all* >> I get back this error: >> *Sequel::DatabaseError (ODBC::Error: 4 (2003) S)* >> >> Instead of: >> "*Object 'BLA' does not exist or not authorized*" >> >> We're using: >> Sequel gem - 5.38.0 >> ruby-odbc gem - version 0.99999 >> Snowflake ODBC driver - version 2.21.6 >> Ruby - version 2.6.6 >> >> Any help would be highly appreciated. >> > > I'm guessing you get that error because the ODBC driver uses "4 (2003) S" > as the exception message. Not much Sequel can do in this case. If you > want this fixed, you'll probably need to fix the 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/cffda3be-0c00-4b97-804c-9b38d02ac075n%40googlegroups.com.
