mono/mcs/class/System.Data/System.Data.Odbc/ChangeLog

2007-02-09  Nagappan A  <[email protected]>

	* OdbcDataReader.cs (GetDecimal): Implemented new API.

2007-01-08  Nagappan A  <[email protected]>

	* OdbcFactory.cs: Fixed compilation warning.

	* OdbcCategoryAttribute.cs (Category): Implemented missing
	property.

	* OdbcParameterCollection.cs: Fixed compilation warning.

	* OdbcCommandBuilder.cs (GetInsertCommand, GetUpdateCommand)
	(GetDeleteCommand): Implemented overloaded method.

	* OdbcTransaction.cs: Modified partial content of DOS format file
	to UNIX format.

2006-07-13  Senganal T  <[email protected]>

	* OdbcTransaction.cs OdbcCommand.cs OdbcConnectionFactory.cs 
	OdbcPermission.cs OdbcDataReader.cs OdbcParameterCollection.cs 
	OdbcConnection.cs OdbcFactory.cs OdbcParameter.cs :
		2.0 Api fixes

2006-05-31  Gert Driesen  <[email protected]>

	* OdbcErrorCollection.cs: Removed explicit interface implementation 
	of IEnumerable.GetEnumerator ().
	* OdbcCommand.cs: Removed destructor as the destructor in
	System.ComponentModel.Component already calls the Dispose method.
	Removed explicit interface implemenation of members that are 
	implement by public members.
	* OdbcDataReader.cs: Removed explicit interface implemenation of
	IDataRecord.GetData.

2006-05-24  Senganal T <[email protected]>
       
	* OdbcColumn.cs :
		- Added IsVariableSizeType : Handle types with variable datasize
	* OdbcTypeConverter.cs : map LongVarBinary to Image
	* OdbcDataReader.cs :
		- GetValue () : Handle Text,Image datatypes differently. Only allocate
		storage for the data contained and not for MaxLength. Fixes #78234

2006-05-09  Senganal T  <[email protected]>

	* OdbcConnection.cs : Implemented ChangeDatabase Method
	* libodbc.cs : Added value for CurrentCatalog in OdbcConnectionAttribute 

2006-02-17  Chris Toshok  <[email protected]>

	* OdbcDataReader.cs: remove VisibleFieldCount property.

2005-11-21  Senganal T <[email protected]>

	* OdbcTransaction.cs
	* OdbcCommandBuilder.cs
	* OdbcParameterCollection.cs
	* OdbcDataReader.cs
	* OdbcFactory.cs
	* OdbcDataAdapter.cs
	* OdbcParameter.cs
	
	Added stubs and other changes for ADO.NET 2.0 compatibility

2005-10-14  Senganal T <[email protected]>

	* OdbcColumn.cs : Changed the mapping of OdbcType.Char to string
	instead of char. Fixes bug #67269

2005-10-14  Senganal T <[email protected]>

	* OdbcDataReader.cs: Added Text and NText datatypes to the list
	of datatypes checked by GetValue () method. Fixes bug #75032

2005-10-14  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs (GetValue): Use SQL_CHAR for Numeric as
	temporary fix.

	* OdbcParameter.cs (CopyValue): Add support for Numeric & Decimal
	parameters.

2005-10-08  Sureshkumar T  <[email protected]>

	* OdbcCommand.cs (BindParameters): Copy the parameter Value after
	binding.

	* OdbcParameter.cs: re-implemented the native buffer handling and
	odbc type handling.

	* NativeBuffer.cs: A native buffer class to hold pointer to native
	memory.

	* OdbcTypeMap.cs (OdbcTypeMap): structure to hold different odbc
	types and the default mapping.

	* OdbcTypeConverter.cs: Simplified mapping between different odbc
	types using switch-case.

	* libodbc.cs (SQLBindParameter): use only one entry point and use
	IntPtr instead of ref.

2005-08-20  Gert Driesen  <[email protected]>

	* OdbcDataReader.cs: Marked GetPrimaryKeysBySQLStatistics unsafe.
	This fixes the build on Windows (using csc).

2005-08-09  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: GetSchemaTable (): set values for the column
	attributes using SQLColAttribute. If SQLPrimaryKeys does not
	yeild, try SQLStatistics. Optimized primary key logic.

	* libodbc.cs: Added api SQLStatistics and constants.

	* OdbcParameter.cs: setBuffer (): allocate a short int buffer for
	OdbcType.SmallInt. fixes bug #75600.

2005-08-08  Gert Driesen  <[email protected]>

	* OdbcConnection.cs: Marked Init helper method private.
	* OdbcCommand.cs: Marked BindParameters helper method private.

2005-08-08  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: Implemented Dispose pattern. Cache
	schematable for same result set. don't free command's statements
	if the command is prepared.

	* OdbcConnection.cs: Open (): set disposed to false so that close
	will be called in Dispose.

	* OdbcCommand.cs:
	- Prepare (): Split SQLPrepare and SQLBind so that
	already prepared statements can be reused with new parameter
	values.
	- ExecSQL (): create new statement handle, if not prepared
	and there are no parameters. if there are parameters, prepare and
	use.
	- Implemented Dispose pattern
	- Streamlined the allocation and de-allocation of statement
	handles.

2005-08-05  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: RecordsAffected: get value from command.
	GetSchemaTable (): set IsExpression based on BaseTableName. set
	AllowDBNull to false if the column is PK.

	* OdbcCommand.cs: correct UpdatedRowSource is returned. whitespace
	changes to conform to standard.

	* OdbcCommandBuilder.cs: Implemented.

	* OdbcParameter.cs: Direction is set to Input by default.

2005-07-22  Sureshkumar T  <[email protected]>

	* OdbcParameter.cs: updated attributes & attribute descriptions to
	match with masterinfos.

	* OdbcDataReader.cs: NextRow (): made private.

2005-07-21  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: GetValue (): added case for OdbcType.Bit. and
	Formatting corrections. Fixes bug #75574.

2005-07-07  Sureshkumar T  <[email protected]>

	* OdbcTypeConverter.cs: ConvertToSqlType & ConvertToSqlCType: map
	VarChar to SQL_C_CHAR and SQL_VARCHAR respective instead of WCHAR
	and WVARCHAR as temporary fix.

	* OdbcParameter.cs: setBuffer: string types need not be quoted.

2005-06-28  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: GetPrimaryKeys (): use the length indicator
	for GetString, otherwise, it creates a string of length 255. Use
	ArrayList for keys as the columns are different from the selected
	columns. fixes bug #75263.

2005-06-09  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: GetValue (): return decimal in case of odbc
	type Numeric. Move the temp buffer logic inside.

	* OdbcTypeConverter.cs: map SQL_TYPE.NUMERIC to SQL_C_TYPE.CHAR by
	now, since PgSql driver seems not to accept NUMERIC c type. Other
	database anyway, provides NUMERIC datatype as DECIMAL.

2005-05-31  Sureshkumar T  <[email protected]>

	* OdbcParameter.cs: setBuffer (): for numeric type, the buffer
	parameter should be a packed decimal struct. fixes bug #75041.

2005-04-05  Sureshkumar T  <[email protected]>

	* OdbcParameter.cs: SqlBindParameter requires the last parameter
	to be a ref.
	* libodbc.cs: API change for above.

2005-04-04  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: Ignore BaseTableName & BaseColumnName
	properties while building Schema information as most drivers
	ignores these properties. e.g. PostgreSQL.

2005-03-24  Sureshkumar T  <[email protected]>
	    Appasamy <[email protected]>

	* OdbcColumn.cs: IsStringType: OdbcType.Char is also of type
	String.
	* OdbcDataReader.cs: GetSchemaTable: Get Additional info using
	SQLColAttribute. Don't pad with spaces in GetColAttributeStr.

2005-03-24  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs:
	- GetValue: Decode only outsize length for SQL_C_TYPE.CHAR type in
	SQLGetData.
	- GetOrdinal: Perform case insensitive lookup if sensitive lookup
	fails.

2005-03-22  Sureshkumar T  <[email protected]>
            Appsamy <[email protected]>

	* libodbc.cs (System.Data.Odbc): Added enum FieldIdentifier. Added
	library functions SQLPrimaryKeys, SQLBindCol and SQLColAttribute.

	* OdbcDataReader.cs: Implemented GetPrimaryKeys to get the primary
	keys associated with resultset using SQLPrimaryKeys.

2005-03-15  Sureshkumar T  <[email protected]>

	* OdbcConnection.cs: re-throw error on exception in Open method.

2005-03-11  Sureshkumar T  <[email protected]>

	* OdbcConnection.cs : notify state change through event. clean up
	handles in case any exception while opening a connection. NET_2_0
	uses base class's OnStateChange handler.

2005-03-10  Sureshkumar T  <[email protected]>

	Migrated core classes to derive from ProviderBase instead of
	implementing IDb* interfaces. Most part of these files have been
	branched with #if NET_2_0/ONLY_1_1. Make sure any changes works
	with both the profiles.

	* OdbcFactory.cs: Concrete Factory for DbProviderFactory. Factory
	to generate Connection,Command,etc.

	* OdbcConnectionFactory.cs: Concrete factory for DbConnectionFactory.

	* OdbcTransaction.cs: migration and overrides.
	* OdbcCommandBuilder.cs: migration and overrides.
	* OdbcDataReader.cs: --do--. no command behavior member as it will
	be maintained in base provider class.
	* OdbcParameterCollection.cs: --do--. Now, local ArrayList is not
	maintained here, instead it is in base class. Most of the methods
	which operated on this list are not needed in NET_2_0.
	* OdbcConnection.cs: Migration. connectionString is maintained in
	DbConnectionBase class.
	* OdbcParameter.cs: Migration. Many of the local members like
	value,sourceColumn are maintained in DbParameterBase.
	* OdbcCommand.cs: Migration. commandText,timeout and
	commandTimeOut are maintained in DbCommandBase class.

2005-03-10  Sureshkumar T  <[email protected]>

	* OdbcType.cs: Added enums for SQL_TYPE & SQL_C_TYPE.
	
	* libodbc.cs: Accept SQL_C_TYPE for driver
	parameters. SQLBindParameter takes two parameters SQL_TYPE and
	SQL_C_TYPE. This caused the whole lot of changes done in this
	revision.
	
	* OdbcParameter.cs: Set default values of OdbcType & DbType. Pass
	mapped SQL_TYPE and SQL_C_TYPE to SQLBindParameter. Increase
	buffer size by 2 for additional ' chars.
	
	* OdbcTypeConverter.cs: Added class to convert between OdbcType,
	SQL_TYPE, SQL_C_TYPE.
	
	* OdbcColumn.cs: Added private members for SQL_TYPE and
	SQL_C_TYPE. conversion from/to odbctype to/from SQL_TYPE is done
	through OdbcTypeConverter class.
	
	* OdbcDataReader.cs: use OdbcColumn's SQL_C_TYPE member. It keeps
	track of default mapping between odbctype, SQL_TYPE and
	SQL_C_TYPE. Move dataTableSchema.AcceptChanges inside if condition
	to avoid null reference exception.

2005-02-04  Sureshkumar T  <[email protected]>
	    Appasamy <[email protected]>

	* OdbcConnection.cs: Implemented properties database, datasource,
	serverversion and driver.
	* libodbc.cs: Added type OdbcInfo and native call SQLGetInfo.

2005-01-20  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: case for type OdbcType.Double added in
	GetValue.  fixes bug #71173.

	Thanks to patch given by "Appasamy T" <[email protected]>

2005-01-19  Sureshkumar T  <[email protected]>

	* OdbcType.cs: Change enum values for compatiability with MS.NET.
	* libodbc.cs: Change enum values for compatiability with
	MS.NET. Change calls into driver with native type.
	* OdbcDataReader.cs: Change enum values for compatiability with
	MS.NET. Change calls from/into driver with native type.

2005-01-18  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: GetOrdinal need not check for
	currentRow. Return -1 if column name is not found.

	fixes bug #71261. Thanks to patch given by "Appasamy T"
	<[email protected]>.

2005-01-13  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: Implement NextResultSet for multiple result
	set queries. 
	
	* OdbcDataReader.cs: build column schema once creating reader and
	then for each Next result set. Thanks to
	[email protected] (Sebastien Robitaille) for
	pointing out this optimization (bugzilla #70530).

	* libodbc.cs: Added library calls SQLFreeStmt and SQLMoreResults
	for mutiple resultsets.

2005-01-10  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: Connection has to be closed only after
	Statement handle is freed. fixes bug #70048.

2005-01-07  Sureshkumar T  <[email protected]>

	* OdbcDataReader.cs: Pass OdbcCType.SignedBigInt for accessing big
	int columns.

	* OdbcType.cs: Added a new enum for Odbc C DataTypes. This should
	essentially be passed to drivers, since the public OdbcType types
	differs from types expected in drivers in some cases.

	* libodbc.cs : Added a ODBC method which takes OdbcCType
	enumeration for SQLGetData for BigInt fields.

	fixes bug #65342.

2004-12-28  Duncan Mak  <[email protected]>

	* libodbc.cs: Change all the DllImport attributes to point to
	"odbc32.dll" instead of "odbc32", because /etc/mono/config lists
	"odbc32.dll" (all other entries in the file have the .dll suffix
	as well, for consistency's sake, let's rename it here.)

	This fixes #70727.
	
2004-12-03  Sureshkumar T  <[email protected]>

	* OdbcParameter.cs: Fixed a null reference exception when a
	parameter is created and its value is not set. #68750.

2004-11-26  Sureshkumar T  <[email protected]>

	* OdbcParameter.cs: Fixed Parameter Size property as well as
	insufficient buffer errors. bug #68749.

2004-09-14  Sebastien Pouliot  <[email protected]>

	* OdbcPermission.cs: Added internal constructor accepting an Odbc
	PermissionAttribute parameter (using base class protected ctor).
	* OdbcPermissionAttribute.cs: Copy now use the new OdbcPermission
	constructor.

2004-09-13  Sebastien Pouliot  <[email protected]>

	* OdbcPermission.cs: Mostly completed (needs tests).
	* OdbcPermissionAttribute.cs: Completed.

2004-08-31 Umadevi S ([email protected])
	* OdbcDataReader.cs - Fixed Decimal parsing

2004-08-30 Umadevi S ([email protected])
	* OdbcType.cs - removed inheritance from short.

2004-08-27 Sureshkumar T ([email protected])
	* OdbcDataReader.cs - fixed bug #63539 - TINYINT ODBC datatype is converted into System.Byte

2004-08-26 Sureshkumar T ([email protected])
	* OdbcDataReader.cs - Date & DateTime GetValue fixed. 
			      GetBytes ordinal parameter passing fixed for BINARY in GetValue.

2004-08-20 Sureshkumar T ([email protected])
	* OdbcConnection.cs - correct handles are passed to OdbcError exception to trap the correct error

2004-08-04 Umadevi S ([email protected])
        * OdbcDataReader.cs - Fixed bug 61832 - Column names were not filled, due to which name based lookup of columns failed.
                                                                                                  

2004-08-04 Umadevi S ([email protected])
        * OdbcDataReader.cs - Fixed bug 61405 - Handling smallint column type.

2004-07-30  Sureshkumar T ([email protected])
        * OdbcCommand.cs: ExecuteNonQuery Closed statement handle to fix memory leak
        * OdbcDataReader.cs: Closed statement handle to fix memory leak
			     Removed SQLState login in GetBytes coz OdbcError provides the same.
				    
2004-07-29 Umadevi S ([email protected])
        * OdbcCommand.cs - Fixed bug 62046. ExecuteNonQuery implemented correctly
                                                                                                    

2004-07-28 Umadevi S ([email protected])
        * OdbcParameter.cs - fixed bug 61968. String values passed with quotes
                                                                                                 

2004-07-07 Umadevi S ([email protected])
        * OdbcConnection.cs - Allowed Close to be called multiple times
                            - Implementation of Dispose method

2004-07-07 Umadevi S ([email protected])
        * OdbcCommand.cs : fixed set method for Transaction
                                                          
2004-07-01  Sureshkumar T ([email protected])
	* OdbcCommand.cs   : fixed reader problem with ExecuteScalar

2004-06-23  Sureshkumar T ([email protected])
        * OdbcConnection.cs: Fix: Moved env allocation to Open method. 
			     Disconnection & freeing handles are done in Close 
			     method to avoid simultaneous connections.
	* libodbc.cs	   : Added constants for odbc version.
				    
2004-06-16  Gert Driesen <[email protected]>

	* OdbcError.cs: fixed serialization compatibility with MS.NET
	* OdbcErrorCollection.cs: fixed serialization compatibility with
	MS.NET
	* OdbcException.cs: fixed serialization compatibility with MS.NET

2004-06-16  Sureshkumar T ([email protected])
	* OdbcDataReader.cs: Added GetValue support for Sql Binary type to return byte array.
			     Implemented GetBytes method.
	* libodbc.cs	   : Added enums, constants & imports for above fix.

2004-06-13  Gert Driesen <[email protected]>

	* OdbcDataReader.cs: changed GetData method to return IDataReader
	to match MS.NET

2004-06-09  Sureshkumar T ([email protected])
        * OdbcDataReader.cs: Removed checking of currentRow in GetName
          method

2004-06-04  Gert Driesen <[email protected]>

	* OdbcPermission.cs: moved Obsolete attribute to correct
	ctor

2004-06-02  Sureshkumar T ([email protected])
       
	* OdbcDataReader.cs: Implemented GetByte method. Fixed bug #58820

2004-06-02  Gert Driesen <[email protected]>

        * OdbcParameter.cs: added missing attributes
        * OdbcPermission.cs: added missing attributes
        * OdbcConnection.cs: fixes attribute, added missing attributes
        * OdbcInfoMessageEventArgs.cs: removed extra properties, fixed
        API compatibility with MS.NET
        * OdbcCommandBuilder.cs: use correct attributes

2004-05-20  Gert Driesen ([email protected])

        *  OdbcPermissionAttribute.cs: change AllowMultiple and
        Inherited to match .NET

2004-05-17 Umadevi S ([email protected])
	* OdbcPermissionAttribute, OdbcPermission.cs - fixed missing methods

2004-05-17 Gert Driesen ([email protected])
	* OdbcCategoryAttribute.cs: fixed namespace
	* OdbcDataAdapter.cs: removed extra attributes
	* OdbcDescriptionAttribute.cs: fixed namespace

2004-05-14 Umadevi S ([email protected])
        * OdbcParameterConverter.cs -Added 
	* OdbcParameter.cs - Added some attributes	

2004-05-14 Umadevi S ([email protected])
        * OdbcDataAdapter.cs - Added Attributes

2004-05-14 Umadevi S ([email protected])
        * OdbcConnection.cs - Added Attributes

2004-05-14 Umadevi S ([email protected])
        * OdbcCommand.cs - Added Attributes

2004-05-14 Umadevi S ([email protected])
        * OdbcDataReader.cs - Added Attributes

2004-05-14 Umadevi S ([email protected])
        * Added Classes OdbcCategoryAttribute.cs, OdbcDescriptionAttribute.cs

2004-05-14 Umadevi S ([email protected])
	* Added Class OdbcCommandBuilder.cs

2004-05-14 Umadevi S ([email protected])
        * Added classes OdbcInfoMessageEventArgs.cs - with stubs
	* Added classes OdbcInfoMessageEventInfo.cs	

2004-05-14 Umadevi S ([email protected])
	* Added classes OdbcPermission.cs, OdbcPermissionAttribute.cs - with stubs

2004-05-09  Gert Driesen ([email protected])
	* OdbcException.cs : removed ErrorCode property, fixing signature
	* OdbcErrorCollection.cs : added internal ctor, reduced 
	accessibility of Add method to internal
	* OdbcCommand.cs: marked hstmt field private, remove setters for
	Parameters property
	* OdbcDataReader.cs: Added GetDate method, renamed GetTimeSpan to
	GetTime to match MS.NET, added HasRows stub

2004-05-09  Gert Driesen ([email protected])
	* OdbcError.cs: 
	* OdbcErrorCollection.cs:
	* OdbcException.cs: fixed linefeeds to DOS to match other
	sources in System.Data.Odbc

2004-05-09  Gert Driesen ([email protected])
	* OdbcCommand.cs: No longer use OdbcConnection.Datareader, in order 
	to fix signature of OdbcConnection
	* OdbcDataReader.cs: No longer use ODbcConnection.Datareader, in 
	order to fix signature of OdbcConnection
	* OdbcConnection.cs: Signature fixes: removed DataReader property, 
	added setter for ConnectionTimeout, made transaction internal
	* OdbcParameter.cs: reduced accessibility of Bind method to 
	internal, added setter for IsNullable
	* OdbcParameterCollection.cs: made default ctor and Bind method
	internal

2004-05-09  Gert Driesen ([email protected])
	* OdbcCommand.cs: fixed linefeeds to DOS to match other sources
	in System.Data.Odbc

2004-05-09  Gert Driesen ([email protected])
	* OdbcTransaction.cs: fixed signature to match MS.NET

2004-05-09  Gert Driesen ([email protected])
	* OdbcType.cs: fixed typo UniqueIndetifier
	* OdbcColumn.cs : fixed typo UniqueIndetifier

2004-05-09  Gert Driesen ([email protected])
	* OdbcType.cs: fixed linefeeds to DOS to match other sources
	in System.Data.Odbc

2003-12-01  Gonzalo Paniagua Javier <[email protected]>

	* OdbcTransaction.cs: applied patch from Jeff Seifert that makes
	this class implement IDbTransaction interface.

2002-11-01  Daniel Morgan <[email protected]>

	* OdbcDataReader.cs: - uncommented code, but I put a FIXME:
	according to Brian, this does not work on MS .NET however, we need it
	for Mono for now. schemaRow.AcceptChanges(),
	- implement IEnumerable.GetEnumerator()
    
	* libodbc.cs: changed the DllImport from "odbc32.dll" to "odbc32"
    
2002-10-21  Gonzalo Paniagua Javier <[email protected]>

	* ChangeLog: added.
	* OdbcError.cs:
	* OdbcException.cs: added dummy implementation for these missing
	classes.