 lacak
|
1da7ba5d70
fcl-db: sqldb: Upgrade TDS protocol version from 7.0 (MS SQL Server 2000) to newer 7.3 (MS SQL Server 2008) to support new data types DATE, TIME, DATETIME2 introduced in MS SQL Server 2008.
|
6 years ago |
 michael
|
16ba47be46
* Patch from Ondrej Pokorny to convert unit names to CamelCase (bug ID 33481)
|
7 years ago |
|
lacak
|
f51f09414b
fcl-db: mssql: cancel all pending results in case of unpreparation statement and in case dataset is closed.
|
7 years ago |
|
lacak
|
d47be9c3f7
fcl-db: sqldb: reverting previous commit 37947.
|
7 years ago |
|
michael
|
f930d186f0
* Patch from Ondrej Pokorny to set prepared in Prepare (bug ID 33010)
|
7 years ago |
|
lacak
|
05cddddf7c
fcl-db: mssql: in case of network failure infinite loop can occurs in Fetch method. Bug #32524
|
7 years ago |
|
lacak
|
ad96eb037d
fcl-db: sqldb: introduce connection CodePage (derived from connection CharSet) and supporting routines, which performs f.e. codepage aware parameter binding using connection codepage (charset)
|
9 years ago |
|
michael
|
4cc83ba03f
* Fix typo
|
10 years ago |
|
michael
|
ba506acf9f
* Actually log new log types (ActualSQL and ParamValue)
|
10 years ago |
|
lacak
|
b968e4f679
fcl-db: mssql: zero length varchar and varbinary values are marked as IsNull.
|
10 years ago |
|
lacak
|
69cbcdaa34
fcl-db: mssql: add support for varchar(MAX), varbinary(MAX) data types
|
10 years ago |
|
lacak
|
9fba59b3bc
fcl-db:
|
10 years ago |
|
lacak
|
1e3d48288c
fcl-db: mssql: make Rollback more safe. Check if there is active transaction first to avoid error "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION."
|
10 years ago |
|
lacak
|
eaadd51b42
fcl-db: reverts rev.29118, because there are 3rd party libraries (like ZEOS), which define own EDatabaseError descendants, where they define members FErrorCode and/or ErrorCode.
|
10 years ago |
|
michael
|
2134e3aaac
* Promoted errorcode to the EDatabaseError level, unified all error codes
|
10 years ago |
|
lacak
|
0028210b53
fcl-db: mssql: if stored procedure raises error with severity > 10 then db-library calls error handler, which sets DBErrorNo and DBErrorStr. So check them after execution of SQL and raise also error if they are set. +Cancel any pending results or other commands in batch to allow ROLLBACK.
|
10 years ago |
|
lacak
|
bafe66a3f0
fcl-db: mssql: add support for new MS SQL 2008 datetime data types. Depends on rev.27979 and requires new FreeTDS dblib library
|
11 years ago |
|
lacak
|
7de12fb703
fcl-db: sqldb: align column naming (PROCEDURE_NAME) for stProcedures schema query with ODBC standard (SQLProcedures) and also with Delphi naming used in ADO OpenSchema for siProcedures (and partial also with DBX).
|
11 years ago |
|
lacak
|
9d2933d752
fcl-db: mssql: initial attempt to implement support for output parameters of stored procedures. Beause MS in newer versions of TDS protocol has breaked it we must use other way how to do it (use dbrpc*() API functions). But return status of stored procedures execution is returned as before, so start with it.
|
11 years ago |
|
michael
|
196d8cee3d
* Use factory for fielddefs
|
11 years ago |
|
lacak
|
9c2ffc30ee
fcl-db:
|
11 years ago |
|
lacak
|
3c0386ca19
fcl-db: sqlDB: add more informations to schema query for table columns (SchemaType=stColumns)
|
12 years ago |
|
michael
|
48250dcafd
* implementation of sqSupportEmptyDatabaseName from Laco, used in PostGres and MSSQL
|
12 years ago |
|
michael
|
af1d33767d
* Inherited must be called for Internal(Dis)Connect for housekeeping
|
12 years ago |
|
lacak
|
7c110e9b42
fcl-db:
|
12 years ago |
|
lacak
|
1ffcb9c1e6
fcl-db: mssql: add comments
|
12 years ago |
|
michael
|
2b6f33711b
* Patch from Ludo Brands to implement InstanceName (Bug ID 24635)
|
12 years ago |
|
lacak
|
19132fc98d
fcl-db: sqldb: implemented TSQLConnection.GetSchemaNames
|
12 years ago |
|
lacak
|
3658b939cb
fcl-db: mssql: small extending (like in others sqldb/sonnections) schema information returned using SetSchemaInfo call. System tables and functions used should be compatible with MS SQL and also with Sybase.
|
12 years ago |
|
lacak
|
6a9c3a6061
fcl-db: introduce FSelectable as new TSQLCursor class field. Update sql connectors to set it after Preparation or Execution of sql statement to signal if there will be or is result set. This change is neutral. In next commit I will use FSelectable to determine if allow Open or raise SErrNoSelectStatement.
|
12 years ago |
