
Contributor III
2024-04-24
07:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1 Reply

Partner Ambassador
2024-04-24
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
477 Views
