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...>