Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jarleeagudo
New Contributor

Qlikview ODBC Driver package to Sybase Connection error

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

5 Replies
jwjackso
Valued Contributor

Re: Qlikview ODBC Driver package to Sybase Connection error

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

jarleeagudo
New Contributor

Re: Qlikview ODBC Driver package to Sybase Connection error

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!

jwjackso
Valued Contributor

Re: Qlikview ODBC Driver package to Sybase Connection error

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.

jarleeagudo
New Contributor

Re: Qlikview ODBC Driver package to Sybase Connection error

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.

jwjackso
Valued Contributor

Re: Qlikview ODBC Driver package to Sybase Connection error

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.