topic Re: Qv app refreshes at local but not in QV Server in QlikView

Qv app refreshes at local but not in QV Server

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

We are using Informix DB for our projects.

QV loader is running successfully at local but it's getting failed in QV server, specifying that Error: ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified .

We are able to connect database and can fetch the data.

We were using driver client 4.90... and yesterday we downgraded to 2.90, still issue not resolved.

I googled for this issue at we have less discussions on informix db issues.

We are having special characters in our password,is it the issue?? but in one of our projects this scenario is working fine.

what could be the issue is?

Can anyone light up on this issue.

marcowedel stalwar1 Gysbert Wassenaar Avinash R marcus_sommer

Re: Qv app refreshes at local but not in QV Server

avinashelite — Wed, 04 Apr 2018 07:19:04 GMT

1.Your using OLEDB or ODBC connection ?

if its ODBC then you have to add the DSN in server with the name your using in connection

2.Check whether required drivers are installed in the QV server for informix DB

Re: Qv app refreshes at local but not in QV Server

krishna20 — Wed, 04 Apr 2018 10:13:30 GMT

Hi,

It's OLEDB connection.

Drivers are installed and test connection succeeded.

Re: Qv app refreshes at local but not in QV Server

michael123 — Wed, 04 Apr 2018 10:17:44 GMT

Are you using same AD-user in both instances? Has account running QVS access rights to database?

Re: Qv app refreshes at local but not in QV Server

krishna20 — Wed, 04 Apr 2018 11:48:36 GMT

Yes all settings has been given correctly.But don't know why the application is failing in QV server.

Re: Qv app refreshes at local but not in QV Server

avinashelite — Wed, 04 Apr 2018 12:21:21 GMT

Did you checked in the server , whether the connection is working fine or not ? if you have server access login to server and check the connection

Re: Qv app refreshes at local but not in QV Server

krishna20 — Wed, 04 Apr 2018 12:48:11 GMT

Hi Avinash,

Connection getting successful.

Re: Qv app refreshes at local but not in QV Server

avinashelite — Wed, 04 Apr 2018 13:33:26 GMT

you tried this in the server ?

Re: Qv app refreshes at local but not in QV Server

Colin-Albert — Wed, 04 Apr 2018 13:35:27 GMT

Your connection is using ODBC (OLEDB for ODBC), so have you added the ODBC datasource on the server with exactly the same name as on the machine where the app was created?

Do you have QV Desktop installed on the server?

If so, logon to the server using the account running the QDS service, and try loading the app manually on the server, this should show you the error.

Have you enabled the document log? If so, the log file will also show the cause of the error.

Re: Qv app refreshes at local but not in QV Server

krishna20 — Wed, 04 Apr 2018 13:42:09 GMT

I am working in server only and above screenshot is from server.

Re: Qv app refreshes at local but not in QV Server

krishna20 — Wed, 04 Apr 2018 13:46:29 GMT

Yes, ODBC data sources name were given on same name and working in server with QV desktop.

App successfully refreshed by manually in the server, but it's getting failed in QMC.

Re: Qv app refreshes at local but not in QV Server

Colin-Albert — Wed, 04 Apr 2018 13:52:06 GMT

Does the app run if you logon to the server using the same account as the QlikView distribution service?

Server reloads run using the distribution service credentials.

Re: Qv app refreshes at local but not in QV Server

krishna20 — Thu, 05 Apr 2018 07:15:26 GMT

Wonderful Colin. Thanks for giving a solution

I remapped all services to the account which i am logged in.