1 2006-07-13 Senganal T <tsenganal@novell.com>
3 * OdbcTransaction.cs OdbcCommand.cs OdbcConnectionFactory.cs
4 OdbcPermission.cs OdbcDataReader.cs OdbcParameterCollection.cs
5 OdbcConnection.cs OdbcFactory.cs OdbcParameter.cs :
8 2006-05-31 Gert Driesen <drieseng@users.sourceforge.net>
10 * OdbcErrorCollection.cs: Removed explicit interface implementation
11 of IEnumerable.GetEnumerator ().
12 * OdbcCommand.cs: Removed destructor as the destructor in
13 System.ComponentModel.Component already calls the Dispose method.
14 Removed explicit interface implemenation of members that are
15 implement by public members.
16 * OdbcDataReader.cs: Removed explicit interface implemenation of
19 2006-05-24 Senganal T <tsenganal@novell.com>
22 - Added IsVariableSizeType : Handle types with variable datasize
23 * OdbcTypeConverter.cs : map LongVarBinary to Image
25 - GetValue () : Handle Text,Image datatypes differently. Only allocate
26 storage for the data contained and not for MaxLength. Fixes #78234
28 2006-05-09 Senganal T <tsenganal@novell.com>
30 * OdbcConnection.cs : Implemented ChangeDatabase Method
31 * libodbc.cs : Added value for CurrentCatalog in OdbcConnectionAttribute
33 2006-02-17 Chris Toshok <toshok@ximian.com>
35 * OdbcDataReader.cs: remove VisibleFieldCount property.
37 2005-11-21 Senganal T <tsenganal@novell.com>
40 * OdbcCommandBuilder.cs
41 * OdbcParameterCollection.cs
47 Added stubs and other changes for ADO.NET 2.0 compatibility
49 2005-10-14 Senganal T <tsenganal@novell.com>
51 * OdbcColumn.cs : Changed the mapping of OdbcType.Char to string
52 instead of char. Fixes bug #67269
54 2005-10-14 Senganal T <tsenganal@novell.com>
56 * OdbcDataReader.cs: Added Text and NText datatypes to the list
57 of datatypes checked by GetValue () method. Fixes bug #75032
59 2005-10-14 Sureshkumar T <tsureshkumar@novell.com>
61 * OdbcDataReader.cs (GetValue): Use SQL_CHAR for Numeric as
64 * OdbcParameter.cs (CopyValue): Add support for Numeric & Decimal
67 2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
69 * OdbcCommand.cs (BindParameters): Copy the parameter Value after
72 * OdbcParameter.cs: re-implemented the native buffer handling and
75 * NativeBuffer.cs: A native buffer class to hold pointer to native
78 * OdbcTypeMap.cs (OdbcTypeMap): structure to hold different odbc
79 types and the default mapping.
81 * OdbcTypeConverter.cs: Simplified mapping between different odbc
82 types using switch-case.
84 * libodbc.cs (SQLBindParameter): use only one entry point and use
85 IntPtr instead of ref.
87 2005-08-20 Gert Driesen <drieseng@users.sourceforge.net>
89 * OdbcDataReader.cs: Marked GetPrimaryKeysBySQLStatistics unsafe.
90 This fixes the build on Windows (using csc).
92 2005-08-09 Sureshkumar T <tsureshkumar@novell.com>
94 * OdbcDataReader.cs: GetSchemaTable (): set values for the column
95 attributes using SQLColAttribute. If SQLPrimaryKeys does not
96 yeild, try SQLStatistics. Optimized primary key logic.
98 * libodbc.cs: Added api SQLStatistics and constants.
100 * OdbcParameter.cs: setBuffer (): allocate a short int buffer for
101 OdbcType.SmallInt. fixes bug #75600.
103 2005-08-08 Gert Driesen <drieseng@users.sourceforge.net>
105 * OdbcConnection.cs: Marked Init helper method private.
106 * OdbcCommand.cs: Marked BindParameters helper method private.
108 2005-08-08 Sureshkumar T <tsureshkumar@novell.com>
110 * OdbcDataReader.cs: Implemented Dispose pattern. Cache
111 schematable for same result set. don't free command's statements
112 if the command is prepared.
114 * OdbcConnection.cs: Open (): set disposed to false so that close
115 will be called in Dispose.
118 - Prepare (): Split SQLPrepare and SQLBind so that
119 already prepared statements can be reused with new parameter
121 - ExecSQL (): create new statement handle, if not prepared
122 and there are no parameters. if there are parameters, prepare and
124 - Implemented Dispose pattern
125 - Streamlined the allocation and de-allocation of statement
128 2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
130 * OdbcDataReader.cs: RecordsAffected: get value from command.
131 GetSchemaTable (): set IsExpression based on BaseTableName. set
132 AllowDBNull to false if the column is PK.
134 * OdbcCommand.cs: correct UpdatedRowSource is returned. whitespace
135 changes to conform to standard.
137 * OdbcCommandBuilder.cs: Implemented.
139 * OdbcParameter.cs: Direction is set to Input by default.
141 2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
143 * OdbcParameter.cs: updated attributes & attribute descriptions to
144 match with masterinfos.
146 * OdbcDataReader.cs: NextRow (): made private.
148 2005-07-21 Sureshkumar T <tsureshkumar@novell.com>
150 * OdbcDataReader.cs: GetValue (): added case for OdbcType.Bit. and
151 Formatting corrections. Fixes bug #75574.
153 2005-07-07 Sureshkumar T <tsureshkumar@novell.com>
155 * OdbcTypeConverter.cs: ConvertToSqlType & ConvertToSqlCType: map
156 VarChar to SQL_C_CHAR and SQL_VARCHAR respective instead of WCHAR
157 and WVARCHAR as temporary fix.
159 * OdbcParameter.cs: setBuffer: string types need not be quoted.
161 2005-06-28 Sureshkumar T <tsureshkumar@novell.com>
163 * OdbcDataReader.cs: GetPrimaryKeys (): use the length indicator
164 for GetString, otherwise, it creates a string of length 255. Use
165 ArrayList for keys as the columns are different from the selected
166 columns. fixes bug #75263.
168 2005-06-09 Sureshkumar T <tsureshkumar@novell.com>
170 * OdbcDataReader.cs: GetValue (): return decimal in case of odbc
171 type Numeric. Move the temp buffer logic inside.
173 * OdbcTypeConverter.cs: map SQL_TYPE.NUMERIC to SQL_C_TYPE.CHAR by
174 now, since PgSql driver seems not to accept NUMERIC c type. Other
175 database anyway, provides NUMERIC datatype as DECIMAL.
177 2005-05-31 Sureshkumar T <tsureshkumar@novell.com>
179 * OdbcParameter.cs: setBuffer (): for numeric type, the buffer
180 parameter should be a packed decimal struct. fixes bug #75041.
182 2005-04-05 Sureshkumar T <tsureshkumar@novell.com>
184 * OdbcParameter.cs: SqlBindParameter requires the last parameter
186 * libodbc.cs: API change for above.
188 2005-04-04 Sureshkumar T <tsureshkumar@novell.com>
190 * OdbcDataReader.cs: Ignore BaseTableName & BaseColumnName
191 properties while building Schema information as most drivers
192 ignores these properties. e.g. PostgreSQL.
194 2005-03-24 Sureshkumar T <tsureshkumar@novell.com>
195 Appasamy <appasamy@rediffmail.com>
197 * OdbcColumn.cs: IsStringType: OdbcType.Char is also of type
199 * OdbcDataReader.cs: GetSchemaTable: Get Additional info using
200 SQLColAttribute. Don't pad with spaces in GetColAttributeStr.
202 2005-03-24 Sureshkumar T <tsureshkumar@novell.com>
205 - GetValue: Decode only outsize length for SQL_C_TYPE.CHAR type in
207 - GetOrdinal: Perform case insensitive lookup if sensitive lookup
210 2005-03-22 Sureshkumar T <tsureshkumar@novell.com>
211 Appsamy <appasamy@rediffmail.com>
213 * libodbc.cs (System.Data.Odbc): Added enum FieldIdentifier. Added
214 library functions SQLPrimaryKeys, SQLBindCol and SQLColAttribute.
216 * OdbcDataReader.cs: Implemented GetPrimaryKeys to get the primary
217 keys associated with resultset using SQLPrimaryKeys.
219 2005-03-15 Sureshkumar T <tsureshkumar@novell.com>
221 * OdbcConnection.cs: re-throw error on exception in Open method.
223 2005-03-11 Sureshkumar T <tsureshkumar@novell.com>
225 * OdbcConnection.cs : notify state change through event. clean up
226 handles in case any exception while opening a connection. NET_2_0
227 uses base class's OnStateChange handler.
229 2005-03-10 Sureshkumar T <tsureshkumar@novell.com>
231 Migrated core classes to derive from ProviderBase instead of
232 implementing IDb* interfaces. Most part of these files have been
233 branched with #if NET_2_0/ONLY_1_1. Make sure any changes works
234 with both the profiles.
236 * OdbcFactory.cs: Concrete Factory for DbProviderFactory. Factory
237 to generate Connection,Command,etc.
239 * OdbcConnectionFactory.cs: Concrete factory for DbConnectionFactory.
241 * OdbcTransaction.cs: migration and overrides.
242 * OdbcCommandBuilder.cs: migration and overrides.
243 * OdbcDataReader.cs: --do--. no command behavior member as it will
244 be maintained in base provider class.
245 * OdbcParameterCollection.cs: --do--. Now, local ArrayList is not
246 maintained here, instead it is in base class. Most of the methods
247 which operated on this list are not needed in NET_2_0.
248 * OdbcConnection.cs: Migration. connectionString is maintained in
249 DbConnectionBase class.
250 * OdbcParameter.cs: Migration. Many of the local members like
251 value,sourceColumn are maintained in DbParameterBase.
252 * OdbcCommand.cs: Migration. commandText,timeout and
253 commandTimeOut are maintained in DbCommandBase class.
255 2005-03-10 Sureshkumar T <tsureshkumar@novell.com>
257 * OdbcType.cs: Added enums for SQL_TYPE & SQL_C_TYPE.
259 * libodbc.cs: Accept SQL_C_TYPE for driver
260 parameters. SQLBindParameter takes two parameters SQL_TYPE and
261 SQL_C_TYPE. This caused the whole lot of changes done in this
264 * OdbcParameter.cs: Set default values of OdbcType & DbType. Pass
265 mapped SQL_TYPE and SQL_C_TYPE to SQLBindParameter. Increase
266 buffer size by 2 for additional ' chars.
268 * OdbcTypeConverter.cs: Added class to convert between OdbcType,
269 SQL_TYPE, SQL_C_TYPE.
271 * OdbcColumn.cs: Added private members for SQL_TYPE and
272 SQL_C_TYPE. conversion from/to odbctype to/from SQL_TYPE is done
273 through OdbcTypeConverter class.
275 * OdbcDataReader.cs: use OdbcColumn's SQL_C_TYPE member. It keeps
276 track of default mapping between odbctype, SQL_TYPE and
277 SQL_C_TYPE. Move dataTableSchema.AcceptChanges inside if condition
278 to avoid null reference exception.
280 2005-02-04 Sureshkumar T <tsureshkumar@novell.com>
281 Appasamy <appasamy@rediffmail.com>
283 * OdbcConnection.cs: Implemented properties database, datasource,
284 serverversion and driver.
285 * libodbc.cs: Added type OdbcInfo and native call SQLGetInfo.
287 2005-01-20 Sureshkumar T <tsureshkumar@novell.com>
289 * OdbcDataReader.cs: case for type OdbcType.Double added in
290 GetValue. fixes bug #71173.
292 Thanks to patch given by "Appasamy T" <appasamy@rediffmail.com>
294 2005-01-19 Sureshkumar T <tsureshkumar@novell.com>
296 * OdbcType.cs: Change enum values for compatiability with MS.NET.
297 * libodbc.cs: Change enum values for compatiability with
298 MS.NET. Change calls into driver with native type.
299 * OdbcDataReader.cs: Change enum values for compatiability with
300 MS.NET. Change calls from/into driver with native type.
302 2005-01-18 Sureshkumar T <tsureshkumar@novell.com>
304 * OdbcDataReader.cs: GetOrdinal need not check for
305 currentRow. Return -1 if column name is not found.
307 fixes bug #71261. Thanks to patch given by "Appasamy T"
308 <appasamy@rediffmail.com>.
310 2005-01-13 Sureshkumar T <tsureshkumar@novell.com>
312 * OdbcDataReader.cs: Implement NextResultSet for multiple result
315 * OdbcDataReader.cs: build column schema once creating reader and
316 then for each Next result set. Thanks to
317 sebastien.robitaille@croesus.com (Sebastien Robitaille) for
318 pointing out this optimization (bugzilla #70530).
320 * libodbc.cs: Added library calls SQLFreeStmt and SQLMoreResults
321 for mutiple resultsets.
323 2005-01-10 Sureshkumar T <tsureshkumar@novell.com>
325 * OdbcDataReader.cs: Connection has to be closed only after
326 Statement handle is freed. fixes bug #70048.
328 2005-01-07 Sureshkumar T <tsureshkumar@novell.com>
330 * OdbcDataReader.cs: Pass OdbcCType.SignedBigInt for accessing big
333 * OdbcType.cs: Added a new enum for Odbc C DataTypes. This should
334 essentially be passed to drivers, since the public OdbcType types
335 differs from types expected in drivers in some cases.
337 * libodbc.cs : Added a ODBC method which takes OdbcCType
338 enumeration for SQLGetData for BigInt fields.
342 2004-12-28 Duncan Mak <duncan@ximian.com>
344 * libodbc.cs: Change all the DllImport attributes to point to
345 "odbc32.dll" instead of "odbc32", because /etc/mono/config lists
346 "odbc32.dll" (all other entries in the file have the .dll suffix
347 as well, for consistency's sake, let's rename it here.)
351 2004-12-03 Sureshkumar T <tsureshkumar@novell.com>
353 * OdbcParameter.cs: Fixed a null reference exception when a
354 parameter is created and its value is not set. #68750.
356 2004-11-26 Sureshkumar T <tsureshkumar@novell.com>
358 * OdbcParameter.cs: Fixed Parameter Size property as well as
359 insufficient buffer errors. bug #68749.
361 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
363 * OdbcPermission.cs: Added internal constructor accepting an Odbc
364 PermissionAttribute parameter (using base class protected ctor).
365 * OdbcPermissionAttribute.cs: Copy now use the new OdbcPermission
368 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
370 * OdbcPermission.cs: Mostly completed (needs tests).
371 * OdbcPermissionAttribute.cs: Completed.
373 2004-08-31 Umadevi S (sumadevi@novell.com)
374 * OdbcDataReader.cs - Fixed Decimal parsing
376 2004-08-30 Umadevi S (sumadevi@novell.com)
377 * OdbcType.cs - removed inheritance from short.
379 2004-08-27 Sureshkumar T (tsureshkumar@novell.com)
380 * OdbcDataReader.cs - fixed bug #63539 - TINYINT ODBC datatype is converted into System.Byte
382 2004-08-26 Sureshkumar T (tsureshkumar@novell.com)
383 * OdbcDataReader.cs - Date & DateTime GetValue fixed.
384 GetBytes ordinal parameter passing fixed for BINARY in GetValue.
386 2004-08-20 Sureshkumar T (tsureshkumar@novell.com)
387 * OdbcConnection.cs - correct handles are passed to OdbcError exception to trap the correct error
389 2004-08-04 Umadevi S (sumadevi@novell.com)
390 * OdbcDataReader.cs - Fixed bug 61832 - Column names were not filled, due to which name based lookup of columns failed.
393 2004-08-04 Umadevi S (sumadevi@novell.com)
394 * OdbcDataReader.cs - Fixed bug 61405 - Handling smallint column type.
396 2004-07-30 Sureshkumar T (tsureshkumar@novell.com)
397 * OdbcCommand.cs: ExecuteNonQuery Closed statement handle to fix memory leak
398 * OdbcDataReader.cs: Closed statement handle to fix memory leak
399 Removed SQLState login in GetBytes coz OdbcError provides the same.
401 2004-07-29 Umadevi S (sumadevi@novell.com)
402 * OdbcCommand.cs - Fixed bug 62046. ExecuteNonQuery implemented correctly
405 2004-07-28 Umadevi S (sumadevi@novell.com)
406 * OdbcParameter.cs - fixed bug 61968. String values passed with quotes
409 2004-07-07 Umadevi S (sumadevi@novell.com)
410 * OdbcConnection.cs - Allowed Close to be called multiple times
411 - Implementation of Dispose method
413 2004-07-07 Umadevi S (sumadevi@novell.com)
414 * OdbcCommand.cs : fixed set method for Transaction
416 2004-07-01 Sureshkumar T (tsureshkumar@novell.com)
417 * OdbcCommand.cs : fixed reader problem with ExecuteScalar
419 2004-06-23 Sureshkumar T (tsureshkumar@novell.com)
420 * OdbcConnection.cs: Fix: Moved env allocation to Open method.
421 Disconnection & freeing handles are done in Close
422 method to avoid simultaneous connections.
423 * libodbc.cs : Added constants for odbc version.
425 2004-06-16 Gert Driesen <drieseng@users.sourceforge.net>
427 * OdbcError.cs: fixed serialization compatibility with MS.NET
428 * OdbcErrorCollection.cs: fixed serialization compatibility with
430 * OdbcException.cs: fixed serialization compatibility with MS.NET
432 2004-06-16 Sureshkumar T (tsureshkumar@novell.com)
433 * OdbcDataReader.cs: Added GetValue support for Sql Binary type to return byte array.
434 Implemented GetBytes method.
435 * libodbc.cs : Added enums, constants & imports for above fix.
437 2004-06-13 Gert Driesen <drieseng@users.sourceforge.net>
439 * OdbcDataReader.cs: changed GetData method to return IDataReader
442 2004-06-09 Sureshkumar T (tsureshkumar@novell.com)
443 * OdbcDataReader.cs: Removed checking of currentRow in GetName
446 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
448 * OdbcPermission.cs: moved Obsolete attribute to correct
451 2004-06-02 Sureshkumar T (tsureshkumar@novell.com)
453 * OdbcDataReader.cs: Implemented GetByte method. Fixed bug #58820
455 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
457 * OdbcParameter.cs: added missing attributes
458 * OdbcPermission.cs: added missing attributes
459 * OdbcConnection.cs: fixes attribute, added missing attributes
460 * OdbcInfoMessageEventArgs.cs: removed extra properties, fixed
461 API compatibility with MS.NET
462 * OdbcCommandBuilder.cs: use correct attributes
464 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
466 * OdbcPermissionAttribute.cs: change AllowMultiple and
467 Inherited to match .NET
469 2004-05-17 Umadevi S (sumadevi@novell.com)
470 * OdbcPermissionAttribute, OdbcPermission.cs - fixed missing methods
472 2004-05-17 Gert Driesen (drieseng@users.sourceforge.net)
473 * OdbcCategoryAttribute.cs: fixed namespace
474 * OdbcDataAdapter.cs: removed extra attributes
475 * OdbcDescriptionAttribute.cs: fixed namespace
477 2004-05-14 Umadevi S (sumadevi@novell.com)
478 * OdbcParameterConverter.cs -Added
479 * OdbcParameter.cs - Added some attributes
481 2004-05-14 Umadevi S (sumadevi@novell.com)
482 * OdbcDataAdapter.cs - Added Attributes
484 2004-05-14 Umadevi S (sumadevi@novell.com)
485 * OdbcConnection.cs - Added Attributes
487 2004-05-14 Umadevi S (sumadevi@novell.com)
488 * OdbcCommand.cs - Added Attributes
490 2004-05-14 Umadevi S (sumadevi@novell.com)
491 * OdbcDataReader.cs - Added Attributes
493 2004-05-14 Umadevi S (sumadevi@novell.com)
494 * Added Classes OdbcCategoryAttribute.cs, OdbcDescriptionAttribute.cs
496 2004-05-14 Umadevi S (sumadevi@novell.com)
497 * Added Class OdbcCommandBuilder.cs
499 2004-05-14 Umadevi S (sumadevi@novell.com)
500 * Added classes OdbcInfoMessageEventArgs.cs - with stubs
501 * Added classes OdbcInfoMessageEventInfo.cs
503 2004-05-14 Umadevi S (sumadevi@novell.com)
504 * Added classes OdbcPermission.cs, OdbcPermissionAttribute.cs - with stubs
506 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
507 * OdbcException.cs : removed ErrorCode property, fixing signature
508 * OdbcErrorCollection.cs : added internal ctor, reduced
509 accessibility of Add method to internal
510 * OdbcCommand.cs: marked hstmt field private, remove setters for
512 * OdbcDataReader.cs: Added GetDate method, renamed GetTimeSpan to
513 GetTime to match MS.NET, added HasRows stub
515 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
517 * OdbcErrorCollection.cs:
518 * OdbcException.cs: fixed linefeeds to DOS to match other
519 sources in System.Data.Odbc
521 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
522 * OdbcCommand.cs: No longer use OdbcConnection.Datareader, in order
523 to fix signature of OdbcConnection
524 * OdbcDataReader.cs: No longer use ODbcConnection.Datareader, in
525 order to fix signature of OdbcConnection
526 * OdbcConnection.cs: Signature fixes: removed DataReader property,
527 added setter for ConnectionTimeout, made transaction internal
528 * OdbcParameter.cs: reduced accessibility of Bind method to
529 internal, added setter for IsNullable
530 * OdbcParameterCollection.cs: made default ctor and Bind method
533 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
534 * OdbcCommand.cs: fixed linefeeds to DOS to match other sources
537 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
538 * OdbcTransaction.cs: fixed signature to match MS.NET
540 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
541 * OdbcType.cs: fixed typo UniqueIndetifier
542 * OdbcColumn.cs : fixed typo UniqueIndetifier
544 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
545 * OdbcType.cs: fixed linefeeds to DOS to match other sources
548 2003-12-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
550 * OdbcTransaction.cs: applied patch from Jeff Seifert that makes
551 this class implement IDbTransaction interface.
553 2002-11-01 Daniel Morgan <danmorg@sc.rr.com>
555 * OdbcDataReader.cs: - uncommented code, but I put a FIXME:
556 according to Brian, this does not work on MS .NET however, we need it
557 for Mono for now. schemaRow.AcceptChanges(),
558 - implement IEnumerable.GetEnumerator()
560 * libodbc.cs: changed the DllImport from "odbc32.dll" to "odbc32"
562 2002-10-21 Gonzalo Paniagua Javier <gonzalo@ximian.com>
566 * OdbcException.cs: added dummy implementation for these missing