Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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-...

 

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...

 

Regards,

Craig

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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-...

 

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...

 

Regards,

Craig