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

[lunkwill at gmx.net]

Thanx Suresh,

I have copied the two changed files (OdbcParameter.cs and
OdbcTypeConverter.cs) into the 1.1.8.2 source tree and recompiled.
Still I get no database results but at least the exceptions have vanished.
I'll do some more testing today and keep you up to date.

Maybe I should download and recompile the whole System.Data tree?

I'm not sure if the problem is in the ODBC provider as MS .NET-ODBC uses the
same provider and it works as expected. But I'm not too familiar with ODBC
so that is just a guess.

/daniel

> lunkwill at gmx.net wrote:
> > 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