Issue Connecting Ignite via ODBC

classic Classic list List threaded Threaded
3 messages Options
wallace321 wallace321
Reply | Threaded
Open this post in threaded view
|

Issue Connecting Ignite via ODBC

Summary of the problem: Cannot connect to Ignite via ODBC b/c of driver issues
Platform: Windows 10, Windows Server 2012 R2
Goal: Be able to connect Qliksense (BI tool) to Ignite database

I've configured the Ignite ODBC driver on Windows 10 (the basic test environment) just like the screenshot shows (The address field is IP:Port and the cache is the table name in Ignite, I redacted that for privacy) - this matches the picture found here connecting-string but when I try to connect to the database with the DSN, we get the error "Data type is not supported." in Razor SQL, a DB visualizer with ODBC support Razor SQL. The DSN was created successfully in ODBC Administrator, so we are not sure what's going on.

When we attempt to do the same process in Windows Server 2012 R2 (the Qliksense environment), the installation of the driver appears to go smoothly, however we cannot create the new DSN in the ODBC Administrator program, b/c we get the error "ignite.odbc.dll" cannot be found. That DLL is present however, in the path: "C:\Program Files\Apache Ignite\ODBC Driver" so we cannot proceed to even test the ODBC driver in a mock prod environment.

Has anyone ever been successful in connecting Ignite to Qliksense? Qlik-ODBC

devis76 devis76
Reply | Threaded
Open this post in threaded view
|

Issue Connecting Ignite via ODBC

Thank you for your mail, I will be on vacation until August 8th with no access to mail or voice mail so please expect some delay in my answers.


urgent request write to [hidden email]

Best regards
Devis Balsemin

Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|

Re: Issue Connecting Ignite via ODBC

In reply to this post by wallace321
wallace321 wrote
...but when I try to connect to the database with the DSN, we get the error "Data type is not supported." in Razor SQL, a DB visualizer with ODBC support Razor .
As far as I remember, Ignite's ODBC driver was not tested with Razor SQL.

wallace321 wrote
When we attempt to do the same process in Windows Server 2012 R2 (the Qliksense environment), the installation of the driver appears to go smoothly, however we cannot create the new DSN in the ODBC Administrator program, b/c we get the error "ignite.odbc.dll" cannot be found. That DLL is present however, in the path: "C:\Program Files\Apache Ignite\ODBC Driver" so we cannot proceed to even test the ODBC driver in a mock prod environment.
Probably, you don't have c++ libraries installed on your system. If you are using installers, which are shipped with Ignite binary release, try installing visual c++ 2010 redistributable tools.