SQLGetData not working with SQLFetchScroll when trying to fetch re

SQLGetData not working with SQLFetchScroll when trying to fetch re

Post by UGFrLU1pbm » Sat, 16 Aug 2008 12:04:01

I believe the design of SNAC driver should allow that. In other words, this
may be a bug in SNAC.
So, could you please give us a program to reproduce the problem?

MDAC Team, Microsoft.

1. SQLGetData not working with SQLFetchScroll when trying to fetch results from a storedproc

2. SQLGetData returning blank values every second fetch!??

I've compiled a test program that connects to the machine (local) DSN,
executes a single SQL select, fetches the first row, grabs all the
data from all columns using SQLGetData(), then disconnects etc.

The strange thing is that every second time I execute the program,
SQLGetData returns blank data for all fields. It's irrelevant what
query string I use - whether I keep it the same for every call, or
vary it every call.

In fact, the runs where it succeeds it returns 1
(SQL_SUCCESS_WITH_INFO), but on alternate runs it returns 0
(SQL_SUCCESS). More specfically the length of the string data it
returns is 1 byte (I believe just the null C-string terminator).

The final weird thing is that it only occurs one some tables - I have
one table that was created remoted through the Client Access ODBC
driver under Windows, and that one works fine every time. Tables that
are created directly on the AS/400 all seem to have this problem

Desperate for clues!


3. Outlook 2K will not fetch mail after the first try

4. Fetch Default not working

5. full text not working: Error fetching URL

6. Fetching Webpage Works in XP not in Vista?

7. tried and tried, but still not working


9. lwp::simple get (why it would stop working along with wget when fetch still works)

10. deleted items not going into recycle bin - tried various solutions from google still not working

11. out off office cmd is not available and tried help still not work

12. Error While Trying to Fetch a row

13. Trying to fetch general ledger account numbers from two different tables

14. Try Again - Fetch Params Crashes Delphi

15. Help: try to fetch another application's registry values