From: Stefan Pantke
Date: March 17 1999 1:10am
Subject: Win32/VC 6.0 problem
List-Archive: http://lists.mysql.com/win32/14
Message-Id: <C1256737.00066CFF.00@cubic.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

I'm about to write an ISAPI DLL on NT 4.0 using VC++ 6.0.

Using various settings while opening the CDatabase/CRecordset objects,
I allways get error messages from thrown exceptions:

     - dynasets not supported
     - static-cursors required, if snapshop requested

I found no combination of parameters to use the ODBC
MFC classes to even read one record.

Question:

     Can I use MySQL using MFC and ODBC with VC++ 6.0?
     Is the MySQL ODBC driver thread-safe?

Thanks

Stefan


Here is a code sample:

*************************************************
          // simple call to CDatabase.Open failes -> KB Q181434
          lCompanyDB.OpenEx(_T("DSN=my2;UID=root;"),
CDatabase::noOdbcDialog);

          CGetCompany    lCompanyRS( &lCompanyDB );

          lCompanyRS.Open( CRecordset::dynaset, NULL );

          if ( ! lCompanyRS.IsBOF() )
          {
               while( ! lCompanyRS.IsEOF() )
               {
                    *pCtxt << _T( "<BR>" );
                    // *pCtxt << lCompanyRS.m_Name;
                    lCompanyRS.MoveNext();
               }
          }

          lCompanyRS.Close();


          lCompanyDB.Close();
*************************************************