Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have my applications in a sandbox. One for QVD Generation and another is an end-user application. Both the applications reloads just fine in the desktop. However, when the batch job is executed fails with below error:
2017-11-10 09:55:20 0094 ODBC CONNECT TO *** (XUserId *** ***, XPassword *** ***)
2017-11-10 09:55:21 Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2017-11-10 09:55:21 SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2017-11-10 09:55:21 Execution Failed
2017-11-10 09:55:21 Execution finished.
I have tried troubleshooting by 1. creating an OLEDB connection string instead of ODBC and 2. Creating SYStem DSNS for 32 bit architecture and adding Forced 32 bit connection strings. oth approaches failed. Is there any possible reasons to resolve this issue?
Regards,
Sai
Hi,
By Batch-job do you mean the Qlik reload engine? Did you define the ODBC connection as a system connection or a user-connection? Looks like you made the connection on user-level and the user that runs the batch job can not then "see" the connection. Or the user does not have sufficient access rights.
Hi Issue has been resolved. I am using ODBC conn string placed in a separate file in the respective folder