Data Connection

[Upali_Wijearatne]

Hi Friends

I want to connect my QV files now to remote my sql server. I tried so many times but failed to extablish connection.

Kindly help me with step by step procedure of how to create a connection to remote my sql server

Thanks

[Upali_Wijearatne]

Kindly help me to find a solution

[Chip_Matejowsky]

Hi @Upali_Wijearatne,

There are many how-to walkthroughs and YouTube videos available if you do a Google search. Some Qlik resources are listed below:

• Create a MySQL Enterprise Edition connection
• Qlik Connector - MySQL Enterprise Edition
• Community thread - how can I connect Qlikview to Mysql?
• Community thread - How do i load MySQL Database in Qlikview

If you have already reviewed all of these and are still experiencing issues, what error are you receiving?

Best Regards

[Upali_Wijearatne]

Thanks

I still get below error

[Chip_Matejowsky]

For ODBC,  that error message typically refers to the incorrect driver version > 32-bit or 64-bit.  Have a look at The Great ODBC Confusion from the Qlik Design Blog.  See also the Qlik Support article ODBC connection to SQL Server fails with error: Error: SQL##f - SqlState: 08001, ErrorCode: 17, Erro....

Best Regards

[Upali_Wijearatne]

Still I get above Message pls

[Chip_Matejowsky]

As stated previously, typically this error indicates that you have the incorrect version of the driver as described in the Qlik Design Blog post The Great ODBC Confusion.  If you are unable to get this sorted with an ODBC driver, you can try with an OLE DB driver.

Best Regards 

[Upali_Wijearatne]

Thank you very much for your efforts to help me. But I am not very much familiar with this subject. It is much appreciated if you kindly help me with Detailed step by step procedure