Re: ODBC with Oracle8

For Oracle ODBC 8.0.5, you need to use Oracle 8.0.5 client patch 8.0.5.2.4 with ODBC patch 8.0.5.7 or 8.0.5.8. For ODBC 8.0.5.7, it is for ODBC administrator 3.50 or below. For 8.0.5.8, it is for ODBC administrator 3.51 or above.

You will find that the file size of 8.0.5.8 is must smaller than 8.0.5.7. It is because ODBC8.0.5.8 it use all Windows DLL files and 8.0.5.7 has it own Windows DLL files.

"Valera" <valera_at_innocent.com> wrote in message news:OxyVDCmk$GA.217_at_cppssbbsa05...
> Hi!
> May be this description from help will answer your question:
> The following functions in the Oracle7 32-bit ODBC driver do not meet the
> specifications in the Microsoft ODBC SDK Programmer's Reference:
>
> SQLMoreResults - Because Oracle7 does not support multiple result sets,
> more results are never available. It will always return
SQL_NO_DATA_FOUND.
>
> Garry Star wrote in message ...
> >I desperately need some help. I have a program that uses ODBC and works
on
> >Access, SQL Server, and Sybase 11. It doesn't work on Oracle 8. I am able
> to
> >open the table and describe columns, but when I fetch, I get SQL_NO_DATA.
> >There is definitely data in the table.
> >
> >Do I need to use a cursor? I have'nt needed one for the other DBs and
from
> >what I saw in the ODBC documentation, ODBC will create one for you.
> >
> >Does anyone have any other ideas?
> >
> >I've tried the Oracle 8.05 ODBC driver as well as the Merant 3.5 ODBC
> >Driver.
> >
> >Any help you could provide would be greatly appreciated.
> >
> >
> >Garry Star
> >garry_star_at_ads-associates.com
> >
> >
>
>
Received on Tue Mar 21 2000 - 20:21:58 CST