sqlIfConnection.h

Go to the documentation of this file.

/*******************************************************************************
** Copyright (c) 1992-2010 VT MAK
** All rights reserved.
*******************************************************************************/


#pragma once

#ifdef _WIN32
#include <windows.h>
#include <sqltypes.h>
#else
#include <sqltypes.h>
#endif

#include "sqlIfError.h"
#include "databaseConnection.h"

class DtDatabaseParameters;
class DtSqlEnvironment;


//
// class DtSqlIfConnection:
//
// To talk to a database, you need to create a connection to it. 
// DtSqlIfConnection is provided with an SQL environment handle, and creates
// a connection object.  Once the connection object is created, you can then
// connect to a database.  You can allocate a connection and environment 
// directly and provide them as arguments to a DtSqlIfDatabase constructor,
// but it's easier to let the database object create both of these for you.
//
class DT_DLL_VLDB DtSqlConnection : public DtDatabaseConnection
{
public:
   // Main constructor
   explicit DtSqlConnection( DtSqlEnvironment& environment);

   // Destructor
   virtual ~DtSqlConnection();

   virtual void setConnectionParameters(DtDatabaseParameters* params, bool useMaster );

   // Make a connection to a database using the connection object created
   // by this class at construction time
   virtual bool connect();
   virtual bool connectSansDSN();

   // Disconnect from the currently connected database
   virtual bool disconnect();

   // Accessors/Mutators
   // Return a handle to the connection object
   SQLHDBC handle();

   // Returns true if we are currently connected to a DB, false otherwise
   bool isConnected() const;

protected:

   SQLHDBC  myHandle;
   bool     myConnected;
   DtSqlIfErrorHandler myErrorHandler;
   DtDatabaseParameters* myParameters;
   bool myUseMaster;
};