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