Excel user defined functions unlimited

//---------------------------------------------------------------------------
//  Excel Multivalue Formula Add-In
//  Copyright (C) <2005> <Herbert Danler>
//  Contact: danler@users.sourceforge.net
//  Project Home Page: http://excelmvf.sourceforge.net/
//
//  This program is free software; you can redistribute it and/or modify it under
//  the terms of the GNU General Public License as published by the Free Software
//  Foundation; either version 2 of the License, or (at your option) any
//  later version.
//
//  This program 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 General Public License for more details.
//
//  You should have received a copy of the GNU General Public License along with
//  this program; if not, write to the Free Software Foundation, Inc.,
//  59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
//---------------------------------------------------------------------------

/***********************************************************************
 * Module:  TSgADOConnection.cpp
 * Author:  Herbert Danler
 * Modified: Montag, 4. Oktober 2004 14:35:42
 * Purpose: Implementation of the class TSgADOConnection
 * Comment: Singleton class for unique ADO Database connection
 ***********************************************************************/

#include "TSgADOConnection.h"

TADOConnection* TSgADOConnection::_db_connection;

WideString TSgADOConnection::connectionString;

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::TSgADOConnection()
// Purpose:    Implementation of TSgADOConnection::TSgADOConnection()
// Return:     
////////////////////////////////////////////////////////////////////////

TSgADOConnection::TSgADOConnection()
{
}

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::TSgADOConnection(const TSgADOConnection& oldTSgADOConnection)
// Purpose:    Implementation of TSgADOConnection::TSgADOConnection()
// Parameters:
// - oldTSgADOConnection
// Return:     
////////////////////////////////////////////////////////////////////////

TSgADOConnection::TSgADOConnection(const TSgADOConnection& oldTSgADOConnection)
{
}

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::operator=(TSgADOConnection& tdbsession)
// Purpose:    Implementation of TSgADOConnection::operator=()
// Parameters:
// - tdbsession
// Return:     void
////////////////////////////////////////////////////////////////////////

void TSgADOConnection::operator=(TSgADOConnection& tdbsession)
{
   // TODO : implement
}

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::setConnectionString(WideString pConnectionString)
// Purpose:    Implementation of TSgADOConnection::setConnectionString()
// Comment:    example:
//             Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\develop\Experimente\Artikel Exel Multivalue Formula\orderManagement.mdb;Persist Security Info=False
// Parameters:
// - pConnectionString
// Return:     void
////////////////////////////////////////////////////////////////////////

void TSgADOConnection::setConnectionString(WideString pConnectionString)
{
   connectionString = pConnectionString;
}

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::getInstance()
// Purpose:    Implementation of TSgADOConnection::getInstance()
// Return:     TADOConnection*
////////////////////////////////////////////////////////////////////////

TADOConnection* TSgADOConnection::getInstance(void)
{
   if (_db_connection == 0){
     _db_connection = new TADOConnection(0);
     _db_connection->ConnectionString = connectionString;
     _db_connection->Connected = true;
   }
   return _db_connection;
}

////////////////////////////////////////////////////////////////////////
// Name:       TSgADOConnection::deleteInstance()
// Purpose:    Implementation of TSgADOConnection::deleteInstance()
// Return:     void
////////////////////////////////////////////////////////////////////////

void TSgADOConnection::deleteInstance(void)
{
   if (_db_connection != 0)
  	delete _db_connection;
}