topic Re: ODBC connection in QlikView

ODBC connection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello

i want used oracle database as a data source , i have windows 7 with 64 bit but i have installed 32 bit ODBC.

when i select FORCE 32 Bit option it get connected but it doesn't show any tables

Connection successful :

But doesn't show any tables:

prma7799 — Fri, 30 Jun 2017 06:31:43 GMT

Please check database

Anonymous — Fri, 30 Jun 2017 07:07:09 GMT

how to change path?

prma7799 — Fri, 30 Jun 2017 07:13:04 GMT

Click to drop down button in Database

Anonymous — Fri, 30 Jun 2017 07:19:09 GMT

There is no any other options.

Anil_Babu_Samineni — Fri, 30 Jun 2017 07:28:23 GMT

Are you sure the DB is D:\Qlik is the database?

prma7799 — Fri, 30 Jun 2017 07:36:48 GMT

There have an option

Anonymous — Fri, 30 Jun 2017 07:37:53 GMT

database is in another location but i am not able to change that path

Anonymous — Fri, 30 Jun 2017 07:41:00 GMT

see only one option is there

jmvilaplanap — Fri, 30 Jun 2017 09:11:04 GMT

I think, you must to configure the connection in the "ODBC Data Source Administrator" use the connection.

If not you have to use the entire connection string.

Try to configure the connection in your OS.

simospa — Sat, 01 Jul 2017 16:59:06 GMT

Hi,

when you created ODBC connection on your PC, the connection test suceeded or failed?

It seems that ODBC connection is wrongly setted on your machine.

Anonymous — Mon, 07 Aug 2017 11:38:51 GMT

it shows connection test suceeded.