ok.. here's the code in two different ways:
Both return System.Byte[] instead of the string I'd expect. It works with
all other types except BLOBs..
dbConn = new
OdbcConnection("Driver={MySQL};Server=localhost;option=16834;Database=xxx;Ui
d=xxx;Pwd=xxx;");
OdbcDataReader drComment;
OdbcCommand cComment = new OdbcCommand("SELECT comment FROM matchcomment
WHERE id="+Request.QueryString["id"],dbConn);
dbConn.Open();
drComment = cComment.ExecuteReader();
while(drComment.Read())
{
TextBoxContent.Text = drComment["comment"].ToString();
}
drComment.Close();
dbConn.Close();
-------------------------------
And here's another way I tried..
OdbcDataAdapter daComment = new OdbcDataAdapter("SELECT comment FROM
matchcomment WHERE id="+Request.QueryString["id"],dbConn);
DataSet dsComment = new DataSet();
daComment.Fill(dsComment,"comment");
"laled" <laled@nospam.microsoft.com> wrote in message
news:c41601c25476$516123f0$35ef2ecf@TKMSFTNGXA11...
> You should be able to read large text fields without any
> problems. Perhaps if you post a snippet of code showing
> exactly how you are trying to read them, we might be able
> to point out your problem.
>
> laled
>
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
>
>
> >-----Original Message-----
> >This is in fact terrible. As it has stalled me
> completely.. :o\
> >
> >I've tried both OdbcDataAdapter and OdbcDataReader.
> Every other type can be
> >read except BLOBs.. Is that really too much to ask? ;o)
> >
> >What I want is just to be able to have text fields
> longer than 255 chars..
> >There really must be a way to fix this problem or
> ODBC.NET would be
> >completely useless.. :o\
> >
> >And I have to use ODBC.NET with MySQL so the solution
> can't be changing
> >those..
> >
> >Hope someone can help here.. ;) (oh and I don't wan't
> to split the text up
> >in a lot of VARCHAR(255)s...lol)
> >
> >
> >
> >.
> >