Q: ODBC Problem w. diff. ver

Q: ODBC Problem w. diff. ver

Post by Matthias Geini » Wed, 04 Jun 1997 04:00:00



Hi net-members,

I have a slight problem with Oracle ODBC and MS-VC 1.5 + MFC.

1.) I developed a program on a machine with Windows 3.11,
VC 1.5, Oracle ODBC 1.11.0.2 and SQL Net 1.19.0A. The
programm compilies and works fine.

2.) Now I try to test it on another machine also with Windows 3.11 +
VC 1.5 but Oracle 2.0.3.1.1.0 ODBC and SQL Net 2.3.3.0.0.
It complies without erros but it will hang when I try to read
all rows of a table. It goes in an endless loop. In a debugging
session it says after a while "System remains anstable ...".

It opens fine but when I do a MoveNext() there is nothing in
the row. But definatly there is something. The IsEOF() function
return that there is no EOF.

Here the necessary code with I can reproduce the problem:

        CDatabase DB;
        tpm* re;   // my CRecordSet Object
        re = new tpm(&DB);

        re->Open();                          
        if (re->IsOpen())
        {
                while (!re->IsEOF())  // everytime TRUE
                {
                        TRACE("MSGID: %s\n", re->m_MSGID);  // (**1**)
                        re->MoveNext();                
                }      
        }
        re->Close();
        delete re;

(**1**) At this point there should be something in m_MSGID but there
isn't. But EOF still says that end of file is not reached. So it
moves one record forward and so on ...

By the way Oracle ODBC test works fine (on both machines)!

Hope somebody has solve this problem before and can help me.
Thanks for every hint in advance.

By
Matthias

PS.: If you need some further information drop me a line I will
post it.

---------------------------------------------------------------------
  Matthias Geining                                 Quantum GmbH

  Emil-Figge-Strasse 83                      
D-44227 Dortmund                             tel: +49-(0)231-9749 185
  Germany                                    fax: +49-(0)231-9749 3
---------------------------------------------------------------------

Ich weiss nicht, mit welchen Waffen sich die Menschen im 3. Weltkrieg
bekaempfen, aber im 4. werden es Keulen sein.
                                                     Albert Einstein

 
 
 

1. Microsoft sql7.0-client on odbc ver 2.65 and ver 3.70

I've a client which is earlier run
ning odbc ver 2.65 and it's working
fine.Lately my progrmmer has changed
odbc ver to 3.7 and encouterd error
.Kindly assist me how to solve this
problem?Could it be the compatibilty
problem?My programmer requsted me
to download MADC latest ver.to support
windows98 client and server.Can it be
help.Kindly adv.....

2. adding strings?

3. Ver 5.03 client to Ver 7.11 server problem.

4. US-NC-Oracle Developer Year 2000-Aide Inc.

5. Printing Problem Ver 5 to Ver 7

6. 20279-NC-RALEIGH/DURHAM-ORACLE-PC-CICS-COBOL-LAN-VISBASIC-C/S Developer Business Analyst

7. ODBC ver. 3.7 and ADO 1.5 problem

8. Multi-Languages, web site globalization

9. Problem with Sqlserver ODBC driver ver 2000.80.528.0

10. Qs: VB4.0/OLE/ODBC

11. Visual Basic - ODBC - Informix OnLine Qs.?