[Overview][Types][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; |
||
published |
||
property Password; |
||
property Transaction; |
||
property UserName; |
||
property CharSet; |
||
property HostName; |
|
Host and optionally port or instance |
property Connected; |
||
property Role; |
||
property DatabaseName; |
||
property KeepConnection; |
||
property LoginPrompt; |
||
property Params; |
||
property OnLogin; |
||
end; |
|
Microsoft SQL Server database connector |
|
| | ||
TSQLConnection |
||
? | ||
TObject |
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')