topic Re: ODBC /OLE DB connection on qlikview server in QlikView

ODBC /OLE DB connection on qlikview server

j_qlikview — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I was looking to configure the OLE DB connection on Qlikview server and i was looking for some help

on this such as documentation and so which can be helpful to me.

Thanks in Advance

Jahnavi

Re: ODBC /OLE DB connection on qlikview server

sagarkharpude — Thu, 26 Mar 2015 03:58:45 GMT

please check the below link

1. Connecting to ODBC/OLE DB Data Sources - QlikView Scripting

Re: ODBC /OLE DB connection on qlikview server

ashfaq_haseeb — Thu, 26 Mar 2015 08:52:37 GMT

Hi,

It is usually provided by DB vendor.

Which database you are tying to connect with?

Simple Google can even help you out here.

Regards

ASHFAQ

Re: ODBC /OLE DB connection on qlikview server

peter_turner — Fri, 27 Mar 2015 17:04:31 GMT

Hello Jahnavi,

As you mention its an OLE DB connection the database settings etc would be stored as a string inside the script of your QlikView QVW document you've made (or been given).

You might need to check that the user account running your QlikView Server services on the server has access to the required databases to read the data.

Also check the help in QlikView, search for 'Loading Data from Databases' as it has some useful pages and links.

Re: ODBC /OLE DB connection on qlikview server

buzzy996 — Fri, 27 Mar 2015 17:14:27 GMT

from ur application follow these steps,

1.File Menu-EditScript

2.Data (Data tab in bottom)-select OLEDB as ur Database if ur database is OLEDB

3.Connect (click connnect)

4.Select ur proper driver from DataLink Properties& Provider tab

ex:Microsoft OLEDB provide for SQL server (thse u have to choose if u want o connect sql server db)

5. Next (Click Next)

6. Select ur servername

Enter username and password in 2

or if u have NT details from 2 option use radio button as "Use Windows NT iNTEGRATED sECURITY"

7.select ur databse

8.text connection

if connection is success then automatically u will get connection srting in ur edit script.

Re: ODBC /OLE DB connection on qlikview server

Thu, 02 Apr 2015 09:02:00 GMT

Hi Jahnavi,

Go to Run --->odbcad32 ---> System dsn ----->Add a new Connection -----> Select Microsoft SQL Server as your provider and fill in the credentials.

use this system dsn connection in qlikview which you have made.

Even google can help you out on this.

Regards

Nidhin

Re: ODBC /OLE DB connection on qlikview server

Anonymous — Mon, 05 Oct 2015 13:55:12 GMT

Not sure to which database you want to connect but take a look at this ODBC driver connection guide

It is for Oracle but you may use the similar to any other