TMSSQLConnection

[Properties (by Name)] [Methods (by Name)] [Events (by Name)]

Microsoft SQL Server database connector

Declaration

Source position: mssqlconn.pp line 51

`type TMSSQLConnection = class(TSQLConnection)`
`public`
`constructor Create(); override;`		Create a new instance of `TMSSQLConnection`
`function GetConnectionInfo(); override;`		Return some information about the connection
`procedure CreateDB; override;`		Create a new MS SQL database
`procedure DropDB; override;`		Drop a MS SQL database
`published`
`property Password: string;`
`property Transaction: TSQLTransaction;`		Default transaction
`property UserName: string;`
`property CharSet: string;`
`property HostName: string;`		Host and optionally port or instance
`property Connected: Boolean;`		Is the connection active
`property Role: string;`		Role for user
`property DatabaseName: string;`
`property KeepConnection: Boolean;`		Keep connection alive
`property LoginPrompt: Boolean;`		Show login prompt
`property Params: TStrings;`
`property OnLogin: TLoginEvent;`		Called when logging in
`end;`

Inheritance

`TMSSQLConnection`		Microsoft SQL Server database connector
\|
`TSQLConnection`		An abstract class representing a connection to a SQL Database
\|
`TDatabase`		Base class for connecting a FreePascal application to an external Database engine
\|
`TCustomConnection`		Abstract class for connections to a server
\|
`TComponent,IUnknown,IInterfaceComponentReference`
\|
`TPersistent,IFPObserved`
\|
`TObject`

Description

Connector to Microsoft SQL Server databases.

Requirements:

MS SQL Server Client Library is required (ntwdblib.dll)

- or -

FreeTDS (dblib.dll)

Older FreeTDS libraries may require freetds.conf: (http://www.freetds.org/userguide/freetdsconf.htm)

[global]

tds version = 7.1

client charset = UTF-8

port = 1433 or instance = ... (optional)

dump file = freetds.log (optional)

text size = 2147483647 (optional)

Known problems:

- CHAR/VARCHAR data truncated to column length when encoding to UTF-8 (use NCHAR/NVARCHAR instead or CAST char/varchar to nchar/nvarchar)

- Multiple result sets (MARS) are not supported (for example when SP returns more than 1 result set only 1st is processed)

- DB-Library error 10038 "Results Pending": set TSQLQuery.PacketRecords=-1 to fetch all pending rows

- BLOB data (IMAGE/TEXT columns) larger than 16MB are truncated to 16MB: (set TMSSQLConnection.Params: 'TEXTSIZE=2147483647' or execute 'SET TEXTSIZE 2147483647')