Microsoft OLE DB Driver
Microsoft OLE DB Driver
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
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:
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;