[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Problem with ODBC to Lotus Notes database

(John Vannoy)

9/18/2002 1:25:00 PM

I am using ODBC.Net to connect to a Lotus Notes r5 database.
Everything works great, except one minor detail - it truncates text
fields to 200 bytes! This is a major hold up, as some fields contain
up to 900 bytes.

I am using the Notes 3.01 ODBC driver. I have created a DSN and set
the "max length of text fields" property to 1500. I also set the "max
length of rich text fields" to 1500.

If I connect thru this same DSN using VB6 and ADO, I experience no
truncation.

Why would it truncate text fields to 200 bytes? How can I get around
this?

Thanks,
John
4 Answers

Richard Hill

8/30/2002 2:53:00 PM

0

I am experiencing the same problem. Like you, I have an
older app (asp/ado) that works with no problem.

I tried setting the MaxVarcharLen in a DSNless connection,
but this did not work.

I'll post on a couple of other newsgroups today and share
anything I find with you.

Regards,
Richard


>-----Original Message-----
>I am using ODBC.Net to connect to a Lotus Notes r5
database.
>Everything works great, except one minor detail - it
truncates text
>fields to 200 bytes! This is a major hold up, as some
fields contain
>up to 900 bytes.
>
>I am using the Notes 3.01 ODBC driver. I have created a
DSN and set
>the "max length of text fields" property to 1500. I also
set the "max
>length of rich text fields" to 1500.
>
>If I connect thru this same DSN using VB6 and ADO, I
experience no
>truncation.
>
>Why would it truncate text fields to 200 bytes? How can
I get around
>this?
>
>Thanks,
>John
>.
>

(John Vannoy)

8/31/2002 9:28:00 PM

0

OK, great. If you figure it out, let me know! Thanks!


"Richard" <richard.hill@sonoco.com> wrote in message
news:a4d401c25024$4d6d5210$a5e62ecf@tkmsftngxa07...
> I am experiencing the same problem. Like you, I have an
> older app (asp/ado) that works with no problem.
>
> I tried setting the MaxVarcharLen in a DSNless connection,
> but this did not work.
>
> I'll post on a couple of other newsgroups today and share
> anything I find with you.
>
> Regards,
> Richard
>
>
> >-----Original Message-----
> >I am using ODBC.Net to connect to a Lotus Notes r5
> database.
> >Everything works great, except one minor detail - it
> truncates text
> >fields to 200 bytes! This is a major hold up, as some
> fields contain
> >up to 900 bytes.
> >
> >I am using the Notes 3.01 ODBC driver. I have created a
> DSN and set
> >the "max length of text fields" property to 1500. I also
> set the "max
> >length of rich text fields" to 1500.
> >
> >If I connect thru this same DSN using VB6 and ADO, I
> experience no
> >truncation.
> >
> >Why would it truncate text fields to 200 bytes? How can
> I get around
> >this?
> >
> >Thanks,
> >John
> >.
> >

(sarah aldridge)

9/20/2002 10:22:00 AM

0

Hi,

I too have exactly the same problem as you. Did you manage to find a solution.

Sarah

(John Vannoy)

12/25/2002 8:50:00 PM

0

Sarah,
No solution yet. I figure it's a bug in ODBC.NET. Workaround is to
write a VB6 COM component, access the data via ADO 2.7, and pass back
a 2D array to your VB.net code. Hey, it works, and it encapsulates
the workaround code. When ODBC.NET eventually is fixed, it will be
easy to drop in.

John

saldridge@protocol.co.uk (sarah aldridge) wrote in message news:<f8989ffd.0209190339.72df0909@posting.google.com>...
> Hi,
>
> I too have exactly the same problem as you. Did you manage to find a solution.
>
> Sarah