Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Morton <bmorton AT secureworks.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] FW: [Rlib-users] FW: Strange problem with data corruption
  • Date: Thu, 5 Jan 2006 18:19:54 -0500

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>
> <style type="text/css">
> pre { margin:0; padding:0; margin-top:0; margin-bottom:0;} DIV {
> position: absolute; left: 0; } TABLE { border: 0; cellspacing: 0;
> cellpadding: 0; width: 100%; } </style> </head> <body>
> <table><tr><td><pre><DIV><img src="logo.jpg" width="50.000000"
> height="50.000000"></DIV>
> <font size="3"> </font><font size="3">REPORT HEADER........</font>
>
>
>
> <table><tr><td height="4"
> bgcolor="#ffffff"></td></tr></table><table><tr><td
> height="2" bgcolor="#000000"></td></tr></table><table><tr><td height="4"
> bgcolor="#ffffff"></td></tr></table><font size="3">Page Header
> (Example Report)</font> <table><tr><td height="4"
> bgcolor="#ffffff"></td></tr></table><table><tr><td
> width="100%" valign="top"><pre></td></tr></table>Page: 1
> </pre></td></tr></table></td></tr></table>
>
> -----Original Message-----
> From: Bob Doan [mailto:bdoan AT sicom.com]
> Sent: Thursday, January 05, 2006 3:51 PM
> To: Brian Morton
> Subject: RE: [Rlib-users] FW: Strange problem with data corruption
>
> More trace to find out why ODBC thinks are are not any rows
>
> - bob
>
> On Thu, 2006-01-05 at 15:36 -0500, Brian Morton wrote:
> > majorpacketloss:/var/www/apache2-default/rlib# php odbc.php
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first:: FALSE
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > 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: rlib_odbc_first:: FALSE
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first::
> > BRIAN: rlib_odbc_first:: FALSE
> > <head>
> > <style type="text/css">
> > pre { margin:0; padding:0; margin-top:0; margin-bottom:0;} DIV {
> > position: absolute; left: 0; } TABLE { border: 0; cellspacing: 0;
> > cellpadding: 0; width: 100%; } </style> </head> <body>
> > <table><tr><td><pre><DIV><img src="logo.jpg" width="50.000000"
> > height="50.000000"></DIV>
> > <font size="3"> </font><font size="3">REPORT
HEADER........</font>
> >
> >
> >
> > <table><tr><td height="4"
> > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > height="2" bgcolor="#000000"></td></tr></table><table><tr><td height="4"
> > bgcolor="#ffffff"></td></tr></table><font size="3">Page Header
> > (Example Report)</font> <table><tr><td height="4"
> > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > width="100%" valign="top"><pre></td></tr></table>Page: 1
> > </pre></td></tr></table></td></tr></table>
> >
> > -----Original Message-----
> > From: Bob Doan [mailto:bdoan AT sicom.com]
> > Sent: Thursday, January 05, 2006 3:33 PM
> > To: Brian Morton
> > Subject: RE: [Rlib-users] FW: Strange problem with data corruption
> >
> > Hi
> >
> > More Trace
> >
> >
> > On Thu, 2006-01-05 at 15:14 -0500, Brian Morton wrote:
> > > Here is the output. What does this mean?
> > >
> > > majorpacketloss:/var/www/apache2-default/rlib# php odbc.php
> > > BRIAN: rlib_odbc_first::
> > > BRIAN: rlib_odbc_first::
> > > BRIAN: rlib_odbc_resolve_field_pointer:: [rn_descriptor] TO
> > > [rn_descriptor]
> > > BRIAN: rlib_odbc_first::
> > > BRIAN: rlib_odbc_first::
> > > <head>
> > > <style type="text/css">
> > > pre { margin:0; padding:0; margin-top:0; margin-bottom:0;} DIV {
> > > position: absolute; left: 0; } TABLE { border: 0; cellspacing: 0;
> > > cellpadding: 0; width: 100%; } </style> </head> <body>
> > > <table><tr><td><pre><DIV><img src="logo.jpg" width="50.000000"
> > > height="50.000000"></DIV>
> > > <font size="3"> </font><font size="3">REPORT
> HEADER........</font>
> > >
> > >
> > >
> > > <table><tr><td height="4"
> > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > height="2" bgcolor="#000000"></td></tr></table><table><tr><td
height="4"
> > > bgcolor="#ffffff"></td></tr></table><font size="3">Page Header
> > > (Example Report)</font> <table><tr><td height="4"
> > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > width="100%" valign="top"><pre></td></tr></table>Page: 1
> > > </pre></td></tr></table></td></tr></table>
> > >
> > > -----Original Message-----
> > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > Sent: Thursday, January 05, 2006 3:07 PM
> > > To: Brian Morton
> > > Subject: RE: [Rlib-users] FW: Strange problem with data corruption
> > >
> > > Hi,
> > >
> > > More Traces
> > >
> > > This time please do it with SELECT *
> > >
> > > Thanks!
> > >
> > > Look for "BRIAN"
> > >
> > > - bob
> > >
> > > On Thu, 2006-01-05 at 14:30 -0500, Brian Morton wrote:
> > > > Thanks for the debug help.
> > > >
> > > > The field resolves
> > > >
> > > > majorpacketloss:/var/www/apache2-default/rlib# php odbc.php
> > > > rlib_odbc_resolve_field_pointer:: [rn_descriptor] TO
> > > > [rn_descriptor] <head> <style type="text/css"> pre { margin:0;
> > > > padding:0; margin-top:0; margin-bottom:0;} DIV { position:
> > > > absolute; left: 0; } TABLE { border: 0; cellspacing: 0;
> > > > cellpadding: 0; width: 100%; } </style> </head> <body>
> <table><tr><td><pre><DIV><img src="logo.jpg"
> > > > width="50.000000"
> > > > height="50.000000"></DIV>
> > > > <font size="3"> </font><font size="3">REPORT
> > HEADER........</font>
> > > >
> > > >
> > > >
> > > > <table><tr><td height="4"
> > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > > height="2" bgcolor="#000000"></td></tr></table><table><tr><td
> height="4"
> > > > bgcolor="#ffffff"></td></tr></table><font size="3">Page Header
> > > > (Example Report)</font> <table><tr><td height="4"
> > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > > width="100%" valign="top"><pre></td></tr></table>Page: 1
> > > >
> > > > But nothing from GET VALUES[]. What do you think?
> > > >
> > > > -----Original Message-----
> > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > Sent: Thursday, January 05, 2006 1:50 PM
> > > > To: Brian Morton
> > > > Subject: RE: [Rlib-users] FW: Strange problem with data
> > > > corruption
> > > >
> > > > Brian,
> > > >
> > > > Here is a new odbc.c file. This will output debug data while it
> > > > is doing field resolution. Let me know what you find.
> > > >
> > > > - Bob
> > > >
> > > > On Thu, 2006-01-05 at 12:22 -0500, Brian Morton wrote:
> > > > > No I don't. I did initially, but it kept insisting that my
> > > > > field name was invalid. I was doing a select * from, so I
> > > > > specified the field name in query, and that warning went away,
> > > > > but so did the get
> > values.
> > > > >
> > > > > -----Original Message-----
> > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > Sent: Thursday, January 05, 2006 12:19 PM
> > > > > To: Brian Morton
> > > > > Subject: RE: [Rlib-users] FW: Strange problem with data
> > > > > corruption
> > > > >
> > > > > I don't see any of the debug output we added.
> > > > >
> > > > > Do you see any of it?
> > > > >
> > > > > "GET VALUES"
> > > > >
> > > > > On Wed, 2006-01-04 at 16:56 -0500, Brian Morton wrote:
> > > > > > I wrote a new xml file to make sure it wasn't a problem with
> > > > > > the way I was referencing. I am only referring to one field
> > > > > > in my query, and only referring to that field in my xml to
> > > > > > make it a clean test
> > > case.
> > > > > > Here is my output. No data is output in my report, only the
> > > > > > header and
> > > > > footer.
> > > > > >
> > > > > >
> > > > > > majorpacketloss:/var/www/apache2-default/rlib# php odbc.php
> > > > > > <head> <style type="text/css"> pre { margin:0; padding:0;
> > > > > > margin-top:0; margin-bottom:0;} DIV { position: absolute;
> > > > > > left: 0; }
> > TABLE { border:
> > > > > > 0; cellspacing: 0; cellpadding: 0; width: 100%; } </style>
> > > > > > </head> <body> <table><tr><td><pre><DIV><img src="logo.jpg"
> > width="50.000000"
> > > > > > height="50.000000"></DIV>
> > > > > > <font size="3"> </font><font size="3">REPORT
> > > > HEADER........</font>
> > > > > >
> > > > > >
> > > > > >
> > > > > > <table><tr><td height="4"
> > > > > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > > > > height="2"
> > > > > > bgcolor="#000000"></td></tr></table><table><tr><td
> > > height="4"
> > > > > > bgcolor="#ffffff"></td></tr></table><font size="3">Page
> > > > > > Header (Example Report)</font> <table><tr><td height="4"
> > > > > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > > > > width="100%" valign="top"><pre></td></tr></table>Page: 1
> > > > > > </pre></td></tr></table></td></tr></table>
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > > Sent: Wednesday, January 04, 2006 4:32 PM
> > > > > > To: Brian Morton
> > > > > > Subject: RE: [Rlib-users] FW: Strange problem with data
> > > > > > corruption
> > > > > >
> > > > > > What you are supposed to be seeing are the field values in
> > > > > > your result
> > > > > set.
> > > > > > You should see a GET VALUE for each line/field you request.
> > > > > > What do you see?
> > > > > >
> > > > > > On Wed, 2006-01-04 at 16:27 -0500, Brian Morton wrote:
> > > > > > > My GET VALUE [] array looks like it is empty. It is
> > > > > > > possible that I'm just doing something totally wrong.
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > > > Sent: Wednesday, January 04, 2006 4:26 PM
> > > > > > > To: Brian Morton
> > > > > > > Subject: RE: [Rlib-users] FW: Strange problem with data
> > > > > > > corruption
> > > > > > >
> > > > > > > DO you see any GET VALUES's with readable chars or is it
> > > > > > > all
> > > garbage?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On Wed, 2006-01-04 at 15:12 -0500, Brian Morton wrote:
> > > > > > > > Didn't know that CLI operated that way, I've only used
> > > > > > > > the apache mod before. Here is my new output.
> > > > > > > >
> > > > > > > > brian@majorpacketloss:/var/www/apache2-default/rlib$ php
> > > > > > > > odbc.php The field [test1] does not exist Unrecognized
> operand:
> > > > > > > > [test1] Error on Line 50: The Expression Was [test1] The
> > > > > > > > field [test2] does not exist Unrecognized operand:
> > > > > > > > [test2] Error on Line 52: The Expression Was [test2] The
> > > > > > > > field [constitution] does not exist Unrecognized
> > > > > > operand:
> > > > > > > > [constitution] Error on Line 52: The Expression Was
> > > > > > > > [val(constitution)==1] The field [constitution] does not
> > > > > > > > exist Unrecognized operand: [constitution] Error on Line 52:
> > > > > > > > The Expression Was [val(constitution)==2] The field
> > > > > > > > [longline] does not exist Unrecognized operand:
> > > > > > > > [longline] Error on Line 54: The Expression Was
> > > > > > > > [longline] The field [constitution] does not exist
> > > > > > > > Unrecognized
> > > > > > > > operand: [constitution] Error on Line 54: The Expression
> > > > > > > > Was [val(constitution)==1] The field [constitution] does
> > > > > > > > not exist Unrecognized operand: [constitution] Error on
> > > > > > > > Line
> 54:
> > > > > > > > The Expression Was [val(constitution)==2] The field
> > > > > > > > [longline] does not exist Unrecognized operand:
> > > > > > > > [longline] Error on Line 57: The Expression Was
> > > > > > > > [longline] GET VALUE [] <head> <style type="text/css">
> > > > > > > > pre { margin:0; padding:0; margin-top:0; margin-bottom:0;}
DIV { position:
> > > > > > > > absolute;
> > > > > > > > left: 0; } TABLE { border: 0; cellspacing: 0; cellpadding:
> > > > > > > > 0;
> > > width:
> > > >
> > > > > > > > 100%; } </style> </head> <body>
> > > > > > > > <table><tr><td><pre><font size="3">02.000 </font><font
> > > > > size="3">Test
> > > > > > > > Report (Normal) AND THE REPORT FORMAT IS: </font><font
> > > > > > > > size="3"> </font> <table><tr><td height="4"
> > > > > > > > bgcolor="#ffffff"></td></tr></table><table><tr><td
> > > > > > > > width="100%" valign="top"><pre><font size="3">NO DATA</font>
> > > > > > > > </td></tr></table>Page: 1
> > > > > > > >
> > > > > > > > No printed characters are visible on this line in the
> > > > > > > > output
> > > > > > > >
> > > > > > > > <font size="3">Test Report (Normal) AND THE REPORT FORMAT
IS:
> > > > > > > > [[CORRUPTED CHARS]]</font>
> > > > > > > >
> > > > > > > > But in the web output version there are corrupted
> > > > > > > > characters at that point ([[CORRUPTED CHARS]])
> > > > > > > >
> > > > > > > > Does that make sense?
> > > > > > > > -----Original Message-----
> > > > > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > > > > Sent: Wednesday, January 04, 2006 3:00 PM
> > > > > > > > To: Brian Morton
> > > > > > > > Subject: RE: [Rlib-users] FW: Strange problem with data
> > > > > > > > corruption
> > > > > > > >
> > > > > > > > are you in the /var/www/apache2-default/rlib directory
> > > > > > > > when you run
> > > > > it?
> > > > > > > >
> > > > > > > >
> > > > > > > > On Wed, 2006-01-04 at 13:48 -0500, Brian Morton wrote:
> > > > > > > > > File is clearly there along with the rest of them and
> > > > > > > > > is referenced properly in the php file. I assume
> > > > > > > > > standard relative paths apply (I don't need to specify
> > > > > > > > > the absolute path, do I?)
> > > > > > > > >
> > > > > > > > > ls /var/www/apache2-default/rlib
> > > > > > > > > array2.xml expressions.php flow_part.xml green.jpg
> > > > labels.php
> > > > > > > > > multiline.php red.jpg
> > > > > > > > > array.php expressions.xml follower.php hungary.php
> > > > labels.xml
> > > > > > > > > multiline.xml xml.php
> > > > > > > > > array.xml fixed_part.php follower.xml hungary.xml
> > > Makefile
> > > > > > > > > odbc.php yellow.jpg
> > > > > > > > > data.xml fixed_part.xml graph.php images.php
> > > > > Makefile.am
> > > > > > > > > pages_across.php
> > > > > > > > > example.php flow_part.php graph.xml images.xml
> > > > > Makefile.in
> > > > > > > > > pages_across.xml
> > > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > > > > > Sent: Wednesday, January 04, 2006 1:41 PM
> > > > > > > > > To: Brian Morton
> > > > > > > > > Subject: RE: [Rlib-users] FW: Strange problem with
> > > > > > > > > data corruption
> > > > > > > > >
> > > > > > > > > Seems you are not in the right directory when you are
> > > > > > > > > running
> > > it.
> > > >
> > > > > > > > > It's saying it can't find the file multiline.xml
> > > > > > > > >
> > > > > > > > > - bob
> > > > > > > > >
> > > > > > > > > On Wed, 2006-01-04 at 10:02 -0500, Brian Morton wrote:
> > > > > > > > > > It was giving me this output before the patch and
> > > > > > > > > > recompilation as well. Am I missing an xml
> > > > > > > > > > extension in my cli
> > > > > php.ini?
> > > > > > > > > >
> > > > > > > > > > php /var/www/apache2-default/rlib/odbc.php
> > > > > > > > > > Warning: I/O warning : failed to load external
> > > > > > > > > > entity
> > > > > > "multiline.xml"
> > > > > > > > > > in /var/www/apache2-default/rlib/odbc.php on line 8
> > > > > > > > > > xmlParseError Failed to load a report file
> > > > > > > > > > [multiline.xml] Content type code unknown
> > > > > > > > > > Warning: Cannot modify header information - headers
> > > > > > > > > > already sent by (output started at
> > > > > > > > > > /var/www/apache2-default/rlib/odbc.php:8)
> > > > > > > > > > in /var/www/apache2-default/rlib/odbc.php on line 9
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > _____
> > > > > > > > > >
> > > > > > > > > > From: Bob Doan [mailto:bdoan AT sicom.com]
> > > > > > > > > > Sent: Tue 1/3/2006 5:04 PM
> > > > > > > > > > To: Brian Morton
> > > > > > > > > > Subject: RE: [Rlib-users] FW: Strange problem with
> > > > > > > > > > data corruption
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > cd rlib/inputs/odbc
> > > > > > > > > > patch -p0 < /where/you/put/the/patch/odbc.patch
> > > > > > > > > >
> > > > > > > > > > make
> > > > > > > > > > make install
> > > > > > > > > >
> > > > > > > > > > test
> > > > > > > > > >
> > > > > > > > > > thanks!
> > > > > > > > > >
> > > > > > > > > > - bob
> > > > > > > > > >
> > > > > > > > > > On Tue, 2006-01-03 at 16:20 -0500, Brian Morton wrote:
> > > > > > > > > > > Certainly. Forgive my ignorance, but how do I
> > > > > > > > > > > apply this
> > > > patch?
> > > > >
> > > > > > > > > > > I have little experience at c programming.
> > > > > > > > > > >
> > > > > > > > > > > _____
> > > > > > > > > > >
> > > > > > > > > > > From: Bob Doan [mailto:bdoan AT sicom.com
> > > > > > > > > > > <mailto:bdoan AT sicom.com> ]
> > > > > > > > > > > Sent: Tue 1/3/2006 4:17 PM
> > > > > > > > > > > To: Brian Morton
> > > > > > > > > > > Cc: rlib-users AT lists.sourceforge.net
> > > > > > > > > > > Subject: Re: [Rlib-users] FW: Strange problem with
> > > > > > > > > > > data corruption
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Hi Brian,
> > > > > > > > > > >
> > > > > > > > > > > Can you try this patch and run the script from the
> > > > > > > > > > > CLI and tell me what output you get.
> > > > > > > > > > >
> > > > > > > > > > > - Bob
> > > > > > > > > > >
> > > > > > > > > > > On Tue, 2006-01-03 at 12:14 -0500, Brian Morton wrote:

> > > > > > > > > > > > I am using RLib as a php extension on a linux
> > > > > > > > > > > > system. I am connecting
> > > > > > > > > > to
> > > > > > > > > > > an
> > > > > > > > > > > > mssql datasource via odbc with the freetds odbc
> driver.
> >
> > > > > > > > > > > > All driver
> > > > > > > > > and
> > > > > > > > > > > > package versions are latest stable. When I
> > > > > > > > > > > > execute this script, my
> > > > > > > > > data
> > > > > > > > > >
> > > > > > > > > > > is
> > > > > > > > > > > > corrupted (funky chars, etc.), but differs each
time.
>
> > > > > > > > > > > > This leads me
> > > > > > > > > to
> > > > > > > > > > > > believe maybe I am using RLib wrong and it is
> > > > > > > > > > > > trying to display some resultset identifier or
> > > > > > > > > > > > something else
> > > > > > non-readable.
> > > > > > > > > > > > Attached are my
> > > > > > > > > > php
> > > > > > > > > > > > script and my xml. Am I doing everything right?
> > > > > > > > > > > > If so, is there a
> > > > > > > > > > > charset
> > > > > > > > > > > > option I can specify somewhere, or some other
> > > > > > > > > > > > option I can adjust to diagnose this corrupt
> > > > > > > > > > > > data
> problem?
> > > > > > > > > > > > Thanks for the help
> > > > > > > > RLibers.




Archive powered by MHonArc 2.6.24.

Top of Page