Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For my report I fetch the data from the Database.
I was using the same database more than six month.
Suddenly now when I try to reload my report form the same database its not refreshing the data properly .
I tried reloading it manually, It throwed an error as below.
"SQL error: no error
Script Line: select feilds from the databse table name.
Could anyone please help me out.
It seems to be an scripting problem. I'm guessing but are you reading from a table or from a view? If so, do you have permissions enough to read? Have you changed anything in your data source? Have you changed the code of your load script?
Is there a username/password combination in your connection string and is it up to date?
Was something like a virus killer installed on the database server or on the QV server?
I am reading from the same database table.
I have and use the same permissions,have not changed any datasource name and load script.
Could you please tell me how a Virus killer in database can affect the information to be fetched.
This was something we stumbled on to in QV 8.5
McAfee uses a port that is also used by the QV Server. That means that a connection from the outside can fail. Of course there is a solution around it.
But that would only be a factor when you try to access your QV documents from the outside, not when you already have the document and are having issues with loading data. So it's indeed not a factor in your problem.