---

db.DbConnection_ODBC.h

/*----------------------------------------------------------------------------
  SWORD 2000 - Software With Objects for Rapid Development
  Copyright (C) 2003 Eric NICOLAS
  ----------------------------------------------------------------------------
  SWORD is free software; you can redistribute it and/or modify
  it under the terms of the GNU Lesser General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  SWORD is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU Lesser General Public License for more details.

  You should have received a copy of the GNU Lesser General Public License
  along with SWORD; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  --------------------------------------------------------------------------*/
#ifndef _SWORD_DB_DBCONNECTION_ODBC_
#define _SWORD_DB_DBCONNECTION_ODBC_

// This is available only if you have enabled the "db.odbc" feature
#ifdef HAVE_DB_ODBC

#include "sword/db.DbConnection.h"
#include <sql.h>
#include <sqlext.h>

#define SQLERROR(r) (r!=SQL_SUCCESS && r!=SQL_SUCCESS_WITH_INFO)

namespace sword {

  class SWORDDECL DbConnection_ODBC : public DbConnection {
    friend class DbConnection;
    friend class DbQuery_ODBC;

  public:
    virtual ~DbConnection_ODBC();

    // Implements DbConnection
    virtual void open(const std::string& parameters);
    virtual void close();
    virtual PDbQuery query();
    virtual void begin();
    virtual void commit();
    virtual void rollback();

  private:
    DbConnection_ODBC(const std::string& name);

    bool    active_;
    SQLHENV dbe_;
    SQLHDBC dbc_;

    void reportError_(const std::string& message, SQLSMALLINT handleType, SQLHANDLE handle);
    void autoCommit_(bool on);
  };

} // namespace sword

#endif // HAVE_DB_ODBC

#endif // _SWORD_DB_DBCONNECTION_ODBC_

---