topic Re: odbc connection srting in QlikView

odbc connection srting

Thu, 20 Aug 2015 12:12:27 GMT

To extract the data from the db i am using odbc connection string.At the same time to connect the odbc which driver is required.my i know the driver name.

Re: odbc connection srting

sinanozdemir — Thu, 20 Aug 2015 12:35:42 GMT

Hi Janith,

Is your odbc set up for that db? If not, you can follow the below YouTube link:

Database: How to create ODBC connections - YouTube

Hope this helps.

Re: odbc connection srting

Peter_Cammaert — Thu, 20 Aug 2015 12:36:05 GMT

The ODBC interface itself is generic = the same for all data sources.

The driver is the data source-specific layer that isolates all product-dependent details from the ODBC interface. If we don't know the type of data source you want to use, we cannot tell you what driver you need.

Peter

Re: odbc connection srting

maxgro — Thu, 20 Aug 2015 12:48:43 GMT

usually every database needs a different driver

what's your source database?

Re: odbc connection srting

Thu, 20 Aug 2015 16:26:01 GMT

I am using oracle database

Re: odbc connection srting

Thu, 20 Aug 2015 16:26:31 GMT

Here i am using oracle database

Re: odbc connection srting

maxgro — Thu, 20 Aug 2015 16:57:39 GMT

a possible solution is to use the oracle odbc driver; you can find it in the oracle client at the oracle site

download the oracle client, install and configure