Re: Error Cause?

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