Skip to main content

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

That’s an interesting question, Aman2024 !

I think the following community members may be able to help 

@Zaid Chougle 

@Tamil Arasu10 

@Sridhar Yadlapalli 

@Ashwin A.K 

@Padmakumar 

Hi ​@Aman2024 ,

 

In Automation Anywhere A360, when using the Connect action:

  • Ensure you are using the 64-bit version of the ODBC driver.
  • If you're using a DSN, make sure the bot runner has access to it.
  • If you're using a DSN-less connection, double-check the driver name and parameters
  • Try connecting using a simple script (e.g., in Python or a UDL file) to isolate whether the issue is with the connection string or Automation Anywhere
Terms & ConditionsCookie settings