I am running Oracle 11g2 32b in your area and I am hooking up into it in code. I personally use VC++ and fasten with OLE DB. The bond is working fine (finally) and that i can place data into my table without problem.

Where I actually do encounter problems, however, happens when fetching data. I've got a single table known as ITEM simply to test my stuff on. I personally use a CCommand. The command executes and my command really consists of data. Actually, it consists of the right quantity of posts and rows however, it does not appear to retain the correct data.

After I run this, I ought to get 7 rows designated 4 to 10, as i rather receive progressively growing and distant values between 83 000 000 and 168 000 000. After I try to get the column names I additionally get amounts rather than strings.

stringstream stream;
    string str;
    stream << "SELECT * FROM ITEM";
    str = stream.str();
    wstring commandText = s2ws(str);

    hr = cmd.Open(session, commandText.c_str());
        cout << "Select failed." << endl; 
        //Cropped for brevity, closes connection and returns -1
        cout << "Selection successful." << endl;
        hr = cmd.MoveFirst();
        int counter = 0;
        while(!FAILED(hr) && hr != DB_S_ENDOFROWSET){
            hr = cmd.MoveNext();
            cout << *(long*)(cmd.GetValue(1)) << endl;
        cout << "Number of entries : " << counter << endl;

When i first though it may be an information Type problem (my column's data key in Oracle is INTEGER), and so i attempted different kinds rather than "lengthy", but with no success.

Thanks ahead of time.

EDIT: I could retrieve a VARCHAR on another test table, however i am still battling with numerics.

EDIT: Further testing demonstrated that 4 different number DBTYPEs all read different crazy amounts.

EDIT: I could browse the amounts as strings and convert it well to int during my code. This really is completely absurd, however it works. I'd still prefer to know the right way to do it if a person figures something out, but for now, this will have to complete.