Page 1 of 1

Microsoft OLE DB Driver

Posted: Thu 13 Aug 2020 12:33
by dataplan
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.

Re: Microsoft OLE DB Driver

Posted: Mon 17 Aug 2020 15:05
by Stellar
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;