When I am executing .qvw from desktop working fine. But, when it is running on QMC throwing error as reload failed.
Log file showing
|02-02-2015 10:20:14 AM:||Error: OLEDB connection failed|
|02-02-2015 10:20:14 AM:||General Script Error|
|02-02-2015 10:20:14 AM:||Execution Failed|
|02-02-2015 10:20:14 AM:||Execution finished.|
Here by I have attached logfile
Any one please help me on this
Solved! Go to Solution.
you can do it 2 ways:
1.In QMC go to the Task which you have created and go to reload tab >here you will see the section access option ,please select this check box and provide the service account user name and passwords if any.
2.In the QV script add a inline table with your other access table in the section access as below:
load * inline
since its giving error with OLEDB please check with the connection string also once , try to create a fresh connection
hope this helps you
Most likely cause is that the service account under which publisher/server is running does not have access to the database.
Saranya Arumugam wrote:
Can you please suggest how to provide database access for Server
I can't really help you with that. I suggest that you contact your system administrator or database administrator for access.
In QMC, use the Section Access username and password fields to change the account under which the reload is being performed to the one that has access to the Database.
Or - as was suggested before - grant the service account access to the DB.