rlib-devel

RE: [Rlib-devel] RLIB-1.3.2 questions, problems and an ODBC fix

[Derek G. <dgi...@ge...>]

Would the ODBC fix possibly address an issue my colleague and I have
observed where obtaining a column of data from a small table in MySQL via
ODBC was displaying a resultset with the first three rows of data missing
and the last three rows of data repeat the last row of data in the table? I
haven't used the patch yet, but I haven't had enough time to delve into this
particular issue with ODBC along with overcoming the lack of SQLRowCount
from Oracle.

e.g. column in table:

DATUM1
DATUM2
DATUM3
DATUM4
DATUM5
DATUM6
DATUM7
DATUM8

output from query:

DATUM4
DATUM5
DATUM6
DATUM7
DATUM8
DATUM8
DATUM8
DATUM8

Cheers,
--Derek Giromini

RE: [Rlib-devel] RLIB-1.3.2 questions, problems and an ODBC fix

[Bob D. <bd...@si...>]

I suspect so.  For sure the part about the last 3 rows.  

Can you try Zontan's first patch which only addresses the ODBC part and
let me know how it works?

I suspect writing an ODBC connector which doesn't need the row count
won't be that hard.  I just don't have anything to test it with (I don't
have oracle here)  



- bob

On Wed, 2005-04-13 at 07:35 -0500, Derek Giromini wrote:
> Would the ODBC fix possibly address an issue my colleague and I have
> observed where obtaining a column of data from a small table in MySQL via
> ODBC was displaying a resultset with the first three rows of data missing
> and the last three rows of data repeat the last row of data in the table? I
> haven't used the patch yet, but I haven't had enough time to delve into this
> particular issue with ODBC along with overcoming the lack of SQLRowCount
> from Oracle.
> 
> e.g. column in table:
> 
> DATUM1
> DATUM2
> DATUM3
> DATUM4
> DATUM5
> DATUM6
> DATUM7
> DATUM8
> 
> output from query:
> 
> DATUM4
> DATUM5
> DATUM6
> DATUM7
> DATUM8
> DATUM8
> DATUM8
> DATUM8
> 
> Cheers,
> --Derek Giromini
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Rlib-devel mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-devel

Re: [Rlib-devel] RLIB-1.3.2 questions, problems and an ODBC fix

[Zoltan B. <zb...@du...>]

Derek Giromini =C3=ADrta:
> Would the ODBC fix possibly address an issue my colleague and I have
> observed where obtaining a column of data from a small table in MySQL v=
ia
> ODBC was displaying a resultset with the first three rows of data missi=
ng
> and the last three rows of data repeat the last row of data in the tabl=
e? I
> haven't used the patch yet, but I haven't had enough time to delve into=
 this
> particular issue with ODBC along with overcoming the lack of SQLRowCoun=
t
> from Oracle.
>=20
> e.g. column in table:
>=20
> DATUM1
> DATUM2
> DATUM3
> DATUM4
> DATUM5
> DATUM6
> DATUM7
> DATUM8
>=20
> output from query:
>=20
> DATUM4
> DATUM5
> DATUM6
> DATUM7
> DATUM8
> DATUM8
> DATUM8
> DATUM8
>=20
> Cheers,
> --Derek Giromini

Exactly that was my problem. The patch fixes it.

Best regards,
Zolt=C3=A1n B=C3=B6sz=C3=B6rm=C3=A9nyi