freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] FW: [Rlib-users] FW: Strange problem with data corruption

From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FW: [Rlib-users] FW: Strange problem with data corruption
Date: Fri, 06 Jan 2006 08:50:46 +0100

Il giorno gio, 05/01/2006 alle 18.19 -0500, Brian Morton ha scritto:
> Does FreeTDS support cursor scrolling?
>
> -----Original Message-----
> From: Bob Doan [mailto:bdoan AT sicom.com]
> Sent: Thursday, January 05, 2006 4:39 PM
> To: Brian Morton
> Subject: RE: [Rlib-users] FW: Strange problem with data corruption
>
> Ok Brian,
>
> I'm getting somewhere
>
> It looks like freetds might not support cursor scrolling.
>
> Can you confirm this?
>
> I could do something to work around the cursor scrolling by building a
> cursor in memory then navigating it that way.
>
> - Bob
>
> On Thu, 2006-01-05 at 15:54 -0500, Brian Morton wrote:
> > majorpacketloss:/var/www/apache2-default/rlib# php odbc.php
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: SQLSTATE: HY106
> > BRIAN: SQLCODE: 0
> > BRIAN: [FreeTDS][SQL Server]Fetch type out of range
> > BRIAN: rlib_odbc_first:: FALSE
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: SQLSTATE: HY106
> > BRIAN: SQLCODE: 0
> > BRIAN: [FreeTDS][SQL Server]Fetch type out of range
> > BRIAN: rlib_odbc_first:: FALSE
> > BRIAN: rlib_odbc_resolve_field_pointer:: [Users_Id] TO
> > [Rn_Descriptor]
> > BRIAN: rlib_odbc_resolve_field_pointer:: [Login_Name] TO
> > [Rn_Descriptor]
> > BRIAN: rlib_odbc_resolve_field_pointer:: [Rn_Descriptor] TO
> > [Rn_Descriptor]
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: SQLSTATE: HY106
> > BRIAN: SQLCODE: 0
> > BRIAN: [FreeTDS][SQL Server]Fetch type out of range
> > BRIAN: rlib_odbc_first:: FALSE
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: SQLSTATE: HY106
> > BRIAN: SQLCODE: 0
> > BRIAN: [FreeTDS][SQL Server]Fetch type out of range
> > BRIAN: rlib_odbc_first:: FALSE
> > <head>

The "Fetch type out of range" error is the way ODBC driver tells you
that do not support cursor scrollings.
No, not supported and not planned. However garbage characters are
related to bad ODBC client that do not handle errors/warnings correctly.

freddy77

[freetds] FW: [Rlib-users] FW: Strange problem with data corruption, Brian Morton, 01/05/2006
- Re: [freetds] FW: [Rlib-users] FW: Strange problem with data corruption, Frediano Ziglio, 01/06/2006