topic ODBC CONNECTION ISSUE in QlikView

ODBC CONNECTION ISSUE

kakani87 — Wed, 09 May 2018 05:25:13 GMT

Hi Folks ....

I'm unable to see the odbc connection strings while tried connecting

Here in the below screen showing two strings for 2017 and 2018 got configured and able to load the data as well but this is not displaying connection string while tried connecting.

Any one can help me to come out of this issue

Re: ODBC CONNECTION ISSUE

Gysbert_Wassenaar — Wed, 09 May 2018 05:38:02 GMT

Perhaps you're trying to see connections defined for the 32-bit drivers while they've been defined for the 64-bit drivers. Or vice-versa.

Re: ODBC CONNECTION ISSUE

kakani87 — Wed, 09 May 2018 05:43:10 GMT

Tried Uncheck the force 32-bit as well not displaying

Re: ODBC CONNECTION ISSUE

tamilarasu — Wed, 09 May 2018 05:47:24 GMT

Hi Saikishore,

Have you actually created the ODBC connection in "ODBC data source Administrator"? Below link may help you to understand this better.

https://mindmajix.com/connect-odbc-ole-db-data-sources-using-qlikview

Re: ODBC CONNECTION ISSUE

kakani87 — Wed, 09 May 2018 05:57:36 GMT

Yes Tamil ... Able to load load data for 2017 but not for 2018

For checking this tried connecting to string why 2018 is not getting loaded

Re: ODBC CONNECTION ISSUE

tamilarasu — Wed, 09 May 2018 06:05:48 GMT

Do you have access for the database "c0002018_c1"? Did you configure the details in "ODBC data source administrator? It looks like you have configured for 2017 datasbase and not for 2018. Can you recheck it? Also please confirm did you get any error message?

Re: ODBC CONNECTION ISSUE

tamilarasu — Wed, 09 May 2018 08:54:40 GMT

Hi Saikishore,

Is the issue resolved? Could you explain what you have done to resolve it? It would be helpful for me and others . Thanks.

Re: ODBC CONNECTION ISSUE

kakani87 — Wed, 09 May 2018 09:29:00 GMT

Able to load the data by connecting to data source after reconfigure the odbc connection

With the help of thread posted by you, but not able to show the connections

Actually this issue is facing after system got format and i came to know from one of my colleague there might be a chance of missing some driver file .

If you can let me know the list of driver files to check with, this will be helpful.

Regards,

Sai.

Re: ODBC CONNECTION ISSUE

Anonymous — Mon, 28 May 2018 21:17:49 GMT

Hi,

I have the same problem. I'm using QlikSense Desktop and I don't have administrator rights. So I have created a MS Access ODBC connection (User DSN). I have tested the connection from Excel and I can open it and get the data, but in Qlik Sense I see the same empty screen reported above by Kakani.

Any help? it could be something related to users? (i.e. Qlik Sense user is different from Windows user and therefore is not able to see the User DSN?)

Thank you in advance,

Nicolas

Re: ODBC CONNECTION ISSUE

tamilarasu — Thu, 31 May 2018 02:46:48 GMT

Hello,

I am able to see the configured database. Could you post a snap shot of your like I attached. It would be helpful for us to provide solution.

Re: ODBC CONNECTION ISSUE

tamilarasu — Thu, 31 May 2018 02:59:21 GMT

Hi SaiKishore,

Sorry for the delayed response. You should contact your Administrator for this question. He will help you to install all the necessary drivers (default drivers) which require for your working environment. If you are working in SQL, you need to install SQL drivers like wise for oracle, postgreSQL etc. If you need to connect access file or excel using ODBC connection then you need to have necessary Microsoft drivers. So it depends on your requirement. Have a nice day!