title: ODBC connection string to Snowflake for Access Pass Thru Query
body: <p>I am trying to create a connection string to get to Snowflake data from Access 2010 and above. I can create a database DSN and link to the tables I use, but I need to build DSN-less connection strings for distributed applications. Here's what I have so far, it fails with the message "ODBC connection to xxxx failed". Here's what I have so far: </p>
  
  <p>ODBC;Driver={SnowflakeDSIIDriver}; Server=<a href="https://server" rel="noreferrer">https://server</a> name; Role=role name;Warehouse=warehouse name;Database=db name;Schema=schema name;UID=snowflake ID; PWD=snowflake password;</p>