https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-server-or-ODBC-or-OLEDB/m-p/2444312#M13591 <P>Hi There&nbsp;</P> <P>&nbsp;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?</P> <P>Best</P> <P>Indrani</P> Wed, 24 Apr 2024 11:05:27 GMT happyfeet11 2024-04-24T11:05:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-server-or-ODBC-or-OLEDB/m-p/2444312#M13591 <P>Hi There&nbsp;</P> <P>&nbsp;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?</P> <P>Best</P> <P>Indrani</P> Wed, 24 Apr 2024 11:05:27 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-server-or-ODBC-or-OLEDB/m-p/2444312#M13591 happyfeet11 2024-04-24T11:05:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-server-or-ODBC-or-OLEDB/m-p/2444426#M13596 <P>Hi, <BR /><BR />OleDB is an old standard, and I think it should avoided now. <BR />ODBC drivers are now more efficients and updated on a regular basis. <BR /><BR />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. <BR /><BR />Kind regards</P> Wed, 24 Apr 2024 15:21:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/MS-SQL-server-or-ODBC-or-OLEDB/m-p/2444426#M13596 mpc 2024-04-24T15:21:23Z