10/26/2023 3:44:59 PM deliveryEmail432 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01

Question

Hi All

we are facing this error in workflow

10/26/2023 3:45:11 PM deliveryEmail42222222222222 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:10 PM deliveryEmail4222222222222 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361930
10/26/2023 3:45:10 PM deliveryEmail4222222222222 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:09 PM deliveryEmail42223 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361987
10/26/2023 3:45:08 PM deliveryEmail42223 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:06 PM deliveryEmail4322 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361986
10/26/2023 3:45:06 PM deliveryEmail4322 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:04 PM deliveryEmail4222222222 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361929
10/26/2023 3:45:04 PM deliveryEmail4222222222 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:03 PM deliveryEmail422222222 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361941
10/26/2023 3:45:03 PM deliveryEmail422222222 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:45:01 PM deliveryEmail4222 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361985
10/26/2023 3:45:01 PM deliveryEmail4222 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
10/26/2023 3:44:59 PM deliveryEmail432 WDB-200001 SQL statement 'SELECT iState, iSandboxMode FROM NmsDelivery WHERE iDeleteStatus=0 AND iDeliveryId=?' could not be executed. Param(0)=886361982
10/26/2023 3:44:59 PM deliveryEmail432 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01

how can we fix this issue

it seesm issue is related to ODBC Diber --please help to understand where we can check in Marketing/app server check this ODBC connecitvyt

what could be the cause of this issue and how we can fix this

please help

Craig_Thonis · Accepted Answer

Hi Shrutii,Have you checked out the documentation and suggestions provided by Microsoft?https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-215-hands-on-labs-communication-link-failed-error/ba-p/3565011 It appears that the above was used to address the same problem that occurred with another client a few months back. https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/08-27-2023-7-47-39-am-odb-240000-odbc-error-microsoft-odbc/m-p/617705#M19398 Regards,Craig

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded