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