Re: [Mono-list] Still problems with database access using ODBC

lunkwill at lunkwill at
Mon Jul 11 07:28:17 EDT 2005

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
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

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
in <0x00011> System.Data.Odbc.OdbcCommand:ExecuteReader (CommandBehavior
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,


> > Hi all!
> > 
> > Nearly 2 months ago I posted a bug (
> > ) 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:

More information about the Mono-list mailing list