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

[lunkwill at gmx.net]

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