Connect via SDAC (Data Abstract)

From RemObjects Wiki

This is a Data Abstract Connections topic
Feel free to add your notes to this topic below.

Contents 1 Overview 2 Parameters 3 Example 4 See Also

Overview

The Devart SQL Server Data Access Components (SDAC) driver is provided to allow connecting to Microsoft SQL Server.

The 3rd-party library (SDAC) is required. It should be downloaded separately.

Parameters

Parameter	Description
Server Name	Provides the host name or the IP address of the server to which you are connecting.
Login	Defines a username and password to access the database server. These fields are not used if you are using Windows Authentication (but see the Custom parameters step below).
Database	Specifies the database to which you wish to connect (e.g. "Northwind").
Custom parameters	Sets additional SDAC-driver specific options as a semicolon separated list of name/value pairs. If you are using Windows Authentication, you will need to add IntegratedSecurity=SSPI here.

Example

SDAC?Server=localhost;Database=Northwind;UserID=sa;Password=;Schemas=1;
SDAC?Server=localhost;Database=Northwind;Schemas=1;Integrated Security=SSPI;

See Also

• Data Abstract Connections
• Microsoft SQL Server

• Lists
  • Namespaces
  • Class Lists for .NET — Delphi — Xcode
  • Interface/Protocol Lists for .NET — Delphi — Xcode
  • Enum Lists for .NET — Delphi — Xcode
  • Alias Lists for Delphi
  • Implements Lists for .NET — Delphi — Xcode
  • Data Types
  • File Types

Product: RemObjects Data Abstract
Available Editions: Data Abstract for .NET, Delphi and Xcode

Glossary — Architecture — Articles — Features — Library — Samples