Direct access to MS SQL Server with UNIDAC on Linux without driver

With the Delphi 10.2 began the re-support of Linux. Devart also quickly released the UNIDAC 7.0,

The biggest feature is Linux and MongoDBsupport.

And there are other updates:

In this release we added such significant features as:

• The new UNIDAC version includes a new MongoDB provider which allows you to work with a cross-platform document-or iented database MongoDB. Its main features is high performance, easy deployment and comprehensive support for the latest versions of the MongoDB s Erver.
• In DBF provider, we added support for the Direct mode. Using DBF data Provider, you can work with a variety of the database Formats:dbaseiii-dbase10, dBase for Windows, Hiper-six, FoxPro 2, Visual FoxPro.
• Now, working with Oracle on the Direct mode becomes more appealing, we supported Oracle 12c authentication, O Racle Cloud (DbaaS), Oracle encryption, Oracle Data Integrity. We also added support for the ANYDATA type.
• What's more, for Interbase and Firebird, you had an opportunity to manage batch operations using a transaction and to OB Tain an active transaction number using Dbmonitor.
• In NEXUSDB data provider, we added support for using ConnectionString and the TFMTBCD fields.

More information can be accessed on the official website Www.devart.com. The company's ability to access the database has been reversed.

Today we are talking about using Undiac's direct database feature to not install any drivers under Linux and to access MS SQL Server functionality.

If you do not have an existing SQL Server database, you can download the SQL Server Express version directly on the Microsoft Web page, which is the free version.

After installation, start TCP/IP support and pay attention to Windows Firewall settings to ensure network access is healthy.

On Windows, use a client program, build a SQL Server database, and build a test table.

Enter some test data

OK, ready to finish. Start Delphi.

Create a new console project.

and build a datamodule.

Put on the corresponding control

Note The property settings for Uniconnection

OK, Setup is complete.

Back to the main program.

 ProgramLinuxdata;{$APPTYPE CONSOLE}{$R *.res}usessystem.sysutils,system.classes, DMPinch 'Dmp.pas' {Dmf:tdatamodule};varI:integer; S:string;begin  TryDMF:=TDMF.Create(Nil); Dmf. Uniconnection1.connected:=true;
Writeln (' database version: ' +DMF.   Uniconnection1.serverversionfull);  withDmf.cx Do    beginSQL.    Clear; Sql. ADD ('SELECT * from Tb_user');    Open  forI: =0  toFields. count-1  Do          begin            Write('|'); Write(Fields[i].            FieldName); End; Writeln ('|');  while  notEof Do      begin         forI: =0  toFields. count-1  Do          begin              Write('|'); Write(Fields[i].             asstring); End; Writeln ('|');      Next End; End; Writeln ('finish the Harvest!');  READLN; exceptOn e:exception DoWriteln (E.classname,': ', E.message); End;End.

Run without error on Windows.

Add Linux Platform compilation support

Compile, run the program

The results came out. No difference from Windows.

Remember: We do not have any SQL Server drivers installed under Linux.

Use Delphi to be so confident!

In addition, the above names, purely fictitious, if there is similar, indifferent.

Direct access to MS SQL Server with UNIDAC on Linux without driver