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
  • 92 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+14
  • Automation Anywhere Team
  • 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.