[Properties (by Name)] [Methods (by Name)] [Events (by Name)]
Microsoft SQL Server database connector.
Source position: mssqlconn.pp line 57
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. |
|
| | | ||
| | | ||
| | | ||
TObject,IFPObserved |
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')