rlib-users

RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1

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

Bob--

Thanks for the tip on the function. Unfortunately, there is a disconnect
between the function signatures in the documentation and in the example code
provided in the package.

> What's a DSN?

Data Source Name.

> And what database are you going to use.  They all don't implement ODBC the
same

The project will join data in a local mysql database with a remote Oracle
database via EasySoft ODBC-ODBC Bridge.

As of this writing, I can generate HTML and PDF files based on a query that
is looking for data in a column through the ODBC connection, but the files
are only generating one row's worth of data when I should see around 250
rows. Has anyone else experienced this problem? Running code that uses the
Bridge API directly yields all of the rows while RLIB only gives me one.

I've also seen behavior where a connection to mysql ODBC using the ODBC-ODBC
Bridge yields more usable data, but the first three rows are gone while the
last four rows repeat the same data. Is there a race condition in both of
these instances?

Cheers,
--Derek

RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1

[Al A. <aa...@ge...>]

But will this address the problem with making rlib-odbc calls to a mysql
database?  This particular issue seems like a race condition, where the
mechanism to print the data is unable to grab the first three rows of the
result set.  But since it knows how many rows to output, the final three
rows of the result set are merely copies of the final row.



-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Wednesday, March 23, 2005 9:10 AM
To: Derek Giromini
Cc: 'rli...@li...'
Subject: RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1


Derek,

I think I know whats going on, someone reported this before but
disappeared while in the middle of debugging the problem.

Oracle does not implement SQLRowCount.  I think I can write the ODBC
connector w/ out this or perhaps you want to give it a shot
(rlib/inputs/odbc/odbc.c)

How's your c?

- bob

On Tue, 2005-03-22 at 15:29 -0600, Derek Giromini wrote:
> Bob--
> 
> Thanks for the tip on the function. Unfortunately, there is a disconnect
> between the function signatures in the documentation and in the example
code
> provided in the package.
> 
> > What's a DSN?
> 
> Data Source Name.
> 
> > And what database are you going to use.  They all don't implement ODBC
the
> same
> 
> The project will join data in a local mysql database with a remote Oracle
> database via EasySoft ODBC-ODBC Bridge.
> 
> As of this writing, I can generate HTML and PDF files based on a query
that
> is looking for data in a column through the ODBC connection, but the files
> are only generating one row's worth of data when I should see around 250
> rows. Has anyone else experienced this problem? Running code that uses the
> Bridge API directly yields all of the rows while RLIB only gives me one.



> 
> I've also seen behavior where a connection to mysql ODBC using the
ODBC-ODBC
> Bridge yields more usable data, but the first three rows are gone while
the
> last four rows repeat the same data. Is there a race condition in both of
> these instances?
> 
> Cheers,
> --Derek
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: 2005 Windows Mobile Application Contest
> Submit applications for Windows Mobile(tm)-based Pocket PCs or Smartphones
> for the chance to win $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bd...@si...>



-------------------------------------------------------
This SF.net email is sponsored by: 2005 Windows Mobile Application Contest
Submit applications for Windows Mobile(tm)-based Pocket PCs or Smartphones
for the chance to win $25,000 and application distribution. Enter today at
http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
_______________________________________________
Rlib-users mailing list
Rli...@li...
https://lists.sourceforge.net/lists/listinfo/rlib-users

RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1

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

Hym... A race condition there would be news to me.  Are we sure thats
what it is?  If we put a sleep in there after the query is executed does
it help?  I thought ODBC thread safe...

- bob

On Wed, 2005-03-23 at 12:51 -0600, Al Arzaga wrote:
> But will this address the problem with making rlib-odbc calls to a mysql
> database?  This particular issue seems like a race condition, where the
> mechanism to print the data is unable to grab the first three rows of the
> result set.  But since it knows how many rows to output, the final three
> rows of the result set are merely copies of the final row.
> 
> 
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Wednesday, March 23, 2005 9:10 AM
> To: Derek Giromini
> Cc: 'rli...@li...'
> Subject: RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1
> 
> 
> Derek,
> 
> I think I know whats going on, someone reported this before but
> disappeared while in the middle of debugging the problem.
> 
> Oracle does not implement SQLRowCount.  I think I can write the ODBC
> connector w/ out this or perhaps you want to give it a shot
> (rlib/inputs/odbc/odbc.c)
> 
> How's your c?
> 
> - bob
> 
> On Tue, 2005-03-22 at 15:29 -0600, Derek Giromini wrote:
> > Bob--
> > 
> > Thanks for the tip on the function. Unfortunately, there is a disconnect
> > between the function signatures in the documentation and in the example
> code
> > provided in the package.
> > 
> > > What's a DSN?
> > 
> > Data Source Name.
> > 
> > > And what database are you going to use.  They all don't implement ODBC
> the
> > same
> > 
> > The project will join data in a local mysql database with a remote Oracle
> > database via EasySoft ODBC-ODBC Bridge.
> > 
> > As of this writing, I can generate HTML and PDF files based on a query
> that
> > is looking for data in a column through the ODBC connection, but the files
> > are only generating one row's worth of data when I should see around 250
> > rows. Has anyone else experienced this problem? Running code that uses the
> > Bridge API directly yields all of the rows while RLIB only gives me one.
> 
> 
> 
> > 
> > I've also seen behavior where a connection to mysql ODBC using the
> ODBC-ODBC
> > Bridge yields more usable data, but the first three rows are gone while
> the
> > last four rows repeat the same data. Is there a race condition in both of
> > these instances?
> > 
> > Cheers,
> > --Derek
> > 
> > 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: 2005 Windows Mobile Application Contest
> > Submit applications for Windows Mobile(tm)-based Pocket PCs or Smartphones
> > for the chance to win $25,000 and application distribution. Enter today at
> > http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bd...@si...>

RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1

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

ok..

On Tue, 2005-03-29 at 19:11 -0600, Al Arzaga wrote:
> Will need to address this issue at another time.  We came upon some issues
> not related to rlib that is keeping us from trying to replicate the problem.
> 
> 
> 
> 
> -----Original Message-----
> From: Bob Doan [mailto:bd...@si...]
> Sent: Wednesday, March 23, 2005 2:18 PM
> To: Al Arzaga
> Cc: 'rli...@li...'
> Subject: RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1
> 
> 
> Hym... A race condition there would be news to me.  Are we sure thats
> what it is?  If we put a sleep in there after the query is executed does
> it help?  I thought ODBC thread safe...
> 
> - bob
> 
> On Wed, 2005-03-23 at 12:51 -0600, Al Arzaga wrote:
> > But will this address the problem with making rlib-odbc calls to a mysql
> > database?  This particular issue seems like a race condition, where the
> > mechanism to print the data is unable to grab the first three rows of the
> > result set.  But since it knows how many rows to output, the final three
> > rows of the result set are merely copies of the final row.
> > 
> > 
> > 
> > -----Original Message-----
> > From: Bob Doan [mailto:bd...@si...]
> > Sent: Wednesday, March 23, 2005 9:10 AM
> > To: Derek Giromini
> > Cc: 'rli...@li...'
> > Subject: RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1
> > 
> > 
> > Derek,
> > 
> > I think I know whats going on, someone reported this before but
> > disappeared while in the middle of debugging the problem.
> > 
> > Oracle does not implement SQLRowCount.  I think I can write the ODBC
> > connector w/ out this or perhaps you want to give it a shot
> > (rlib/inputs/odbc/odbc.c)
> > 
> > How's your c?
> > 
> > - bob
> > 
> > On Tue, 2005-03-22 at 15:29 -0600, Derek Giromini wrote:
> > > Bob--
> > > 
> > > Thanks for the tip on the function. Unfortunately, there is a disconnect
> > > between the function signatures in the documentation and in the example
> > code
> > > provided in the package.
> > > 
> > > > What's a DSN?
> > > 
> > > Data Source Name.
> > > 
> > > > And what database are you going to use.  They all don't implement ODBC
> > the
> > > same
> > > 
> > > The project will join data in a local mysql database with a remote
> Oracle
> > > database via EasySoft ODBC-ODBC Bridge.
> > > 
> > > As of this writing, I can generate HTML and PDF files based on a query
> > that
> > > is looking for data in a column through the ODBC connection, but the
> files
> > > are only generating one row's worth of data when I should see around 250
> > > rows. Has anyone else experienced this problem? Running code that uses
> the
> > > Bridge API directly yields all of the rows while RLIB only gives me one.
> > 
> > 
> > 
> > > 
> > > I've also seen behavior where a connection to mysql ODBC using the
> > ODBC-ODBC
> > > Bridge yields more usable data, but the first three rows are gone while
> > the
> > > last four rows repeat the same data. Is there a race condition in both
> of
> > > these instances?
> > > 
> > > Cheers,
> > > --Derek
> > > 
> > > 
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: 2005 Windows Mobile Application
> Contest
> > > Submit applications for Windows Mobile(tm)-based Pocket PCs or
> Smartphones
> > > for the chance to win $25,000 and application distribution. Enter today
> at
> > > http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bd...@si...>

RE: [Rlib-users] rlib_add_datasource_odbc arguments in 1.3.1

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

Derek,

I think I know whats going on, someone reported this before but
disappeared while in the middle of debugging the problem.

Oracle does not implement SQLRowCount.  I think I can write the ODBC
connector w/ out this or perhaps you want to give it a shot
(rlib/inputs/odbc/odbc.c)

How's your c?

- bob

On Tue, 2005-03-22 at 15:29 -0600, Derek Giromini wrote:
> Bob--
> 
> Thanks for the tip on the function. Unfortunately, there is a disconnect
> between the function signatures in the documentation and in the example code
> provided in the package.
> 
> > What's a DSN?
> 
> Data Source Name.
> 
> > And what database are you going to use.  They all don't implement ODBC the
> same
> 
> The project will join data in a local mysql database with a remote Oracle
> database via EasySoft ODBC-ODBC Bridge.
> 
> As of this writing, I can generate HTML and PDF files based on a query that
> is looking for data in a column through the ODBC connection, but the files
> are only generating one row's worth of data when I should see around 250
> rows. Has anyone else experienced this problem? Running code that uses the
> Bridge API directly yields all of the rows while RLIB only gives me one.



> 
> I've also seen behavior where a connection to mysql ODBC using the ODBC-ODBC
> Bridge yields more usable data, but the first three rows are gone while the
> last four rows repeat the same data. Is there a race condition in both of
> these instances?
> 
> Cheers,
> --Derek
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: 2005 Windows Mobile Application Contest
> Submit applications for Windows Mobile(tm)-based Pocket PCs or Smartphones
> for the chance to win $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bd...@si...>