topic Connector Reply Error in QlikView

Connector Reply Error

akpofureenughwu — Wed, 10 May 2017 10:53:02 GMT

Good day everyone....

I have some set of data in sql server environment.... I used the oledc connector to fetch the data from sql...

I got the error message on my qliksense app..... connector reply error....

I have carefully inspect the sql script and there is no strange thing there ( I attached the sql schema in a notepad file)

Please kindly inspect them or better still load them in your app to see if you get the same error..

TThank you for your time,

Regards

Re: Connector Reply Error

Wed, 24 May 2017 08:22:30 GMT

Hi Akpofure,

I am having exactly the same problem! I am connecting using an ODBC connection. The ODBC connection is using PuTTY to connecti via an SSH tunnel to a MySQL database. My queries execute correcty in my usual software, but, I cannot get Qlik Sense to work.

Chloe.

Re: Connector Reply Error

akpofureenughwu — Thu, 25 May 2017 15:41:37 GMT

Hello Chloe,

I think you have to review your table in the sql you want to pull data from.

Re: Connector Reply Error

Anonymous — Wed, 28 Mar 2018 09:51:13 GMT

Hi,

I have exactly the same problem. Have you already now how to this this?

Thank you!

Re: Connector Reply Error

wdchristensen — Wed, 28 Mar 2018 16:44:53 GMT

On some of the older versions of Qlik the AD authentication didn't work for me so I had to use a service account. Might try hard coding your connection (username / password). AD authentication seems to work fine on Feb 2018.

Re: Connector Reply Error

likecashdev — Wed, 11 Apr 2018 16:29:31 GMT

Try this,

SET param1 = ''paramhere;

SQL EXE [dbname].[dbo].[storedprocedure] '$(param1 )';