Re: ODBC with Oracle8

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 Mon Mar 20 2000 - 05:36:10 CST