Who is this article for?

All On-Premise Ideagen Quality Management Admins and IT staff with appropriate permissions.

Ideagen Quality Management Web Server and site accessis needed.

ODBC connections that interact with Ideagen Quality Management have multiple parts to troubleshoot when an issue occurs. 

To make answering this question easier, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are looking for:

1. Question
2. Answer
3. Further Reading

1. Question

How are ODBC connection issues addressed? 

2. Answer

• Check the workflow instances for more detail about which step they may be stuck in.
• Check the error logs from Ideagen Quality Management (High and Medium) and Event Viewer logs on the Web Server. 
• If the error log reads - List field has no values - check the setup of the connection in Ideagen Quality Management. You can also look at the Application Pool in IIS to make sure the right account is being used, check the ODBC settings in the server application, look at the number of rows in the Excel file, and make sure the proper Excel drive is being used. 
• A space in the headers for Excel can cause a problem with putting the workflow definition online. You will get a message about No List Fields Configured. 
• Often issues are related to the file or source the connection is pointing at not being accessible. When a page is accessed with a list field that is populated from an external source, Ideagen Quality Management attempts to retrieve information from the ODBC connection. If the file cannot be reached there will be an entry in the Ideagen Quality Management High logs. If the name of the file is in the stack trace, then the file is most likely missing. If the stack trace contains unknown rather than a file name, the Ideagen Quality Management application pool does not have permissions to view the file the ODBC connection is pointed at.

3. Further Reading

This section will provide important links to further troubleshooting and resources. 

1. This article has details about initially setting up an ODBC connection. 
2. External Article - explains the architecture mismatch error that occurs when the installed Excel driver is not the correct one.