I have created an app with a Store command. When I reload the script is works perfectly on the desktop but when I hand it off (to IT) to be loaded on the server this trips a general script error. Would anyone know how I can avoid this error?
Hi Mr Jhon,
please elaborate more (add some screen shots, sample app, etc) in order to help you with your issue.
When you say "hand it off" you mean publish and reload it via QMC? Fails on the first load?
Will be waiting for your comments.
Check this time,
6/28/2016 11:36:33 AM
Showing some Access error with Uname and Pwd
The error shows in log is not with store statement. It is some DB username and password issue. Please try to connect to DB and after select statement you write Exit script and check. If it works then Store command will also works.
Did you define the odbc data source (system data source) on the server and/or did you installed the driver for the db you're using? Also it seems (connect32) you're using a 32 bit connection.
6/28/2016 11:36:33 AM: 0008 ODBC CONNECT32*XUserId*XPassword*
6/28/2016 11:36:38 AM: Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
6/28/2016 11:36:41 AM: General Script Error
6/28/2016 11:36:42 AM: Execution Failed
6/28/2016 11:36:46 AM: Execution finished.