topic ODBC Connection to Oracle in QlikView

ODBC Connection to Oracle

Wed, 25 May 2011 05:31:13 GMT

Hi,

How do I connect to the Oracle Database using ODBC ? I did successfully with OLEDB Provider.

Please show me a way to do that.

Thanks.

Regards,

Sachin A.

Anonymous — Wed, 25 May 2011 06:13:36 GMT

What is the problem you encounter with ODBC?

And why not just use the working OLEDB connection?

Wed, 25 May 2011 06:24:23 GMT

Hi jsn,

The problem is I m not able to connect to the oracle database through ODBC. No datasource to point. I want to try ODBC Connection.

Thanks.

Regards,

Sachin A.

Wed, 25 May 2011 07:00:09 GMT

Hi..

please create a ODBCconnection to your database using DATA SOURCE in windows- administrative tools

Wed, 25 May 2011 07:04:50 GMT

Hi,

Thanks Srao, I just did that prior to your post.

Thanks for the solution.

Regards,

Sachin A.

Wed, 25 May 2011 07:10:48 GMT

Hi,

You have to create the

1.create ODBC connection in Administartive tools-ODBC datasource with appropriate driver.

2. Once it is created the ODBC data source will appear in Qlikview to use