[Overview][Classes][Variables][Index] |
[Properties (by Name)] [Methods (by Name)] [Events (by Name)]
Microsoft SQL Server database connector
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 OnLogin: TLoginEvent; |
|
Called when logging in |
end; |
|
Microsoft SQL Server database connector |
|
| | ||
|
An abstract class representing a connection to a SQL Database |
|
| | ||
|
Base class for connecting a FreePascal application to an external Database engine |
|
| | ||
|
Abstract class for connections to a server |
|
| | ||
| | ||
| | ||
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')