Microsoft OLE DB Driver

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
dataplan
Posts: 9
Joined: Thu 02 May 2013 08:16

Microsoft OLE DB Driver

Post by dataplan » Thu 13 Aug 2020 12:33

Does your driver support Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) or if not when will support be added? The SQL Server Native Client is deprecated and the Microsoft OLE DB Driver for SQL Server is the official successor.

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Microsoft OLE DB Driver

Post by Stellar » Mon 17 Aug 2020 15:05

Devart dbExpress driver for SQL Server supports Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).
An example of connecting to MS SQL Server using Microsoft OLE DB Driver for SQL Server:

Code: Select all

SQLConnection1.DriverName := 'DevartSQLServer';
SQLConnection1.LibraryName := <library name>;
SQLConnection1.VendorLib := 'msoledbsql';
SQLConnection1.GetDriverFunc := 'getSQLDriverSQLServer';
SQLConnection1.Params.Clear;
SQLConnection1.Params.Add('User_Name=MyName');
SQLConnection1.Params.Add('Password=MyPassword');
SQLConnection1.Params.Add('HostName=MyServer');
SQLConnection1.Params.Add('Database=MyDatabase');
SQLConnection1.Open;

Post Reply