Hi Suresh! thanx for the quick help. But I'm afraid it won't help. I now compiled the Mono snapshot from 2005-07-08 from scratch and tested again. As a result I get no exceptions but also no results when accessing firebird SQL. When using Informix (my production db) I now get the following exception:
Unhandled Exception: System.Data.Odbc.OdbcException: [unixODBC][Informix][Informix ODBC Driver]String data right truncation. in <0x00131> System.Data.Odbc.OdbcCommand:ExecSQL (System.String sql) in <0x00073> System.Data.Odbc.OdbcCommand:ExecuteNonQuery (Boolean freeHandle) in <0x00011> System.Data.Odbc.OdbcCommand:ExecuteReader (CommandBehavior behavior) in <0x0000c> System.Data.Odbc.OdbcCommand:ExecuteReader () in (wrapper remoting-invoke-with-check) System.Data.Odbc.OdbcCommand:ExecuteReader () in <0x002a6> MainClass:Main (System.String[] args) Meanwhile I crosschecked with Python/ODBC from my SLES9 to ensure that the Informix ODBC driver is capable of SqlParameter at all. Still nobody else with problems like this? Best regards, /daniel > > Hi all! > > > > Nearly 2 months ago I posted a bug ( > > http://bugzilla.ximian.com/show_bug.cgi?id=74917 ) about using SQL > > parameters in ODBC queries. > > In short: using OdbcParameter with int-parameters works; with char and > > varchar-parameters it fails > > i've just did a work-around fix. hope that helps you. I've been using > WCHAR & WVARCHAR and it seems it is not fully supported from odbc > provider. It is working with sqlserver odbc tds driver, which I tested > now. > > suresh. > -- Weitersagen: GMX DSL-Flatrates mit Tempo-Garantie! Ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
