topic Re: Creating ODBC Connection in QlikView

Creating ODBC Connection

Fri, 11 Apr 2014 23:43:00 GMT

Hi,

How can we create an ODBC connection with QlikView. Also after creating a connection i get the error which is attached. Please help out so that i can start work on the QlikView product.

TYIA,

Re: Creating ODBC Connection

mgavidia — Fri, 11 Apr 2014 23:58:44 GMT

You need to create the ODBC connection in the usual way: From Windows Start select:

Control Panel / Administrative Tools / Data Sources. Use the Oracle user ID and Password to create a System DSN (You need to have the appropiate Oracle driver installed).

Once you have the System DSN properly configured, you just selected it from the QlikView pull-down to see the Oracle tables avaialble to that user.

I hope this helps,

Miguel Gavidia

Los Angeles, CA.

Re: Creating ODBC Connection

its_anandrjs — Sat, 12 Apr 2014 04:26:41 GMT

Oracle listener is not configure correctly thats why it is not obtain suggestion talk to the oracle person or check the listener file location and configure the connection.

For creating the ODBC connection in qlikview

Go to Script Editor >> select >> Database ODBC >> Connect >> and select oracle Data source

and

From OLE DB you can also create a connection.

Re: Creating ODBC Connection

rajat2392 — Sat, 12 Apr 2014 04:44:50 GMT

goto control panel, follow this path...

Control Panel > Administrative Tools > Data Sources

create the database by adding it, see the screenshot

now goto qlikview and select ODBC connection and test it and see if it is successful or not as in screenshot below

If successful then select and load the data else establish the connection in control panel again properly.

Re: Creating ODBC Connection

maxgro — Sat, 12 Apr 2014 06:18:14 GMT

the error you get comes from oracle

- you can check the oracle side with (open a dos prompt)

tnsping yournetservicename

yournetservicename is usually configured in tnsnames.ora

- if ok configure a system odbc (32 or 64, as your oracle client)

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion

- then use it in qlik (32 or 64, depending on your previous choice)

Re: Creating ODBC Connection

arsal_90 — Sat, 12 Apr 2014 06:38:22 GMT

First you have to check on you system that ora client is installed. if not installed than first installed it then you have to pass database ip and port in tns file. so if you dnt locate the tns file then let me. And after that process you have to make system dsn. First let me know that ora client is installed in your machine.

Re: Creating ODBC Connection

arsal_90 — Sat, 12 Apr 2014 06:42:15 GMT

Location for tns ora:

/home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora