2007-05-30 Nagappan A * TdsColumnType.cs: Added new types BigNVarChar, Variant to TdsColumnType enumerator. * TdsComm.cs (Append): Appends new data types to the TDS data stream and also implemented new Append overloaded method. * Tds.cs (BeginLoad): New case to handle BigBinary. (GetMoneyValue): Simplified the switch / case conditions. * TdsDataRow.cs: Instance of index checks for the given index to be less than list count, else an exception will be thrown. * Tds70.cs (sqlserverMagic): Modified byte values. (ExecProc): Now directly calls ExecRPC for any number of parameters being passed. (ExecRPC): New logic to handle parameters. (WriteParameterInfo): New private method to generate information about each parameter. (ProcessReturnStatus): New protected method to process the return status of output parameter value. 2007-03-21 Nagappan A * Tds70.cs (BuildParameters, FormatParameter): Include @ before parameter name, if doesnot exist. 2006-07-18 Dean Brettle * Tds70.cs : Fixed bug in FormatParameter() which caused ArgumentOutOfRangeException when formatting 0-length varbinary values under 1.0 profile. 2006-05-03 Senganal T * Tds.cs : - SetCharset () : Fix to set the Charset correctly. Patch from Andrzej Kurzeja 2006-03-08 Senganal T * Tds70.cs : - ProcessColumnInfo () : Set IsAutoIncrement Value for the column. 2006-02-10 Senganal T * Tds.cs : - GetSequentialColumn,BeginLoad, EndLoad, LoadData, SkipRow, SkipToColumnIndex New Methods to Support sequential loading of row data * TdsComm.cs : - Skip : Changed arugment type from int to long. 2006-01-27 Senganal T * Tds.cs : - Modified GetSqlMoney () , to set the precision and Scale correctly. - Modified ProcessColumnDetails , to set the schema values correctly. * TdsDataColumn.cs : Added some default values for the column schema 2005-12-07 Senganal T * Tds50.cs : - IsValidRowCount () : Find out if a row count is valid. Fixes bug #76280 * Tds.cs : - ProcessEndToken (): Removed some redundant code. 2005-12-03 Senganal T * Tds70.cs : - FormatParameter () : For DateTime Parameters, convert the value if specified as a string. Fixes bug#76880 2005-11-24 Senganal T * Tds.cs * Tds70.cs : - Modifications to set the desired packetsize info when connecting to database 2005-11-23 Senganal T * TdsComm.cs : - ResizeOutBuf : Modified to shrink the output buffer if the block size is reduced. Fixed bug #76778 2005-10-27 Senganal T * Tds.cs : - Added a virtual method IsValidRowCount () - Modified the way RecordsAffected is being counted * Tds70.cs : - Overrode IsValidRowCount(), to check if the rowcount returned by sqlserver is valid. 2005-10-19 Senganal T * TdsConnectionParameter.cs : - Added a class variable 'AttachDBFileName' to store the location of the DB file. * Tds70.cs (Connect) : - Modified to append the bytes corresponding to AttachDBFileName into the Tds Packets. 2005-08-26 Sureshkumar T * Tds70.cs (ExecProc): if no parameters, execute via RPC. parameter support has to be added. * Tds.cs (ExecRPC): added virtual method to execute via RPC. This fixes bug #68978 by enabling execution of sp_reset_connection. 2005-08-24 Sureshkumar T * Tds.cs: ProcessColumnDetail (): expression columns don't have baseTableName. 2005-08-05 Sureshkumar T * Tds70.cs: Reset (): remove exec. 2005-07-01 Sureshkumar T * Tds70.cs: FormatParameter: For uniqueidentifier, pass the guid as '..' rather than hex. Tested with SqlServer 2005. patch from jsinger@eggmouse.com & Hubert FONGARNAND. 2005-06-29 Sureshkumar T * TdsInternalException.cs: Add ctor for InnerException. * TdsComm.cs: Throw TdsInternalException rather than SocketException. 2005-06-01 Sureshkumar T * Tds50.cs: add a special case for datetime parameters to convert to invariant culture. fixes bug #74910. 2005-04-07 Sureshkumar T Ankit Jain * TdsComm.cs: GetPhysicalPacket is devided further into seperate methods GetPhysicalPacketHeader and GetPhysicalPacketData. Implemented asynchronous ReadPacket method. * ITds.cs: Added additional methods for asynchronous operations. * Tds.cs: Implemented base methods for asynchronous operations. Version specific derivatives should override for specific operations. * Tds70.cs: For stored procedure, "exec" is prefixed by default. Implemented asynchronous method for asynchronous command execution. * TdsAsyncState.cs: Added. Internal asynchronous state object. * TdsAsyncResult.cs: Added. Internal asynchronous result implementation. 2005-04-04 Sureshkumar T * Tds50.cs: Pass parameters to the server. cut & paste from Tds70.cs. To make the parmeters work with SybaseClient. 2005-03-18 Gonzalo Paniagua Javier * Tds70.cs: turns out that sp_reset_connection procedure might not be found ("Invalid object name 'sp_reset_connection'"). In this case, and if we get a proper state ('Class' property in the SqlException), just ignore the error. * TdsConnectionPool.cs: if the connection cannot be reset, attemp to disconnect it before losing the last reference to it. 2005-03-11 Gonzalo Paniagua Javier * Tds.cs: set the charset for MS SQL 2000. Patch from Aleksandar Dezelin. Closes bug #73591. 2005-02-04 Sureshkumar T * Tds.cs (ProcessEndToken): Added a bool validRowCount and add to recordsAffected count if we meet DoneInProc.. 2005-02-02 Sureshkumar T * TdsConnectionParameters.cs: added a method Reset to initialize parameters again. 2005-01-16 Daniel Morgan * Tds.cs: TDS 5.0 (Sybase) needs to get a DECIMAL differently than TDS 7.0 (SqlServer). Fixes bug 70228. Thanks to Sebastien Robitaille for the patch for Sybase. 2005-01-07 Sureshkumar T * Tds70.cs : - add a special case for datetime parameters to convert to invariant culture. fixes bug #70209. - change format to MMM dd yyyy, this works for both client locale change and server login locale change. fixes bug #66564. 2005-01-06 Sureshkumar T * Tds.cs: change the typecast to ushort for GetDateTimeValue. fixes bug #70651. 2004-11-06 Gert Driesen * Tds70.cs: avoid unnecessary property call. 2004-11-01 Gert Driesen * Tds70.cs: when type of parameter value is enum, convert value to underlying type before converting value to string as we'd otherwise be using the enum field name 2004-10-30 Umadevi S * Tds.cs : GetColumnValue method: handling null guid values correctly. This fixes bug #68804. Thanks for the patch /bug report by Aleksandar Dezelin 2004-10-14 Umadevi S * Tds.cs : GetTextValue method- handling zero length string correctly This fixes bug #67916 2004-08-14 Geoff Norton * TdsComm.cs: Tds70.cs: Make Tds70 work on Big Endian machines. BitConverter uses unsafe and returns things in host order; we need to swap some values to put them back into the approrpiate order for the wire. 2004-08-09 Sureshkumar T * Tds70.cs - Prepare Method stored procedure handle read problem fixed. 2004-06-30 Umadevi S * Tds.cs - In the NextResult method handling TdsPacketSubType. TableName. 2004-04-22 Sebastien Pouliot * Tds70.cs: Updated to match changes in Mono.Security.dll. 2004-04-05 Lluis Sanchez Gual * ITds.cs: Added method for reseting a connection. * Tds.cs: Added base implementation for ITds.Reset. * Tds70.cs: Implemented ITds.Reset(). * TdsConnectionPool.cs: Implemented connection pool that can be reused by all Tds clients. 2004-04-01 Lluis Sanchez Gual * Tds.cs: All methods now return DBNull instead of null for null values. * Tds50.cs, Tds70.cs: Support parameters with DBNull value. 2003-12-21 Tim Coleman * Tds70.cs: Fix Integrated Security to work with Domain users. 2003-12-06 Sebastien Pouliot for Daniel Morgan Sebastien Pouliot (spouliot@motus.com) helped me greatly with his NTLM stuff. * Mono.Data.Tds.Protocol/Tds.cs * Mono.Data.Tds.Protocol/Tds70.cs * Mono.Data.Tds.Protocol/TdsConnectionParameters.cs * Mono.Data.Tds.Protocol/TdsPacketSubType.cs * Mono.Data.Tds.Protocol/TdsPacketType.cs: added NT Authentication aka Integrated Security aka Domain Login 2003-10-19 Joerg Rosenkranz * Tds.cs (GetStringValue): A string length of 0xFF (255) is not misinterpreted as special value anymore. This is a fix to bug #49835. 2003-10-03 Diego Caravana * Tds70.cs: Now handles parameters of type ReturnValue and InputOutput. (BuildParameters): skips the ReturnValue params and builds the set string considering the assigned value for InputOutput ones. (BuildProcedureCall): like the preceding one plus adds the return value to the final select. 2003-08-22 Duncan Mak * Tds.cs (ProcessEndToken): RecordsAffected was not filled correctly. I've found out that the record count was submitted for TdsPacketSubType.Done. So I changed the behaviour to include this (without deeper knowledge of the TDS protocol). Patch from Jörg Rosenkranz . This is part of a fix to bug #40315. 2003-05-07 Miguel de Icaza Patches from Igor Nosyryev * TdsComm.cs: (GetString): GetString adds extra byte to a string at end. It suppose to be '\0', but '\0' is valid value in .NET string, so this byte must not be used. * Tds.cs (GetDecimalValue):Method reads extra byte if a DECIMAL field contains NULL. As a result server's response is parsed incorrectly and this method fires an exception. 2003-01-20 Gonzalo Paniagua Javier * Tds70.cs: (FormatParameter): send input/output parameter names. This way we don't depend on the parameter position being different of the index in the parameter collection. 2002-12-10 Gonzalo Paniagua Javier * Tds.cs: (Disconnect): close the stream and set connected to false. (NextResult): check if after DoneProc we have a ColumnMetadata + Row, which holds the values for the output parameters and read them. (LoadRow): add the values to outputParameters if DoneProc. When executing a stored procedure, we execute the procedure and then select the parameter values. * Tds70.cs: (BuildParameters): check Parameters. * TdsComm.cs: added Close () to close the stream. * TdsConnectionParameters.cs: initialize all the string to be empty. 2002-11-04 Tim Coleman (tim@timcoleman.com) * TdsBigDecimal.cs: New class added to handle (potentially) large decimal values * Tds.cs: Modified to use TdsBigDecimal instead of decimal for transit of (potentially) large decimal values 2002-11-03 Tim Coleman (tim@timcoleman.com) * TdsColumnStatus.cs: Newly added to handle column metadata * Tds.cs Handle table name and column detail results * Tds42.cs * Tds50.cs * Tds70.cs rename TableName BaseTableName for consistency * TdsPacketSubType.cs: We now know what subtype 0xa5 is * TdsPacketTableNameResult.cs: Add means to store table names * TdsSchemaInfo.cs: Add new schema information 2002-11-01 Tim Coleman (tim@timcoleman.com) * ITds.cs: Add DoneProc property * Tds.cs: *Lots*. Some stuff to get binary types to work, other stuff to get new prepares working. * TdsPacketEndTokenResult.cs: Add Packetsubtype property * TdsPacketRowResult: Now implements ICollection and IList. 2002-10-31 Tim Coleman (tim@timcoleman.com) * TdsSchemaInfo.cs: Added because I can't really use SchemaInfo * ITds.cs: * Tds.cs : * TdsPacketColumnInfoResult.cs : ChangeDefinition of schema * Tds42.cs : * Tds50.cs : * Tds70.cs : Add new information to schema 2002-10-30 Tim Coleman (tim@timcoleman.com) * TdsColumnSchema.cs: Ditch this in favor of System.Data.Common.SchemaInfo * ITds.cs: Change ColumnInfo to Schema * Tds.cs: Uses new SchemaInfo object Supports TEXT now. * Tds42.cs: * Tds50.cs: * Tds70.cs: * TdsPacketColumnInfoResult.cs: * TdsPacketRowResult.cs: Uses new SchemaInfo object 2002-10-29 Tim Coleman (tim@timcoleman.com) * ITds.cs: Add OutputParameters collection * Tds.cs: Much reformatting, added handling for dates, fixed handling of output parameters, and a whole lot more * TdsPacketEndTokenResult.cs: Remove incorrect exception * TdsPacketType.cs: Add Logoff packet type. 2002-10-28 Tim Coleman (tim@timcoleman.com) * Tds.cs: Add much handling to get the following types working in queries: string, int, decimal All sorts of other bug fixing and general purpose hackery. * Tds42.cs: * Tds50.cs: * Tds70.cs: ProcessColumnInfo was abstracted in Tds.cs and subclassed, because 7.0 provides the information in a different format. * TdsColumnSchema.cs: Added size, precision, scale * TdsComm.cs: Fixed GetString because it wasn't working properly with TDS 7.0. * TdsMessage.cs: Change state and severity to byte instead of int because that is more consitent. 2002-10-25 Tim Coleman (tim@timcoleman.com) * TdsPacketErrorResultCollection.cs: New class added for exporting errors * ITds.cs: * Tds.cs: * Tds70.cs: * TdsComm.cs: * TdsPacketEndTokenResult.cs: * TdsPacketRowResult.cs: Changes to make SqlClient build. 2002-10-24 Tim Coleman (tim@timcoleman.com) * ITds.cs: Added column info, and NextResult/NextRow to interface * TdsColumnSchema.cs: New class added to keep track of column info * Tds.cs: Many, many changes to get queries working for the most part. * TdsPacketColumnInfoResult.cs: * TdsPacketColumnNamesResult.cs: Doesn't use a DataColumnCollection anymore Also more complete. * TdsPacketRowResult.cs: Added Add() method. 2002-10-23 Tim Coleman (tim@timcoleman.com) * ITds.cs: * Tds42.cs: * Tds50.cs: * Tds70.cs: * Tds80.cs: New classes added. Functionality is split up because different protocols have slight differences. * Tds.cs: Remove some unnecessary code after the above split, and add in a whole lot more stuff for completeness. * TdsColumnType.cs: Fix Int4. Wrong enum value. * TdsComm.cs: Move the encoder out of constructor because we don't know the charset at that point * TdsConnectionParameters.cs: Small changes * TdsPacketEndTokenResult.cs: Implement ToString () 2002-10-22 Tim Coleman (tim@timcoleman.com) * Tds.cs : More implementation. Does some query stuff now. Can also change database. * TdsConnectionParameters.cs: Rename Host to DataSource, and add Hostname for the local hostname. * TdsPacketEndTokenResult.cs: Change TODO attribute * TODOAttribute.cs: New class added 2002-10-21 Tim Coleman (tim@timcoleman.com) * Tds.cs * TdsComm.cs: A whole slew of changes to get logon to work (it now works in both TDS 7.0 and TDS 4.2) ... danmorg can test with 8.0 if he likes. TdsComm has some simplifications too, because C# has some features not present in the Java implementation. * TdsConnectionParameters.cs: Change a few default values. * TdsMessage.cs: Implement this class. 2002-10-20 Tim Coleman (tim@timcoleman.com) * TdsColumnType.cs: * TdsContext.cs: * TdsEnvPacketSubType.cs: * TdsMessage.cs: * TdsPacketColumnInfoResult.cs: * TdsPacketColumnNamesResult.cs: * TdsPacketColumnOrderResult.cs: * TdsPacketControlResult.cs: * TdsPacketEndTokenResult.cs: * TdsPacketErrorResult.cs: * TdsPacketMessageResult.cs: * TdsPacketOutputParam.cs: * TdsPacketResult.cs: * TdsPacketRetStatResult.cs: * TdsPacketRowResult.cs: * TdsPacketSubType.cs: * TdsPacketTableNameResult.cs: * TdsPacketUnknown.cs: New classes added as part of TDS internal implementation. * Tds.cs: Some work on receiving and interpreting packages received from SQL Server. Still doesn't work completely. * TdsComm.cs: Add some methods as part of the ongoing work with Tds.cs * TdsConnectionParameters.cs: Add default values for Encoding ("iso-8859-1"), Port (1433), TDS Version (4.2). 2002-10-18 Tim Coleman (tim@timcoleman.com) * TdsConnectionInternal: Add some implementation details * TdsCommInternal: New class, which will handle the low-level communication with the database * TdsPacketTypeInternal: Add new packet type, TdsPacketTypeInternal.None which is used when no packet is being constructed. The value is 0. 2002-10-17 Tim Coleman (tim@timcoleman.com) * ChangeLog: New changelog added * TdsCommandInternal.cs: * TdsConnectionInternal.cs: * TdsPacketTypeInternal.cs: * TdsServerTypeInternal.cs: * TdsTransactionInternal.cs: * TdsVersionInternal.cs: New classes added. These are the internal implementations, meant for "wrapping" from other locations.