Oracle ODBC API on 8.00.0400 or 8.01.0700

[hhao]

I am writing in VC++ by Oracle ODBC API functions, such as SQLBindCol() or SQLFetchScroll();

When I fetch data from the 3 tables of an Oracle database by Oracle ODBC 8.00.0400, only the first 2 tables will succeed, the last one failed;

When I try it on a higher version of Oracle ODBC driver 8.01.0700, only the last one will succeed, the first 2 tables failed to give me any data, except the first one of each batch.

I am just puzzled by it. I need your help.

 

[Cagliostro]

Open one statement, free it, open the second, free it, and so go on. Do it one by one. In SQLServer for example, you can't fetch on a table if are open many than one. John Fill

ivfmd@mail.md