Skip to main content
Question

Has anyone created an ODBC Reader connecting with a Snowflake Driver?

  • May 7, 2019
  • 3 replies
  • 45 views
J
Forum|alt.badge.img

When creating the reader, I get the following error. I know this driver works because I was able to make an ODBC connection in Excel. I'm using FME 2019 32bit and created the source in a 32bit ODBC Data Source Admin.

 

Error connecting to database

Database Generated Error Information:

Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Database SQL Statement Text:

SQL State: IM002

Variable Information:

ODBC 3.x Reader: Failed to connect to database

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

N

@janezx - my team and I would be happy to help you with this issue. Please contact me @ to coordinate next steps.

nampreetatsafe
Safer
Forum|alt.badge.img+13

Just updating this thread. @janezx opened a support case. She resolved the connection error after determining that it was a permissions issue in Snowflake. @janezx, feel free to provide any more info if you think it would be helpful to other's in the Community.

S
  • safegis
  • December 16, 2019

There was mention that Snowflake reader/writer support and native connectivity in 2020. Judging by this thread, sounds like the ability to connect is already there. We are on version FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN32). What is the best way to get set up?

Community Stats

32,182
Posts
122,176
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.