Problem
When running an SQL query against Snowflake, you might encounter the following error:
Error : nanodbc/nanodbc.cpp:1138: 00000 [Snowflake][Support] (50404) Invalid connection string.
Solution
This error typically occurs when a value is set for an additional parameter without specifying a key. Ensure that every parameter in your connection string is correctly formatted with both a key and a value.
Below is an example of the “Without specifying a key” case that caused the issue.
And below is the correct way to set Additional Value, which has a key.
