Connection in Qlikview

[Anonymous]

Hello All,

Just need a small help from you guys...

When we are creating connection with SQL Server then which data source we will use?

ODBC or OLEDB?

In which scenario ODBC & OLEDB are useful?

Regards,

Balraj

[MK_QSL]

OLE DB...

Update : If you are on 64 Bit System Driver, tick Force 32 Bit.

[#3]

Hi Balraj,

For Connecting with SQL Server  database you please go with OLEDB Connection.

Regards

Deepak

[#4]

When connecting to SQL server, there is not such big difference between OLE DB and ODBC, because OLE DB uses ODBC when accessing SQL server. Generally speaking, OLE DB is abstracted data connection model of ODBC, meaning OLE DB is easier to understand for human than ODBC.

One practical difference between them is, as my understanding, detail setting is available for ODBC.

See the web site below, you can find a good data accessing flow image.

oledb - what is the difference between OLE DB and ODBC data sources? - Stack Overflow

[Anonymous]

Deepak,

I came to know from one of my friend and as per his input, he told me that when it comes to Sql Server you can connect to it with ODBC only...

Is it so?

Regards,

Balraj

[Roop]

I would always use OLE DB as it is simpler and integrated into the application.

With OLE DB you do not need to perform an additional step to set up an ODBC connection.

[ThornOfCrowns]

All you need to know, straight from the source:

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

[maxgro]

I doubt you can see performance difference getting data from your sql using odbc or oledb; so choose what you want, the simpler to use, the more recent, oledb, odbc or a mix (oledb on odbc); more detail in the attachment

[fkeuroglian]

Hi,

I recommend you to try both of them and see the difference

it is really important and big difference, i absolutely recommend OLEDB

It is a newer driver connection and allow you to connect with more different and faster tipe of connection

good luck

Fernando