Question

ODBC Data Source Not Found

Quick Fields

Updated March 30, 2023

asked on March 23, 2023 • Show version history

Hello, I am working with a client on quick fields 9.0. They are using an external SQL table, and everything has been setup the same in ODBC for the system DSN as a working machine, they are both have 32 bit. When testing the connection for the field it succeeds, however we are still getting this error after entering in a field which when changed is supposed to populate the rest of the fields from the DB.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified[Method=ExecuteFirstResult]

Troubleshooting steps:

-Windows ODBC (laserfiche.com)
-Uninstall/reinstall QF

-Verified all settings for odbc were the same as other machines

-Ensured same QF session was being used on both machines

-Verified the document classification settings

0 0

Replies

replied on March 27, 2023

Hi Alexandro,

The data source is configured for real-time processes, right? By 'testing the connection for the field', does it mean to test the lookup in 'input' step on the machine that doesn't work?

0 0

replied on March 28, 2023

Yes, the data source is configured for real-time processes. When we test the lookup in the 'input' step, it returns a result successfully.

0 0

replied on March 30, 2023

Unfortunately I couldn't recreate the issue in my test environment with Quick Fields 9.0.1.496 to further investigate.

While I googled the specific error message and found something might worth trying:

Try to configure both user DSN and System DSN for this connection in the ODBC data source, and create DSN and test in both 32-bit/64-bit ODBC data source (https://learn.microsoft.com/en-us/answers/questions/227987/error-(im002)-(microsoft)(odbc-driver-manager)-dat?page=1#answers)
Switch to connection string (https://social.msdn.microsoft.com/Forums/en-US/48388e57-ae65-4ea0-b75c-defb49305d19/error-im002-microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-driver?forum=aspdatasourcecontrols )

0 0

You are not allowed to follow up in this post.

Question

Question

ODBC Data Source Not Found

Replies

Sign in to reply to this post.