You are viewing limited content. For full access, please sign in.

Question

Question

Quick Field Agent

asked on March 23, 2016

I am using the Quick Fields Agent and keep getting the same error code.

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

All of our QF sessions run fine manually but not with auto agent.

We are on RIO 10 Quick Fields 9 and agent 9.

0 0

Answer

SELECTED ANSWER
replied on March 23, 2016

For Quick Field Agent , as it is mentioned in previous post it runs with the account set for the service.

If the Quick Field Agent service was set to run as windows userB but the ODBC was set to use User type and created under userA, then userB does not have access to the ODBC settings.

Launch the ODBC Data Source Administrator for  32 bits (Quick Fields is a  32 bit application), then ensure the ODBC setup is set for System DSN and not User, if it is set for User DSN then the odbc driver setup only works for the user that creates the DSN , if you created instead under System then it works for any user that logs into the machine.

0 0

Replies

replied on March 23, 2016

What account is the QF Agent Service using?  Please change it to a domain account and make sure that the account has rights to the ODBC source.

0 0
replied on March 23, 2016

See here for more details

1 0
replied on March 23, 2016

It is using a domain account. The agent had been working and then it just stopped and started giving us the error.

0 0
replied on March 23, 2016

Hmm. Did the password to this domain account change recently? 

Is your session using Windows Authentication to connect to the ODBC source?

0 0
replied on March 23, 2016

There was no password change. I tried both types of connection. Im not sure if this would be causing an issue that it shows agent 8 but in the help menu says agent 9... We tried an re-install and it didn't change anything

0 0
replied on March 23, 2016

Try changing the domain account in the service itself.  Is it the same account you are using to login to windows? If not, change it to that account then test it again.
Can you ask your IT if any changes were made to the original account?

0 0
replied on March 23, 2016

I have tried using  my account as well  and get the same problem. No changes were made to the account

0 0
replied on March 23, 2016 Show version history

Please talk to your VAR who should then open a Case with Support so we can look further into the matter.

0 0
SELECTED ANSWER
replied on March 23, 2016

For Quick Field Agent , as it is mentioned in previous post it runs with the account set for the service.

If the Quick Field Agent service was set to run as windows userB but the ODBC was set to use User type and created under userA, then userB does not have access to the ODBC settings.

Launch the ODBC Data Source Administrator for  32 bits (Quick Fields is a  32 bit application), then ensure the ODBC setup is set for System DSN and not User, if it is set for User DSN then the odbc driver setup only works for the user that creates the DSN , if you created instead under System then it works for any user that logs into the machine.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.