MSConnection1.Database := 'FISH_FACTS_DEMO' MSConnection1.Authentication := auServer If you want to set up a connection for the Direct mode at run-time, the code will be look like the following: := prDirect

MSConnection1 configuration for Direct is finished.

Open MSConnection1 editor and fill in the required properties: Server, Port, Authentication (the SQL Server value), Username, Password and Database. Set up the MSConnection1 component by setting the Options.Provider ProviderName property to prDirect. Place the TMSConnection component onto the form, which will be named as MSConnection1. In the appeared dialog select Blank Application. For this, in the File|New menu select Multi-Device Application – Delphi. Here we create a new Mac OS X application in Delphi XE7 working with SQL Server. Let’s consider a simple sample of using Direct Mode. 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.ĭevart provides a ready solution for work with SQL Server from Mac OS X – Direct Mode. The existing providers for SQL Server by Microsoft use the OLE DB interface, that allows using client applications only on Windows platforms. Devart Company released SDAC and UniDAC for RAD Studio with a new functionality – Direct Mode for connection to SQL Server.

Sql clients for mac