Problem with loading Data From SQL

[#1]

Hi All,

I m new in QlikView

I'm traying to load data from MySql ,my problem that  I couldn't connect and I get this error :

Fehler bei der Verbindug : SQLSTate :'01000'

SQL Server-Fehler:11001()).

Fehler bei Verbindung:

SQLState :'08001'

SQL Server-Fehler:6

[Microsoft][ODBC SQL Server Driver][TCP/IP]Der angegebene SQL Server Konnte nicht gefunden werden.

Help please

[Clever_Anjos]

I agree with you, mixing drivers is not a good starting point

[#3]

I do the configuration another time after delete all the old config : I download the ODBC Connector , I selected it when I created a DSN user it work well but without return all the existence tables I attached a screenshot that details my configuration in both SDN and QlikView :

[#4]

this is the list of existance database it return only the first one :

[swuehl]

I guess it's an issue with user access permissions to your tables.

See

http://stackoverflow.com/questions/12529198/how-could-i-setup-a-user-to-be-used-with-an-odbc-in-mysq...‌

Connecting to MySQL using ODBC

MySQL and Access via ODBC — Uly.me

[#6 · Accepted solution]

yes yes you have right it is a problem of user access permissions.

Thanks alot for your help .

[swuehl]

If your issue is resolved, then please consider closing this thread, marking helpful and correct answers.

Qlik Community Tip: Marking Replies as Correct or Helpful