RE: 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: 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