Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Found the solution - I set up the ODBC connection as user DNS...should have done it as System DNS...now its working fine.
Found the solution - I set up the ODBC connection as user DNS...should have done it as System DNS...now its working fine.