RE: 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:bdoan-J0aWFLYJOWhWk0Htik3J/[email protected]]
> Sent: Wednesday, March 23, 2005 9:10 AM
> To: Derek Giromini
> Cc: '[email protected]'
> 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
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 
Bob Doan <bdoan-J0aWFLYJOWhWk0Htik3J/[email protected]>



-------------------------------------------------------
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click