[Mono-list] ODBC.NET Data Provider Update

Brian Ritchie brianlritchie@hotmail.com
Sun, 20 Oct 2002 15:33:55 -0400

Work progresses on tricking out the ODBC provider...it isn't production 
ready yet, but then what is :)

The provider is definitely in a quite usuable state.  I've been performing 
basic testing on Linux (Debian w/ DB2) and Windows (WinXP w/ SQL Server & 
Excel db drivers).  The mono config file has been updated to handle 
auto-switching of odbc32.dll vs. libodbc.so based on platform.

The following changes have been commited to CVS:
- Fixed TinyInt mapping (Thanks Daniel for finding the bug!)
- Parameter support for all data types (could use further optimization)
- Implemented full error handling support: OdbcException, OdbcError, 
OdbcErrorCollection.  This includes getting the full error message text back 
from the ODBC driver.
- Transaction Isolation Level is supported
- ExecuteScalar is supported
- Support CloseConnection CommandBehavior for ExecuteReader

Known Issues:
- A number of data types are returned as strings instead of native types
- Following command behaviors aren't supported: KeyInfo, SchemaOnly, 
- DataAdapter & CommandBuilder still not supported

Thanks to all who have been road testing the provider (especially Daniel 


Unlimited Internet access -- and 2 months free!  Try MSN.