0

I'm trying to setup Snowflake on a Mac. When trying to the DNS settings within iODBC, the odbc.ini file is not picked up automatically by iODBC data source admin. When I try to add the DNS manually, iODBC crashes. I have the most recent iODBC installation, as well as the most recent Snowflake drivers. I can post the iODBC crash log if needed. Thanks!

Install Snowflake drivers and add DNS into iODBC data source administrator. Wanting to pull a pivot table into Excel.

Robben Hilton
  • 1
  • Have you installed the right ODBC for your platform? MAC M1 or Intel? – Sergiu Apr 20 '23 at 12:15
  • I believe so, downloaded from here - https://developers.snowflake.com/odbc/ – Robben Hilton Apr 20 '23 at 13:00
  • There are 2 versions there: `macaarch64` for M1 and `mac64` for Intel. If you check your Mac-> `About This Mac` do you see an `Core Intel Core i<3/5/79>` processor or M1? – Sergiu Apr 20 '23 at 13:05
  • It's using i7. I've downloaded the mac64 version from this link https://developers.snowflake.com/odbc/ – Robben Hilton Apr 20 '23 at 13:10
  • Add the log then, as that might help. – Sergiu Apr 20 '23 at 13:19
  • It's saying that x86_64h is required. – Robben Hilton Apr 20 '23 at 13:28
  • [iODBC][Driver Manager]dlopen(/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib, 0x0006): tried: '/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib' (mach-o file, but is an incompatible architecture (have 'arm64', need 'x86_64h')), – Robben Hilton Apr 20 '23 at 13:37
  • Can you run this in a terminal and show the output: `file /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib` – Sergiu Apr 20 '23 at 13:56
  • robben@admins-MacBook-Pro-4 ~ % file /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib: Mach-O universal binary with 2 architectures: [i386:Mach-O dynamically linked shared library i386] [x86_64] /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib (for architecture i386): Mach-O dynamically linked shared library i386 /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib (for architecture x86_64): Mach-O 64-bit dynamically linked shared library x86_64 robben@admins-MacBook-Pro-4 ~ % – Robben Hilton Apr 20 '23 at 14:01
  • That looks ok, can you try following the steps from [here](https://community.snowflake.com/s/article/How-to-create-Snowflake-ODBC-DSN-On-MacOS) and see if you still have the issue? – Sergiu Apr 20 '23 at 14:52

0 Answers0