Devart Blog

Connecting to SQL Server from Mac OS X in Direct Mode Using SDAC

Posted by on December 26th, 2014

Devart Company released SDAC and UniDAC for RAD Studio with a new functionality – Direct Mode for connection to SQL Server. The existing providers for SQL Server by Microsoft use the OLE DB interface, that allows using client applications only on Windows platforms. Due to absence of native solutions by Microsoft for Mac OS X, SDAC Direct Mode was the only opportunity to support SQL Server for Mac OS X.

Devart provides a ready solution for work with SQL Server from Mac OS X – Direct Mode. Let’s consider a simple sample of using Direct Mode.

Design time

Here we create a new Mac OS X application in Delphi XE7 working with SQL Server. For this, in the File|New menu select Multi-Device Application – Delphi.

New MAC OS X application

In the appeared dialog select Blank Application.

Blank Application

Connection settings in Direct Mode

Place the TMSConnection component onto the form, which will be named as MSConnection1. Set up the MSConnection1 component by setting the Options.Provider ProviderName property to prDirect. Open MSConnection1 editor and fill in the required properties: Server, Port, Authentication (the SQL Server value), Username, Password and Database.

Connection Dialog

MSConnection1 configuration for Direct is finished.

If you want to set up a connection for the Direct mode at run-time, the code will be look like the following:

MSConnection1.Options.Provider := prDirect;
MSConnection1.Server := 'Server';
MSConnection1.Port := 1433;
MSConnection1.Authentication := auServer;
MSConnection1.Database := 'FISH_FACTS_DEMO';
MSConnection1.Username := 'sa';
MSConnection1.Password := '*************';

Opening connection and dataset in Direct Mode

The complete project in the IDE looks as shown below:

Complete Project

Now we just have to write event handlers for the Connect and Disconnect buttons:

procedure TMainForm.ConnectClick(Sender: TObject);
begin
  MSConnection1.Connect;
  MSQuery1.Open;
end;

procedure TMainForm.DisconnectClick(Sender: TObject);
begin
  MSQuery1.Close;
  MSConnection1.Disconnect;
end;

Source Editor

Application execution in Direct Mode on Mac OS X

For application deployment and execution, the Direct mode requires no libraries, etc. This is our example running on Mac OS X.

Executing MAC OS X application

The following post will show how to use SDAC to develop applications for Android and iOS working with SQL Server in Direct Mode. The source code of this demo can be found in the SDAC Demo folder on your PC.

Leave a Reply