Question
Brown Advisory
IN
Last activity: 25 Mar 2024 7:23 EDT
Couldn't find Snowflake driver in ODBC component in latest version 22.1
Hi Team,
In 19.1 we can connect to the Snowflake database using the ODBC query component connection string. But in the latest version, we couldn't find the snowflake driver listed in the drivers. (I have a snowflake driver installed on my machine).
Accepted Solution
Updated: 25 Mar 2024 7:23 EDT
Pegasystems Inc.
US
@SushmaM16948715The issue might be the bit-ness of the driver. If you are running the 32-bit drivers, you will likely need to use the 64-bit version. I believe 22.1 runs with the operating system bit-ness whereas 19.1 would run 32-bit unless otherwise specified.
Pegasystems Inc.
US
@SushmaM16948715To clarify, do you have Studio 19.1 and Studio 22.1 installed on the same machine? ODBC drivers are typically installed per machine, so I want to make sure you have the same drivers installed. Ideally, I would have 19 and 22 on the same machine for testing.
Brown Advisory
IN
@ThomasSasnett I only have Studio 22.1 on my machine, I have uninstalled 19.1.
Pegasystems Inc.
US
@SushmaM16948715 Do you have a 64-bit version of the driver to install?
Accepted Solution
Updated: 25 Mar 2024 7:23 EDT
Pegasystems Inc.
US
@SushmaM16948715The issue might be the bit-ness of the driver. If you are running the 32-bit drivers, you will likely need to use the 64-bit version. I believe 22.1 runs with the operating system bit-ness whereas 19.1 would run 32-bit unless otherwise specified.
Brown Advisory
IN
@ThomasSasnett Yes, I have tested with 64-bit and it is working fine.