Public Member Functions | List of all members
Proud::CAdoConnection Class Reference
Inheritance diagram for Proud::CAdoConnection:
Inheritance graph
[legend]

Public Member Functions

PROUD_API CAdoConnection (ADODB::_Connection *conn)
 
PROUD_API void OpenEx (const TCHAR *pszConnStr, const TCHAR *AppName)
 
void Open (const TCHAR *pszConnStr)
 
PROUD_API void OpenEx (const TCHAR *pszConnStr, const TCHAR *AppName, DbmsType Type)
 
void Open (const TCHAR *pszConnStr, DbmsType Type)
 
PROUD_API void Close ()
 
PROUD_API void Close_NoThrow ()
 
PROUD_API bool IsOpened ()
 
PROUD_API long Execute (const TCHAR *lpszSQL)
 
PROUD_API long Execute (CAdoRecordset &outputRecords, const TCHAR *lpszSQL)
 
void BeginTrans ()
 
void RollbackTrans ()
 
void CommitTrans ()
 

Additional Inherited Members

Detailed Description

DMBS link object of ADO Wrapper API

Member Function Documentation

void Proud::CAdoConnection::BeginTrans ( )
inline

DB transaction begins

PROUD_API void Proud::CAdoConnection::Close ( )

ADODB will be closed.

PROUD_API void Proud::CAdoConnection::Close_NoThrow ( )

ADODB will be closed.

  • throw will not occur.
void Proud::CAdoConnection::CommitTrans ( )
inline

DB transaction commit

PROUD_API long Proud::CAdoConnection::Execute ( const TCHAR *  lpszSQL)

Executes SQL syntax. Can use as printf(). SQL syntax

Returns
Number of records affected by stored procedure; 0 if no rows were affected or the statement failed; and -1 for SELECT statements
PROUD_API long Proud::CAdoConnection::Execute ( CAdoRecordset outputRecords,
const TCHAR *  lpszSQL 
)

Executes SQL syntax. The result gets stored at outputRecords.

Parameters
outRecordsetRecordset of results to get. SQL syntax
Returns
Number of records affected by stored procedure; 0 if no rows were affected or the statement failed; and -1 for SELECT statements
PROUD_API bool Proud::CAdoConnection::IsOpened ( )

Is ADO object connected to DB server?

Returns
true if it succeed to connect DB;false if it failed to connect DB
void Proud::CAdoConnection::Open ( const TCHAR *  pszConnStr)
inline

This method connects to DB. Refer to OpenEx guideline for more details.

Parameters
pszConnStrDB Connection String
void Proud::CAdoConnection::Open ( const TCHAR *  pszConnStr,
DbmsType  Type 
)
inline

This method connects to DB. Refer to OpenEx guideline for more details.

Parameters
pszConnStrDB Connection String
PROUD_API void Proud::CAdoConnection::OpenEx ( const TCHAR *  pszConnStr,
const TCHAR *  AppName 
)

This method connects to DB. It has a function that expanse ADODB.Connection.

Parameters
pszConnStrDBMS link string
  • It follows the rule of ADO DB connection string. Refer to http://www.connectionstrings.com/ for more details.
  • If Driver or Provider is not included, use sqloledb as provider. Below is an example.
    Data Source=.;Database=ProudDB-Test;Trusted_Connection=yes // use . instead of localhost. using localhost causes connection error in some computers.
    Data Source=.;Database=ProudDB-Test;user id=xxx;password=yyy
AppNameName being displayed on SQL Server Enterprise Manager. This method helps detecting dead-lock when adding a name that points to a specific routine to the name of connection. If you don't insert this method, this will be ignores.
PROUD_API void Proud::CAdoConnection::OpenEx ( const TCHAR *  pszConnStr,
const TCHAR *  AppName,
DbmsType  Type 
)

TODO:translate needed. This method connects to DB. It has a function that expans ADODB.Connection.

Parameters
pszConnStrDBMS link string
  • It follows the rule of ADO DB connection string. Refer to http://www.connectionstrings.com/ for more details. Below is one example.
    Data Source=.;Database=ProudDB-Test;Trusted_Connection=yes // .을 써야지, localhost를 쓰지 말 것. 일부 컴에서 연결 실패 오류로 이어짐.
    Data Source=.;Database=ProudDB-Test;user id=xxx;password=yyy
    //MySql
    Driver={MySQL ODBC 5.1 Driver};server=xxx.xxx.xxx.xxx;port=3306;Database=TableName;User ID=UserID;Password=yyy;
AppNameName being displayed on SQL Server Enterprise Manager. This method helps detecting dead-lock when adding a name that points to a specific routine to the name of connection. It ignores if you don't insert this method.
TypeThis inserts enum value of DbmsType such as for Sql,MySql and etc.(MsSql internally uses sqloledb Provider.)
void Proud::CAdoConnection::RollbackTrans ( )
inline

DB transaction rollback