topic Re: Cannot connect to a database from server in QlikView

Cannot connect to a database from server

Wed, 27 Aug 2014 14:15:59 GMT

Hello everyone,

In an application, I need a password to connect to the database. So I used the OLEDB connection and in the Connection tab, I have checked "Allow saving passord".

Then I can close my application, and then open it again and reload it without having to enter a password.

The problem is that I have pasted this application on the production server and the reload fails from QVS. The error is that it cannot

connect to the database.

The error is :

27/08/2014 16:04:50: 0007 OLEDB CONNECT*Provider*XPassword*

27/08/2014 16:04:50: Error: ErrorSource: (null), ErrorMsg: (null)

27/08/2014 16:04:50: General Script Error

27/08/2014 16:04:50: Execution Failed

27/08/2014 16:04:50: Execution finished.

What can I do ?

Is the line generated with OLEDB depends on which server I am ?

Thank you for your help

Re: Cannot connect to a database from server

Wed, 27 Aug 2014 14:19:40 GMT

Looks like this is not DB connection error. Please login to QV server and try to reload from Qlikview Desktop client on the server.

Re: Cannot connect to a database from server

Wed, 27 Aug 2014 14:22:06 GMT

hi,

u try to create oledb connection on production server then reload u r application through QMC?

Re: Cannot connect to a database from server

Wed, 27 Aug 2014 14:28:27 GMT

I have created my connection on a an application which is where all the applications that are reloaded in QMC are. (This server is DAT)

Then, QMC is on another server. (This server is BAK)

The server BAK reloads the applications that are stored on DAT.

Any ideas ?

I don't have QW desktop on the BAK...

Thanks for your help

Re: Cannot connect to a database from server

Wed, 27 Aug 2014 14:34:52 GMT

Don't you think it is a password problem ?

The thing is I don't have QV desktop on the server.

I only have it on a developpement server

Re: Cannot connect to a database from server

Wed, 27 Aug 2014 15:17:18 GMT

Hi,

have you check your QDS service running through same ID(For ex. u created OLEDB Connection through ID1 but u r QDS service running through another ID).