Hi All,
am trying to connect snowflake DB using connect
its throwing error:
Could not Connect to Database. Error number: 80004005 Microsoft]]ODBC Driver Manager] Data source name not found and no default driver specified
am using the below connection string:
Driver={SnowflakeDSIIDriver};Server=wpzmac-ll0952.snowflakecomputing.com;Database=******;uid=******;pwd=*****;
and i configured DSN in ODBC DATA Sources (64-bit)
can anyone help me to resolve the issue
thanks
Getting data sources correct takes time and experimentation. I might direct you to this page to help you determine the correct DSN string:
https://docs.snowflake.com/en/developer-guide/odbc/odbc
There are other threads on this board on the same topic and people struggle with it. I might consider contacting Snowflake and your IT department, as many other threads needed special ports opened for communication.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.