1 2005-08-09 Sureshkumar T <tsureshkumar@novell.com>
3 * OdbcParameter.cs: setBuffer (): allocate a short int buffer for
4 OdbcType.SmallInt. fixes bug #75600.
6 2005-08-08 Gert Driesen <drieseng@users.sourceforge.net>
8 * OdbcConnection.cs: Marked Init helper method private.
9 * OdbcCommand.cs: Marked BindParameters helper method private.
11 2005-08-08 Sureshkumar T <tsureshkumar@novell.com>
13 * OdbcDataReader.cs: Implemented Dispose pattern. Cache
14 schematable for same result set. don't free command's statements
15 if the command is prepared.
17 * OdbcConnection.cs: Open (): set disposed to false so that close
18 will be called in Dispose.
21 - Prepare (): Split SQLPrepare and SQLBind so that
22 already prepared statements can be reused with new parameter
24 - ExecSQL (): create new statement handle, if not prepared
25 and there are no parameters. if there are parameters, prepare and
27 - Implemented Dispose pattern
28 - Streamlined the allocation and de-allocation of statement
31 2005-08-05 Sureshkumar T <tsureshkumar@novell.com>
33 * OdbcDataReader.cs: RecordsAffected: get value from command.
34 GetSchemaTable (): set IsExpression based on BaseTableName. set
35 AllowDBNull to false if the column is PK.
37 * OdbcCommand.cs: correct UpdatedRowSource is returned. whitespace
38 changes to conform to standard.
40 * OdbcCommandBuilder.cs: Implemented.
42 * OdbcParameter.cs: Direction is set to Input by default.
44 2005-07-22 Sureshkumar T <tsureshkumar@novell.com>
46 * OdbcParameter.cs: updated attributes & attribute descriptions to
47 match with masterinfos.
49 * OdbcDataReader.cs: NextRow (): made private.
51 2005-07-21 Sureshkumar T <tsureshkumar@novell.com>
53 * OdbcDataReader.cs: GetValue (): added case for OdbcType.Bit. and
54 Formatting corrections. Fixes bug #75574.
56 2005-07-07 Sureshkumar T <tsureshkumar@novell.com>
58 * OdbcTypeConverter.cs: ConvertToSqlType & ConvertToSqlCType: map
59 VarChar to SQL_C_CHAR and SQL_VARCHAR respective instead of WCHAR
60 and WVARCHAR as temporary fix.
62 * OdbcParameter.cs: setBuffer: string types need not be quoted.
64 2005-06-28 Sureshkumar T <tsureshkumar@novell.com>
66 * OdbcDataReader.cs: GetPrimaryKeys (): use the length indicator
67 for GetString, otherwise, it creates a string of length 255. Use
68 ArrayList for keys as the columns are different from the selected
69 columns. fixes bug #75263.
71 2005-06-09 Sureshkumar T <tsureshkumar@novell.com>
73 * OdbcDataReader.cs: GetValue (): return decimal in case of odbc
74 type Numeric. Move the temp buffer logic inside.
76 * OdbcTypeConverter.cs: map SQL_TYPE.NUMERIC to SQL_C_TYPE.CHAR by
77 now, since PgSql driver seems not to accept NUMERIC c type. Other
78 database anyway, provides NUMERIC datatype as DECIMAL.
80 2005-05-31 Sureshkumar T <tsureshkumar@novell.com>
82 * OdbcParameter.cs: setBuffer (): for numeric type, the buffer
83 parameter should be a packed decimal struct. fixes bug #75041.
85 2005-04-05 Sureshkumar T <tsureshkumar@novell.com>
87 * OdbcParameter.cs: SqlBindParameter requires the last parameter
89 * libodbc.cs: API change for above.
91 2005-04-04 Sureshkumar T <tsureshkumar@novell.com>
93 * OdbcDataReader.cs: Ignore BaseTableName & BaseColumnName
94 properties while building Schema information as most drivers
95 ignores these properties. e.g. PostgreSQL.
97 2005-03-24 Sureshkumar T <tsureshkumar@novell.com>
98 Appasamy <appasamy@rediffmail.com>
100 * OdbcColumn.cs: IsStringType: OdbcType.Char is also of type
102 * OdbcDataReader.cs: GetSchemaTable: Get Additional info using
103 SQLColAttribute. Don't pad with spaces in GetColAttributeStr.
105 2005-03-24 Sureshkumar T <tsureshkumar@novell.com>
108 - GetValue: Decode only outsize length for SQL_C_TYPE.CHAR type in
110 - GetOrdinal: Perform case insensitive lookup if sensitive lookup
113 2005-03-22 Sureshkumar T <tsureshkumar@novell.com>
114 Appsamy <appasamy@rediffmail.com>
116 * libodbc.cs (System.Data.Odbc): Added enum FieldIdentifier. Added
117 library functions SQLPrimaryKeys, SQLBindCol and SQLColAttribute.
119 * OdbcDataReader.cs: Implemented GetPrimaryKeys to get the primary
120 keys associated with resultset using SQLPrimaryKeys.
122 2005-03-15 Sureshkumar T <tsureshkumar@novell.com>
124 * OdbcConnection.cs: re-throw error on exception in Open method.
126 2005-03-11 Sureshkumar T <tsureshkumar@novell.com>
128 * OdbcConnection.cs : notify state change through event. clean up
129 handles in case any exception while opening a connection. NET_2_0
130 uses base class's OnStateChange handler.
132 2005-03-10 Sureshkumar T <tsureshkumar@novell.com>
134 Migrated core classes to derive from ProviderBase instead of
135 implementing IDb* interfaces. Most part of these files have been
136 branched with #if NET_2_0/ONLY_1_1. Make sure any changes works
137 with both the profiles.
139 * OdbcFactory.cs: Concrete Factory for DbProviderFactory. Factory
140 to generate Connection,Command,etc.
142 * OdbcConnectionFactory.cs: Concrete factory for DbConnectionFactory.
144 * OdbcTransaction.cs: migration and overrides.
145 * OdbcCommandBuilder.cs: migration and overrides.
146 * OdbcDataReader.cs: --do--. no command behavior member as it will
147 be maintained in base provider class.
148 * OdbcParameterCollection.cs: --do--. Now, local ArrayList is not
149 maintained here, instead it is in base class. Most of the methods
150 which operated on this list are not needed in NET_2_0.
151 * OdbcConnection.cs: Migration. connectionString is maintained in
152 DbConnectionBase class.
153 * OdbcParameter.cs: Migration. Many of the local members like
154 value,sourceColumn are maintained in DbParameterBase.
155 * OdbcCommand.cs: Migration. commandText,timeout and
156 commandTimeOut are maintained in DbCommandBase class.
158 2005-03-10 Sureshkumar T <tsureshkumar@novell.com>
160 * OdbcType.cs: Added enums for SQL_TYPE & SQL_C_TYPE.
162 * libodbc.cs: Accept SQL_C_TYPE for driver
163 parameters. SQLBindParameter takes two parameters SQL_TYPE and
164 SQL_C_TYPE. This caused the whole lot of changes done in this
167 * OdbcParameter.cs: Set default values of OdbcType & DbType. Pass
168 mapped SQL_TYPE and SQL_C_TYPE to SQLBindParameter. Increase
169 buffer size by 2 for additional ' chars.
171 * OdbcTypeConverter.cs: Added class to convert between OdbcType,
172 SQL_TYPE, SQL_C_TYPE.
174 * OdbcColumn.cs: Added private members for SQL_TYPE and
175 SQL_C_TYPE. conversion from/to odbctype to/from SQL_TYPE is done
176 through OdbcTypeConverter class.
178 * OdbcDataReader.cs: use OdbcColumn's SQL_C_TYPE member. It keeps
179 track of default mapping between odbctype, SQL_TYPE and
180 SQL_C_TYPE. Move dataTableSchema.AcceptChanges inside if condition
181 to avoid null reference exception.
183 2005-02-04 Sureshkumar T <tsureshkumar@novell.com>
184 Appasamy <appasamy@rediffmail.com>
186 * OdbcConnection.cs: Implemented properties database, datasource,
187 serverversion and driver.
188 * libodbc.cs: Added type OdbcInfo and native call SQLGetInfo.
190 2005-01-20 Sureshkumar T <tsureshkumar@novell.com>
192 * OdbcDataReader.cs: case for type OdbcType.Double added in
193 GetValue. fixes bug #71173.
195 Thanks to patch given by "Appasamy T" <appasamy@rediffmail.com>
197 2005-01-19 Sureshkumar T <tsureshkumar@novell.com>
199 * OdbcType.cs: Change enum values for compatiability with MS.NET.
200 * libodbc.cs: Change enum values for compatiability with
201 MS.NET. Change calls into driver with native type.
202 * OdbcDataReader.cs: Change enum values for compatiability with
203 MS.NET. Change calls from/into driver with native type.
205 2005-01-18 Sureshkumar T <tsureshkumar@novell.com>
207 * OdbcDataReader.cs: GetOrdinal need not check for
208 currentRow. Return -1 if column name is not found.
210 fixes bug #71261. Thanks to patch given by "Appasamy T"
211 <appasamy@rediffmail.com>.
213 2005-01-13 Sureshkumar T <tsureshkumar@novell.com>
215 * OdbcDataReader.cs: Implement NextResultSet for multiple result
218 * OdbcDataReader.cs: build column schema once creating reader and
219 then for each Next result set. Thanks to
220 sebastien.robitaille@croesus.com (Sebastien Robitaille) for
221 pointing out this optimization (bugzilla #70530).
223 * libodbc.cs: Added library calls SQLFreeStmt and SQLMoreResults
224 for mutiple resultsets.
226 2005-01-10 Sureshkumar T <tsureshkumar@novell.com>
228 * OdbcDataReader.cs: Connection has to be closed only after
229 Statement handle is freed. fixes bug #70048.
231 2005-01-07 Sureshkumar T <tsureshkumar@novell.com>
233 * OdbcDataReader.cs: Pass OdbcCType.SignedBigInt for accessing big
236 * OdbcType.cs: Added a new enum for Odbc C DataTypes. This should
237 essentially be passed to drivers, since the public OdbcType types
238 differs from types expected in drivers in some cases.
240 * libodbc.cs : Added a ODBC method which takes OdbcCType
241 enumeration for SQLGetData for BigInt fields.
245 2004-12-28 Duncan Mak <duncan@ximian.com>
247 * libodbc.cs: Change all the DllImport attributes to point to
248 "odbc32.dll" instead of "odbc32", because /etc/mono/config lists
249 "odbc32.dll" (all other entries in the file have the .dll suffix
250 as well, for consistency's sake, let's rename it here.)
254 2004-12-03 Sureshkumar T <tsureshkumar@novell.com>
256 * OdbcParameter.cs: Fixed a null reference exception when a
257 parameter is created and its value is not set. #68750.
259 2004-11-26 Sureshkumar T <tsureshkumar@novell.com>
261 * OdbcParameter.cs: Fixed Parameter Size property as well as
262 insufficient buffer errors. bug #68749.
264 2004-09-14 Sebastien Pouliot <sebastien@ximian.com>
266 * OdbcPermission.cs: Added internal constructor accepting an Odbc
267 PermissionAttribute parameter (using base class protected ctor).
268 * OdbcPermissionAttribute.cs: Copy now use the new OdbcPermission
271 2004-09-13 Sebastien Pouliot <sebastien@ximian.com>
273 * OdbcPermission.cs: Mostly completed (needs tests).
274 * OdbcPermissionAttribute.cs: Completed.
276 2004-08-31 Umadevi S (sumadevi@novell.com)
277 * OdbcDataReader.cs - Fixed Decimal parsing
279 2004-08-30 Umadevi S (sumadevi@novell.com)
280 * OdbcType.cs - removed inheritance from short.
282 2004-08-27 Sureshkumar T (tsureshkumar@novell.com)
283 * OdbcDataReader.cs - fixed bug #63539 - TINYINT ODBC datatype is converted into System.Byte
285 2004-08-26 Sureshkumar T (tsureshkumar@novell.com)
286 * OdbcDataReader.cs - Date & DateTime GetValue fixed.
287 GetBytes ordinal parameter passing fixed for BINARY in GetValue.
289 2004-08-20 Sureshkumar T (tsureshkumar@novell.com)
290 * OdbcConnection.cs - correct handles are passed to OdbcError exception to trap the correct error
292 2004-08-04 Umadevi S (sumadevi@novell.com)
293 * OdbcDataReader.cs - Fixed bug 61832 - Column names were not filled, due to which name based lookup of columns failed.
296 2004-08-04 Umadevi S (sumadevi@novell.com)
297 * OdbcDataReader.cs - Fixed bug 61405 - Handling smallint column type.
299 2004-07-30 Sureshkumar T (tsureshkumar@novell.com)
300 * OdbcCommand.cs: ExecuteNonQuery Closed statement handle to fix memory leak
301 * OdbcDataReader.cs: Closed statement handle to fix memory leak
302 Removed SQLState login in GetBytes coz OdbcError provides the same.
304 2004-07-29 Umadevi S (sumadevi@novell.com)
305 * OdbcCommand.cs - Fixed bug 62046. ExecuteNonQuery implemented correctly
308 2004-07-28 Umadevi S (sumadevi@novell.com)
309 * OdbcParameter.cs - fixed bug 61968. String values passed with quotes
312 2004-07-07 Umadevi S (sumadevi@novell.com)
313 * OdbcConnection.cs - Allowed Close to be called multiple times
314 - Implementation of Dispose method
316 2004-07-07 Umadevi S (sumadevi@novell.com)
317 * OdbcCommand.cs : fixed set method for Transaction
319 2004-07-01 Sureshkumar T (tsureshkumar@novell.com)
320 * OdbcCommand.cs : fixed reader problem with ExecuteScalar
322 2004-06-23 Sureshkumar T (tsureshkumar@novell.com)
323 * OdbcConnection.cs: Fix: Moved env allocation to Open method.
324 Disconnection & freeing handles are done in Close
325 method to avoid simultaneous connections.
326 * libodbc.cs : Added constants for odbc version.
328 2004-06-16 Gert Driesen <drieseng@users.sourceforge.net>
330 * OdbcError.cs: fixed serialization compatibility with MS.NET
331 * OdbcErrorCollection.cs: fixed serialization compatibility with
333 * OdbcException.cs: fixed serialization compatibility with MS.NET
335 2004-06-16 Sureshkumar T (tsureshkumar@novell.com)
336 * OdbcDataReader.cs: Added GetValue support for Sql Binary type to return byte array.
337 Implemented GetBytes method.
338 * libodbc.cs : Added enums, constants & imports for above fix.
340 2004-06-13 Gert Driesen <drieseng@users.sourceforge.net>
342 * OdbcDataReader.cs: changed GetData method to return IDataReader
345 2004-06-09 Sureshkumar T (tsureshkumar@novell.com)
346 * OdbcDataReader.cs: Removed checking of currentRow in GetName
349 2004-06-04 Gert Driesen <drieseng@users.sourceforge.net>
351 * OdbcPermission.cs: moved Obsolete attribute to correct
354 2004-06-02 Sureshkumar T (tsureshkumar@novell.com)
356 * OdbcDataReader.cs: Implemented GetByte method. Fixed bug #58820
358 2004-06-02 Gert Driesen <drieseng@users.sourceforge.net>
360 * OdbcParameter.cs: added missing attributes
361 * OdbcPermission.cs: added missing attributes
362 * OdbcConnection.cs: fixes attribute, added missing attributes
363 * OdbcInfoMessageEventArgs.cs: removed extra properties, fixed
364 API compatibility with MS.NET
365 * OdbcCommandBuilder.cs: use correct attributes
367 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net)
369 * OdbcPermissionAttribute.cs: change AllowMultiple and
370 Inherited to match .NET
372 2004-05-17 Umadevi S (sumadevi@novell.com)
373 * OdbcPermissionAttribute, OdbcPermission.cs - fixed missing methods
375 2004-05-17 Gert Driesen (drieseng@users.sourceforge.net)
376 * OdbcCategoryAttribute.cs: fixed namespace
377 * OdbcDataAdapter.cs: removed extra attributes
378 * OdbcDescriptionAttribute.cs: fixed namespace
380 2004-05-14 Umadevi S (sumadevi@novell.com)
381 * OdbcParameterConverter.cs -Added
382 * OdbcParameter.cs - Added some attributes
384 2004-05-14 Umadevi S (sumadevi@novell.com)
385 * OdbcDataAdapter.cs - Added Attributes
387 2004-05-14 Umadevi S (sumadevi@novell.com)
388 * OdbcConnection.cs - Added Attributes
390 2004-05-14 Umadevi S (sumadevi@novell.com)
391 * OdbcCommand.cs - Added Attributes
393 2004-05-14 Umadevi S (sumadevi@novell.com)
394 * OdbcDataReader.cs - Added Attributes
396 2004-05-14 Umadevi S (sumadevi@novell.com)
397 * Added Classes OdbcCategoryAttribute.cs, OdbcDescriptionAttribute.cs
399 2004-05-14 Umadevi S (sumadevi@novell.com)
400 * Added Class OdbcCommandBuilder.cs
402 2004-05-14 Umadevi S (sumadevi@novell.com)
403 * Added classes OdbcInfoMessageEventArgs.cs - with stubs
404 * Added classes OdbcInfoMessageEventInfo.cs
406 2004-05-14 Umadevi S (sumadevi@novell.com)
407 * Added classes OdbcPermission.cs, OdbcPermissionAttribute.cs - with stubs
409 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
410 * OdbcException.cs : removed ErrorCode property, fixing signature
411 * OdbcErrorCollection.cs : added internal ctor, reduced
412 accessibility of Add method to internal
413 * OdbcCommand.cs: marked hstmt field private, remove setters for
415 * OdbcDataReader.cs: Added GetDate method, renamed GetTimeSpan to
416 GetTime to match MS.NET, added HasRows stub
418 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
420 * OdbcErrorCollection.cs:
421 * OdbcException.cs: fixed linefeeds to DOS to match other
422 sources in System.Data.Odbc
424 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
425 * OdbcCommand.cs: No longer use OdbcConnection.Datareader, in order
426 to fix signature of OdbcConnection
427 * OdbcDataReader.cs: No longer use ODbcConnection.Datareader, in
428 order to fix signature of OdbcConnection
429 * OdbcConnection.cs: Signature fixes: removed DataReader property,
430 added setter for ConnectionTimeout, made transaction internal
431 * OdbcParameter.cs: reduced accessibility of Bind method to
432 internal, added setter for IsNullable
433 * OdbcParameterCollection.cs: made default ctor and Bind method
436 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
437 * OdbcCommand.cs: fixed linefeeds to DOS to match other sources
440 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
441 * OdbcTransaction.cs: fixed signature to match MS.NET
443 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
444 * OdbcType.cs: fixed typo UniqueIndetifier
445 * OdbcColumn.cs : fixed typo UniqueIndetifier
447 2004-05-09 Gert Driesen (drieseng@users.sourceforge.net)
448 * OdbcType.cs: fixed linefeeds to DOS to match other sources
451 2003-12-01 Gonzalo Paniagua Javier <gonzalo@ximian.com>
453 * OdbcTransaction.cs: applied patch from Jeff Seifert that makes
454 this class implement IDbTransaction interface.
456 2002-11-01 Daniel Morgan <danmorg@sc.rr.com>
458 * OdbcDataReader.cs: - uncommented code, but I put a FIXME:
459 according to Brian, this does not work on MS .NET however, we need it
460 for Mono for now. schemaRow.AcceptChanges(),
461 - implement IEnumerable.GetEnumerator()
463 * libodbc.cs: changed the DllImport from "odbc32.dll" to "odbc32"
465 2002-10-21 Gonzalo Paniagua Javier <gonzalo@ximian.com>
469 * OdbcException.cs: added dummy implementation for these missing