ODBC Connection error

[xyz_1011]

Good Morning all.

I have a strange case: In an app i am connecting to a SQL server via an ODBC connection. This works fine, when i run the script manually (even on the QV server). As soon as the server (via a Publisher task) tries to reload the (same) document, i am getting the following error:

Error: Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have no idea why this happens. Hopefully someone here can shed some light.

Thanks in advance!

[xyz_1011 · Accepted solution]

Found the solution - I set up the ODBC connection as user DNS...should have done it as System DNS...now its working fine.