If you receive the following error when importing data using Orchestrate Data Flow, this article explains what causes it and the steps you can take to resolve it.
⚠️Error: ERROR [08004] [Microsoft] [ODBC Text Driver] too many client tasks. ERROR [08004] [Microsoft] [ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
This error is caused by an issue with the ODBC 64-bit connection on your PC.
Resolve the error
Work through the following steps in order. Try the import again after each step to check whether the issue is resolved.
Step 1: Download Microsoft Data Access Components (MDAC) 2.8
Download the Microsoft Data Access Components (MDAC) 2.8 Software Development Kit from the Microsoft website.
Install MDAC 2.8 and restart your PC.
Try the Orchestrate Data Flow import again.
Step 2: Upgrade to Windows 11
If downloading MDAC 2.8 does not resolve the issue, upgrading your PC to Windows 11 may resolve the ODBC 64-bit connection problem.
Upgrade your PC to the Windows 11 operating system.
Try the Orchestrate Data Flow import again.
If the issue persists
If you are unable to upgrade to Windows 11 at this time, we can add an SQL command to your Orchestrate database to force the Microsoft 64-bit Access Text driver to read the file path where your CSV files are kept.
To request this, raise a new case online and reference the title of this article in your case.