Snowflake Connection String for Microsoft Access

user_8183648 0
Viewed 419

My company is switching from an Oracle 'on-prem' data warehouse to Snowflake cloud storage.

I support MANY Microsoft Access apps that use pass-through queries which use a simple string in the connection string property. Once a user had downloaded the appropriate Oracle Admin (X64) client, they are in business.

With snowflake, the client software is also a simple download. I am stuck, however, getting the connection string to work. Here is where I'm currently at:

ODBC;DRIVER={SnowflakeDSIIDriver};SERVER=xxxx.us-east-1.privatelink.snowflakecomputing.com;UID=xxx@xxx.com;PWD=xxx;WH=XYZ;DATABASE=XYZ;ROLE=XYZ

(This string returns error: ODBC--call failed. No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command. (#606))

Has anyone successfully managed to connect a Microsoft Access Pass-through query to Snowflake and retrieve results?

(Please note, the authenticator is not externalbrowser)

(MS Access 365 for Enterprise, 64-bit)

snowflake-cloud-data-platform ms-access
2 Answers

Optional Connection Parameters

warehouse (Warehouse)

Specifies the default warehouse to use for sessions initiated by the driver.

WH=XYZ; should rather be WAREHOUSE=XYZ;

user_50708790

Ok, to those who may be interested, the below works for the pass through query connection string property:

ODBC;
driver={SnowflakeDSIIDriver};
server=xxxxxxxxx.xx-xxxx-x.xxxxxxxxxx.snowflakecomputing.com;
database=xxxxxxxxxx;
warehouse=xxxxxxxxxxxxxxxx;
role=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;
Uid=xxxxxxxxxxx@xxxxxxx.com;
Pwd=xxxxxxxxx;
user_81836480
Related