Skip to main content
Question

Could not Connect to Database. Error number: 80004005 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

  • September 24, 2024
  • 1 reply
  • 49 views

Forum|alt.badge.img

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

1 reply

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 544 replies
  • September 24, 2024

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings