Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
happyfeet11
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)
1 Reply
mpc
Partner Ambassador

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

From Next Decision and mpc with love