Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
happyfeet11
Contributor III
Contributor III

MS SQL server or ODBC or OLEDB

Hi There 

 when connecting to a sql server is there any logic when one shoudl use a ODBC or a OLE DB or a MS sql serverconnector?

Best

Indrani

Labels (2)
2 Replies
mpc
Partner - Creator III
Partner - Creator III

Hi,

OleDB is an old standard, and I think it should avoided now.
ODBC drivers are now more efficients and updated on a regular basis.

In some very specific cases, I've seen usage of OleDB connectors instend of ODBC ones, but it was in 2016 for and old Oralce (in this example) database.

Kind regards

VitorioVincenze
Contributor
Contributor

OLE DB is versatile, ODBC is cross-platform, and the native connector offers top integration if you're in a Microsoft environment. Pick what fits best.