topic Re: Problem with loading Data From SQL in QlikView

Problem with loading Data From SQL

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Problem with loading Data From SQL

Clever_Anjos — Wed, 06 Apr 2016 21:40:34 GMT

Which database you want to connect?

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

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

Re: Problem with loading Data From SQL

swuehl — Wed, 06 Apr 2016 21:43:45 GMT

Have a look at

QV connectivity to mySQL

Have you tried the recent Qlik ODBC drivers as indicated in the referenced thread by Peter? I think you can download them also from QlikMarket.

Re: Problem with loading Data From SQL

Wed, 06 Apr 2016 22:02:05 GMT

Thank you .

I'm traying to connect to MySQL .I will list you what I have done .

1-I loaded 'mysql-connector-odbc-5.1.8-win32'

2-I created a DNS .by selecting :dBASE Files ->MySQL ODBC 5.1 Driver-> I puted the defference paraöeters of my base and in this stage and in the field 'Database' from where should I select my database the system display only the fisrt databases thai is ''information_schema'' I so I didn#t select it and I saved without specify any Database.

3-Then from QlikView after selecting ODBC and testing the connection ##Connection Test Succeded## but allways without displaying my desired database.(this time it didn#t generated the same last problem ).

Re: Problem with loading Data From SQL

Wed, 06 Apr 2016 22:05:47 GMT

Thank you .

Yes I did the same steps.

Re: Problem with loading Data From SQL

Clever_Anjos — Wed, 06 Apr 2016 22:11:44 GMT

Could you post here, your script (with your connect) and a screenshot of your ODBC connection?

Re: Problem with loading Data From SQL

Wed, 06 Apr 2016 22:31:32 GMT

and now it genertate the first problem :

Re: Problem with loading Data From SQL

andrespa — Thu, 07 Apr 2016 09:28:15 GMT

Hi, could it be something about the architecture of both the connector and the DB?? (Trying to connect from a 64bits DB eith a connector of 32 bits)

Hope it helps,

Andrés

Re: Problem with loading Data From SQL

swuehl — Thu, 07 Apr 2016 09:34:20 GMT

Is MySQL a qualified server name? Have you tried using an IP address instead?

And are you sure you are using the correct MySQL ODBC driver (looks more like a MS SQL Server driver)?

Re: Problem with loading Data From SQL

Clever_Anjos — Thu, 07 Apr 2016 11:45:51 GMT

Are you using a SQL Server driver to connect to a MySQL server?

I don´t think it´s supposed to work.

Maybe if try the QvOdbcConnectoPackage selecting the MySQL driver, you can have sucess:

Re: Problem with loading Data From SQL

Clever_Anjos — Thu, 07 Apr 2016 11:49:07 GMT

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

Re: Problem with loading Data From SQL

Thu, 07 Apr 2016 16:53:44 GMT

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 :

Re: Problem with loading Data From SQL

Thu, 07 Apr 2016 16:59:11 GMT

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

Re: Problem with loading Data From SQL

swuehl — Thu, 07 Apr 2016 17:09:23 GMT

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-mysql‌

Connecting to MySQL using ODBC

MySQL and Access via ODBC — Uly.me

Re: Problem with loading Data From SQL

Thu, 07 Apr 2016 17:34:51 GMT

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

Thanks alot for your help .

Re: Problem with loading Data From SQL

swuehl — Thu, 07 Apr 2016 18:20:32 GMT

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