Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

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.

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

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.