Error in server - Workflows not running and Unable to connect to database of type 'ODBC' with login: ' '

test

if you are 100% sure there was no change to the serverConf then it could be a change/update to underlying ODBC drivers, the error could indicate you have a Windows OS server?

The contradiction however lies in the sql state code IM002 which could indicate that the driver manager was requested to establish a connection using the DSN name defined in the serverConf, however the ODBC manager could not find that DSN configured in the registry. 

1. Check the serverConf, find out when was the last modification time.
2. Check when was the last time your server was Updated and if correlates to when the preproduction instance stopped working then you may find your culprit in a driver update. Then backup the server and rollback updates/uninstall. otherwise have your IT sys admin verify/confirm these findings, and you may be able to configure a connection under your ODBC manager and test that the current settings configured in the serverConf actually work outside of the adobe campaign environment and that windows can establish a connection.

Hi ​@CampaignerForLife, 

It looks like the connection with Snowflake is not working properly. 

I’d start by checking the Snowflake account in Adobe Campaign, as the log seems to show empty values for server and login. 

I’d also check the Snowflake setup on the pre-prod server, specially the driver and the DSN configuration. The error Data source name not found and no default driver specified usually means Campaign can’t find or access the  data source. 

Hope it helps, and if not, don’t hesitate on coming back. 

Best regards, 

Celia Castilla