Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error Cause?

Re: Error Cause?

From: Matt Smith <m.smith_at_secureinteractive.com>
Date: Mon, 5 Mar 2001 11:46:11 +1000
Message-ID: <97unat$lu1$1@thebe.syd.dav.net.au>

This happens when you try to insert too much text into a field. Eg: if you try to insert 55 characters of text into a varcher(50) field.

<s m> wrote in message news:97dq23023bn_at_news1.newsguy.com...
>
> Can someone give me some insight as to the cause of this error? I'm using
 a
> DSN that doesn't actually have a physical database. The code snippet will
> work with, for example, a DSN pointing to a ms access db.
>
> This is my code:
>
> set conn = server.createobject("ADODB.Connection")
> conn.Open "someDSN"
> Set rs = conn.Execute(stmt)
>
> ' -- Display information'
> Do While Not rs.EOF
> rs.Fields(0).Value
> rs.Fields(1).Value
> rs.Fields(2).Value
> rs.Fields(3).Value
> rs.Fields(4).Value
> rs.MoveNext
> Loop
>
> ' -- Undefine data'
> rs.Close
> Set rs = Nothing
> conn.Close
> Set conn = Nothing
>
> This is the error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x8000FFFF)
> [Microsoft][ODBC Driver Manager] Data truncated
>
>
> ==================================
> Posted via http://nodevice.com
> Linux Programmer's Site
Received on Sun Mar 04 2001 - 19:46:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US