topic Re: Qlikview ODBC Driver package to Sybase Connection error in QlikView

Qlikview ODBC Driver package to Sybase Connection error

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

I've tried using the Qlikview ODBC Driver Package on Qlikview to connect to one of our Database.

But when I tried using the select button on the connection wizard.

Is there any steps i need to do to?

My Qlikview Version is a Personal Edition.

and my Qlikview ODBC Driver Package version:

Asking any experts on this issue to help me solve this

Thank you in advance

Re: Qlikview ODBC Driver package to Sybase Connection error

jwjackso — Fri, 04 May 2018 20:33:38 GMT

Did you create an ODBC connection in the Windows "ODBC Data Source Administrator"?

Re: Qlikview ODBC Driver package to Sybase Connection error

Anonymous — Mon, 07 May 2018 02:47:44 GMT

Hi Jerry,

No not yet. I don't have the Sybase ODBC Driver installed on me but can i use the Qlik.sybase driver?

I'm not yet familiar with the ODBC drivers

Thank you!

Re: Qlikview ODBC Driver package to Sybase Connection error

jwjackso — Mon, 07 May 2018 11:32:28 GMT

Did you get a successful result from the "Test Connection" button? If the test was successful, do you have permission to query the tables?

If you are using the QvODBCConnectorPackage, you will not have to use the ODBC Administrator tool.

Re: Qlikview ODBC Driver package to Sybase Connection error

Anonymous — Mon, 07 May 2018 11:50:05 GMT

Yes i've downloaded the QvODBCConnectorPackage and got a "Connection Succeeded" message when i test the connection. But when using the Select button it gives me an error.

Re: Qlikview ODBC Driver package to Sybase Connection error

jwjackso — Mon, 07 May 2018 18:37:04 GMT

Instead of using the GUI to build a query, save the connection. In the script, try a simple query:

Test:

SQL Select getdate() as Today;

If the query worked, you should have a table with 1 row.