A set of ADOX Classes

Download source files - 4 Kb

Overview
The CADOXCatalog Class
The CADOXTable Class
The CADOXIndex Class
The CADOXProcedure Class
The CADOXView Class
The CADOXUser Class

Overview

I created these classes to make it easy to work with ADOX. For this I created the CADOXCatalogclass, the CADOXTable class, the CADOXIndex class, the CADOXProcedure class and the CADOXUser class

The CADOXCatalog Class

CADOXCatalog::CADOXCatalog

Constructs a CADOXCatalog object

CADOXCatalog();

CADOXCatalog::Open

The Open function establishes connections to a database

bool Open(LPCTSTR lpstrConnection);

Parameters

LPCTSTR lpstrConnection: A string pointer containinig a Connection String.

If the function succeeds, this returns true.

For example:

CADOXCatalog pxcat;
CString strConnection = _T("");

strConnection = "Provider=Microsoft.JET.OLEDB.4.0;Data source = "
                "c:\\adox\\Test.mdb;Jet OLEDB:Engine Type=5;";

pxcat.Open(strConnection);

CADOXCatalog::CreateDatabase

bool CreateDatabase(LPCTSTR lpstrCreate);

Parameters

LPCTSTR lpstrCreate

If the function succeeds, this returns true.

For example:

CADOXCatalog pxcat;
CString strConnection = _T("");

strConnection = "Provider=Microsoft.JET.OLEDB.4.0;Data source = "
                "c:\\adox\\Test.mdb;Jet OLEDB:Engine Type=5;";

pxcat.CreateDatabase(strConnection);

CADOXCatalog::AddTable

The AddTable function adds a new table to the database.

bool AddTable(CADOXTable pTable);

Parameters

CADOXTable pTable: Pointer to the CADOXTable Object.

If the function succeeds, this returns true.

See sample

CADOXCatalog::AddUser

The AddUser function adds a new user to the database

bool AddUser(CADOXUser pUser, LPCTSTR lpstrPassword);

Parameters

CADOXUser pUser: A pointer to the CADOXUser Object.

LPCTSTR lpstrPassword A string pointer containing the user password.

If the function succeeds, this returns true.

CADOXCatalog::GetProcedureCount

The GetProcedureCount function returns the number of stored procedures defined for the database

long GetProcedureCount();

CADOXCatalog::GetTableCount

The GetTableCount function returns the number of tables defined for the database.

long GetTableCount();

CADOXCatalog::GetViewCount

The GetViewCount function returns the number of fields defined for the database.

long GetViewCount();

CADOXCatalog::GetUserCount

The GetUserCount function returns the number of users that exist in the database.

long GetUserCount();

CADOXCatalog::GetGroupCount

The GetGroupCount function returns the number of groups that exist in the database.

long GetGroupCount();

CADOXCatalog::GetTableName

The GetTableName function obtains the table name defined in the database.

void GetTableName(long nTableIndex, CString strTableName);

Parameters

long nTableIndex: The Table Index in the Database that is open by CADOXCatalog

CString strTableName: Pointer to a buffer in which to return the Table Name.

CADOXCatalog::GetProcedureName

The GetProcedureName function obtains the stored procedure name defined in the database.

void GetProcedureName(long nProcedureIndex, CString strProcedureName);

Parameters

long nProcedureIndex: The Procedure Index in the Database that is open by CADOXCatalog

CString strProcedureName: Pointer to a buffer in which to return the Procedure Name.

CADOXCatalog::GetViewName

The GetViewName function obtains the View name defined in the database.

void GetViewName(long nViewIndex, CString strViewName);

Parameters

long nViewIndex: The View Index in the Database that is open by CADOXCatalog

CString strViewName: Pointer to a buffer in which to return the View Name.

CADOXCatalog::GetUserName

The GetUserName function obtains the User name defined in the database.

void GetUserName(long nUserIndex, CString strUserName);

Parameters

long nUserIndex: The User Index in the Database that is open by CADOXCatalog

CString strUserName: Pointer to a buffer in which to return the User Name.

CADOXCatalog::GetGroupName>

The GetGroupName function obtains the Group name defined in the database.

void GetGroupName(long nGroupIndex, CString strGroupName);

Parameters

long nGroupIndex: The Group Index in the database that is open by CADOXCatalog

CString strGroupName: Pointer to a buffer in which to return the Group Name.

CADOXCatalog::DeleteTable

The DeleteTable function deletes the definition of a table in the database.

bool DeleteTable(long nTableIndex);
bool DeleteTable(LPCTSTR lpstrTableName);

Parameters

long nTableIndex: The Table Index in the database that is open by CADOXCatalog

LPCTSTR lpstrTableName: A string pointer containing the Table Name.

CADOXCatalog::DeleteProcedure

The DeleteProcedure function deletes the definition of a Stored Procedure in the database.

bool DeleteProcedure(long nProcedureIndex);
bool DeleteProcedure(LPCTSTR lpstrProcedureName);

Parameters

long nProcedureIndex: The Procedure Index in the Database that is open by CADOXCatalog

LPCTSTR lpstrProcedureName: A string pointer containing the Procedure Name.

CADOXCatalog::DeleteView

The DeleteView function deletes the definition of a View in the database.

bool DeleteView(long nViewIndex);
bool DeleteView(LPCTSTR lpstrViewName);

Parameters

long nViewIndex: The View Index in the database that is open by CADOXCatalog

LPCTSTR lpstrViewName: A string pointer containing the View Name.

CADOXCatalog::DeleteGroup

The DeleteGroup function deletes the definition of a Group in the database.

bool DeleteGroup(long nGroupIndex);
bool DeleteGroup(LPCTSTR lpstrGroupName);

Parameters

long nGroupIndex: The Group Index in the Database that is open by CADOXCatalog

LPCTSTR lpstrGroupName: A string pointer containing the Group Name.

CADOXCatalog::DeleteUser

The DeleteUser function deletes the definition of a User in the database.

bool DeleteUser(long nViewIndex);
bool DeleteUser(LPCTSTR lpstrUserName);

Parameters

long nViewIndex: The User Index in the database that is open by CADOXCatalog

LPCTSTR lpstrUserName: A string pointer containing the User Name.

The CADOXTable Class

CADOXTable::CADOXTable

Constructs a CADOXTable object

CADOXTable(CADOXCatalog* pCat);

Parameters

CADOXCatalog* pCat: Pointer to the CADOXCatalog Object.

CADOXTable::Create

The Create function creates a table, that can be added to the database using CADOXCatalog::AddTable.

bool Create(LPCTSTR lpstrTableName);

Parameters

LPCTSTR lpstrTableName: A string pointer containing the Table Name.

See sample

CADOXTable::Open

The Open function opens an existing table in the database.

bool Open(long nTableIndex);
bool Open(LPCTSTR lpstrTableName);

Parameters

long nTableIndex: The Table Index in the Database that is open by CADOXCatalog

LPCTSTR lpstrTableName: A string pointer containing the Table Name.

CADOXTable::AddField

The AddField function creates a field in the table.

bool AddField(LPCTSTR lpstrFieldName, enum DataType Type, int nLength = 0);

Parameters

LPCTSTR lpstrFieldName: A string pointer containing a Field Name.

enum DataType Type: A value indicating the data type of the field. The setting can be one of these values:

CADOXTable::typeSmallInt
CADOXTable::typeInteger
CADOXTable::typeUnsignedTinyInt
CADOXTable::typeUnsignedSmallInt
CADOXTable::typeUnsignedInt
CADOXTable::typeUnsignedBigInt
CADOXTable::typeSingle
CADOXTable::typeDouble
CADOXTable::typeCurrency
CADOXTable::typeDecimal
CADOXTable::typeNumeric
CADOXTable::typeBoolean
CADOXTable::typeDate
CADOXTable::typeDBDate
CADOXTable::typeDBTime
CADOXTable::typeDBTimeStamp
CADOXTable::typeBSTR
CADOXTable::typeVarChar
CADOXTable::typeLongVarChar
CADOXTable::typeWChar
CADOXTable::typeVarWChar
CADOXTable::typeLongVarWChar
CADOXTable::typeBinary
CADOXTable::typeVarBinary
CADOXTable::typeLongVarBinary
CADOXTable::typeChapter
CADOXTable::typeFileTime
CADOXTable::typePropVariant
CADOXTable::typeVarNumeric

int nLength = 0: A value that indicates the maximum size, in bytes, of a field. In any kind of fields nLength is ignored

See sample

CADOXTable::AddIndex

The AddIndex function creates an Index in the table.

bool AddIndex(CADOXIndex pIndex);

Parameters

CADOXIndex pIndex: Pointer to a CADOXIndex Object.

See sample

CADOXTable::DeleteField

The DeleteField function removes a field and make it inaccessible.

bool DeleteField(LPCTSTR lpstrFieldName);

Parameters

LPCTSTR lpstrFieldName: A string pointer containinig the Field Name.

CADOXTable::GetName

void GetName(CString &strTableName);

Parameters

CString &strTableName: Reference to a buffer in which to return the Table Name.

The CADOXIndex Class

CADOXIndex::CADOXIndex

Constructs a CADOXIndex object

CADOXIndex();

CADOXIndex::Create

bool Create(LPCTSTR lpstrIndexName);

Parameters

LPCTSTR lpstrIndexName: A string pointer containinig a Index Name.

See sample

CADOXIndex::AddField

The AddField function creates a field in the Index.

bool AddField(LPCTSTR lpstrIndexName, enum DataType Type, int nLength = 0);

Parameters

LPCTSTR lpstrIndexName: A string pointer containinig the Index Name.

enum DataType Type: A value indicating the data type of the field. The setting can be one of these values:

CADOXIndex::typeSmallInt
CADOXIndex::typeInteger
CADOXIndex::typeUnsignedTinyInt
CADOXIndex::typeUnsignedSmallInt
CADOXIndex::typeUnsignedInt
CADOXIndex::typeUnsignedBigInt
CADOXIndex::typeSingle
CADOXIndex::typeDouble
CADOXIndex::typeCurrency
CADOXIndex::typeDecimal
CADOXIndex::typeNumeric
CADOXIndex::typeBoolean
CADOXIndex::typeDate
CADOXIndex::typeDBDate
CADOXIndex::typeDBTime
CADOXIndex::typeDBTimeStamp
CADOXIndex::typeBSTR
CADOXIndex::typeVarChar
CADOXIndex::typeLongVarChar
CADOXIndex::typeWChar
CADOXIndex::typeVarWChar
CADOXIndex::typeLongVarWChar
CADOXIndex::typeBinary
CADOXIndex::typeVarBinary
CADOXIndex::typeLongVarBinary
CADOXIndex::typeChapter
CADOXIndex::typeFileTime
CADOXIndex::typePropVariant
CADOXIndex::typeVarNumeric

int nLength = 0: A value that indicates the maximum size, in bytes, of a field. In any kind of fields nLength is ignored

See sample

CADOXIndex::SetPrimaryKey

void SetPrimarKey(bool bPrimary = true);

Parameters

bool bPrimary = true

See sample

Sample 01:

CADOXTable pxTable(&pxcat);

pxTable.Create("Table4");
pxTable.AddField("Column1", CADOXTable::typeInteger, 0);
pxTable.AddField("Column2", CADOXTable::typeInteger, 0);
pxTable.AddField("Column3", CADOXTable::typeWChar, 25);
pxcat.AddTable(pxTable);

CADOXIndex pxInd;
pxInd.Create("Index1");
pxInd.AddField("Column1", CADOXIndex::typeInteger, 0);
pxInd.SetPrimarKey();
pxTable.AddIndex(pxInd);

The CADOXProcedure Class

CADOXProcedure::CADOXProcedure

Constructs a CADOXProcedure object

CADOXProcedure(CADOXCatalog* pCat);

Parameters

CADOXCatalog* pCat: Pointer to the CADOXCatalog Object.

CADOXProcedure::GetCommand

void GetCommand(CString strCommand);

Parameters

CString strCommand: Pointer to a buffer in which to return the Command String.

CADOXProcedure::GetName

void GetName(CString strName);

Parameters

CString strName: Pointer to a buffer in which to return the Procedure Name.

CADOXProcedure::Open

bool Open(LPCTSTR lpstrProcedureName);

Parameters

LPCTSTR lpstrProcedureName: A string pointer containinig the Procedure Name.

CADOXProcedure::Create

bool Create(CString strName, CString strCommand);

Parameters

CString strName: A string pointer containinig a Procedure Name.

CString strCommand: A string pointer containinig the Command String.

The CADOXView Class

CADOXView::CADOXView

Constructs a CADOXView object

CADOXView(CADOXCatalog* pCat);

Parameters

CADOXCatalog* pCat: Pointer to the CADOXCatalog Object.

CADOXView::GetCommand

void GetCommand(CString strCommand);

Parameters

CString strCommand: Pointer to a buffer in which to return the Command String.

CADOXView::GetName

void GetName(CString strName);

Parameters

CString strName: Pointer to a buffer in which to return the View Name.

CADOXView::Open

bool Open(LPCTSTR lpstrViewName);

Parameters

LPCTSTR lpstrViewName: A string pointer containinig the View Name.

CADOXView::Create

bool Create(CString strName, CString strCommand);

Parameters

CString strName: A string pointer containinig a View Name.

CString lpstrCommand: A string pointer containinig the Command String.

CString strCommand = _T("Select * From Table4");

xView.Create("View01", strCommand);

The CADOXUser Class

CADOXUser::CADOXUser

Constructs a CADOXUser object

CADOXUser(CADOXCatalog* pCat);

Parameters

CADOXCatalog* pCat: Pointer to the CADOXCatalog Object.

CADOXUser::GetName

void GetName(CString strName);

Parameters

CString strName: Pointer to a buffer in which to return the User Name

CADOXUser::Create

bool Create(LPCTSTR lpstrUserName);

Parameters

LPCTSTR lpstrUserName: A string pointer containinig a User Name.

CADOXUser::Open

bool Open(LPCTSTR lpstrUserName);

Parameters

LPCTSTR lpstrUserName: A string pointer containinig the User Name.

CADOXUser::ChangePassword

bool ChangePassword(LPCTSTR lpstrOldPassword, LPCTSTR lpstrNewPassword);

Parameters

LPCTSTR lpstrOldPassword: A string pointer containinig the Old Password.

LPCTSTR lpstrNewPassword: A string pointer containinig the New Password.

Remarks

Some functions do not work in all providers, for example CADOXCatalog::AddTable doesn't work in MS SQL Server.

Special thanks

Thank to all for your ideas, suggestions and colaboration.

Christian Graus
Mike Osbahr
Francis BONTHOUX

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Carlos Antollini

Architect
Citigroup

Argentina

Member

Carlos Antollini is a software engineer working on Object Oriented, Visual C++, MFC, COM, ATL, ADO, Internet technologies and Business Intelligence.
Carlos is originally from Argentina, he was living for several years in Fort Lauderdale, Florida, working for Citibank. Then he started his own business.
Carlos is the creator of piFive[^], a family of BI Analytic Platform software, that it deals next to, latinsys[^], his partner in businesses...
Currently he is sharing his passion for project management and BI at Citigroup.

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

You must Sign In to use this message board. (secure sign-in)

Search this forum
	Profile popups Noise Layout Per page

help me, about create database

Love In Snowing

19:20 15 Apr '09

how can create a mssql or mysql database? while I use CADOXCatalog::CreateDatabse, it always return the error, 'no such interface support'. How can solve the problem ?
Sign In·View Thread·Permalink	2.80/5 (3 votes)

About Add Primary and Foreign Key. (Add tow Fuction) [modified]

tangversion

7:38 23 Feb '09

bool CADOXTable::SetFieldAsPrimaryKey(LPCTSTR lpstrFieldName, enum KeyTypeEnum KeyType)
{
try
{
_KeyPtr m_pKey = NULL;
m_pKey.CreateInstance(__uuidof(Key));

m_pKey->PutName(lpstrFieldName);
m_pKey->PutType(KeyType);
m_pKey->Columns->Append(lpstrFieldName, adVarChar, 0);
m_pTable->Keys->Append(_variant_t((IDispatch *) m_pKey), KeyType, vtMissing, "", "");

m_pKey.Release();

return true;
}
catch(_com_error &e)
{
dump_com_error(e);
return false;
}

};

bool CADOXTable::SetFieldAsForeignKey(LPCTSTR lpstrForeignKeyName, LPCTSTR lpszRelatedTable, LPCTSTR lpszRelatedColumn)
{
try
{
_KeyPtr m_pKeyForeign = NULL;
m_pKeyForeign.CreateInstance(__uuidof(Key));

{
// Define the foreign key.
m_pKeyForeign->Name = lpstrForeignKeyName;
m_pKeyForeign->Type = adKeyForeign;
m_pKeyForeign->RelatedTable = lpszRelatedTable;
m_pKeyForeign->Columns->Append(lpszRelatedColumn,adVarWChar,0);
m_pKeyForeign->Columns->GetItem(lpszRelatedColumn)->RelatedColumn = lpszRelatedColumn;
m_pKeyForeign->UpdateRule = adRICascade;

// To pass as column parameter to Key's Apppend method
_variant_t vOptional;
vOptional.vt = VT_ERROR;
vOptional.scode = DISP_E_PARAMNOTFOUND;

// Append the foreign key.
m_pTable->Keys->Append(_variant_t((IDispatch *)m_pKeyForeign),adKeyPrimary,vOptional,L"",L"");

}
m_pKeyForeign.Release();

return true;
}
catch(_com_error &e)
{
dump_com_error(e);
return false;
}

};

My website: www.onegosoft.com

modified on Monday, February 23, 2009 1:48 PM

help me... create table from mysql

younghoyu

18:56 6 Aug '08

The table the error which creates occurs from mysql.
Solution method.

strConnection.Format(_T("Driver={MySQL ODBC 3.51 Driver};Server=localhost;
Database=temp;User=temp;Password=temp;Option=4;"));
pCat.Open(strConnection);

CADOXTable pxTable(&pCat);

pxTable.Create(TempTable);
pxTable.AddField("idx", CADOXTable::typeVarWChar, 25);
pxTable.AddField("userid", CADOXTable::typeVarWChar, 25);
pxTable.AddField("accidentcode", CADOXTable::typeVarWChar, 25);
pxTable.AddField("scode", CADOXTable::typeVarWChar, 25);
pCat.AddTable(pxTable); // error break

CADOXIndex pxInd;
pxInd.Create("Index1");
pxInd.AddField("idx", CADOXIndex::typeInteger, 0);
pxInd.SetPrimarKey();
pxTable.AddIndex(pxInd);

Re: help me... create table from mysql

ldaoust

6:55 16 Oct '09

Hello, did you find a solution for creating a table in MySQL with ADOX ? thanks. Louis. "Ambition without knowledge is like a boat on dry land" -Mr. Miyagi
Sign In·View Thread·Permalink

Re: help me... create table from mysql [modified]

Theo Buys

4:36 7 Jan '10

I don't know how to create a database for mysql but I found out that if you use CADOXCatalog() on the stack there can be problems. In my programs I use it on the heap with new. Here is an example which is working for ms-access (jet).

Try to convert it into mysql, see: ADO Connection Strings and mysql connector .

I hope this helps.

Theo

void CCreateDatabaseDlg::CreateDatabase()
{
	CADOXCatalog* pCatalog = NULL;
        pCatalog = new CADOXCatalog();
 
	CString strConnection;
	strConnection = 
		"Provider=Microsoft.JET.OLEDB.4.0;"
		"Data source = Tryout.mdb;Jet OLEDB:Engine Type=5;";
		
	if (!pCatalog->Open(strConnection))
	{
		if (pCatalog->;CreateDatabase(strConnection))
		{
			CADOXTable table(pCatalog);
			table.Create("takechecklist");
 
			// the types that an access database can handle:
			
			table.AddField("typeSmallInt", CADOXTable::typeSmallInt, 0);
			table.AddField("typeInteger", CADOXTable::typeInteger, 0);
			table.AddField("typeUnsignedTinyInt", CADOXTable::typeUnsignedTinyInt, 0);
			table.AddField("typeSingle", CADOXTable::typeSingle, 0);
			table.AddField("typeDouble", CADOXTable::typeDouble, 0);
			table.AddField("typeCurrency", CADOXTable::typeCurrency, 0);
			table.AddField("typeBoolean", CADOXTable::typeBoolean, 0);
			table.AddField("typeDate", CADOXTable::typeDate, 0);
			table.AddField("typeWChar", CADOXTable::typeWChar, 0);
			table.AddField("typeVarWChar", CADOXTable::typeVarWChar, 0);
			table.AddField("typeLongVarWChar", CADOXTable::typeLongVarWChar, 0);
			table.AddField("typeBinary", CADOXTable::typeBinary, 0); 
			table.AddField("typeVarBinary", CADOXTable::typeVarBinary, 0); 
			table.AddField("typeLongVarBinary", CADOXTable::typeLongVarBinary, 0);
			
			pCatalog->AddTable(table);
			
		}
	}
	
	delete pCatalog;
	
}

Help me, strange phenomenon

yh_pp

1:27 9 Aug '07

Hi,
My project use MFC SDI, and I open a dialog with DoModal(). Then the below fucntion is called in OnInitDialog() function. It seems everything is OK. But when I close this dialog, it can not be opened again, the DoModal() always return -1. When I wipe off ''ret = mCommDBX.AddTable(mCommDBTableLength);'', everything becomes normal.
What's the problem?
It's appreciated if you can give me some suggestion!
BOOL CDlgScaling::CreateNewEcuDb()
{
CString strConnection,strTmp;
CADOXCatalog mCommDBX;
int ret;

strConnection = "Provider=Microsoft.JET.OLEDB.4.0;Data source = ";
strConnection += VDT_DB_PATH;
strConnection += m_strNewEcuName;
strConnection += ".mdb";
strConnection +=";Jet OLEDB:Engine Type=5;";

if(!mCommDBX.CreateDatabase(strConnection))
{
AfxMessageBox("This ECU Type Exists Already!",MB_OK|MB_ICONINFORMATION);
return FALSE;
}

CADOXTable mCommDBTableLength(&mCommDBX);

//create length table
mCommDBTableLength.Create("Length");
mCommDBTableLength.AddField("ID",CADOXTable::typeInteger,0);
mCommDBTableLength.AddField("Snap_Length",CADOXTable::typeInteger,0);

CADOXIndex mCommDBTableInd1;
mCommDBTableInd1.Create("Index");
mCommDBTableInd1.AddField("ID", CADOXIndex::typeInteger, 0);
mCommDBTableInd1.SetPrimarKey();
mCommDBTableLength.AddIndex(mCommDBTableInd1);

ret = mCommDBX.AddTable(mCommDBTableLength);

return TRUE;
}

Re: Help me, strange phenomenon

Theo Buys

1:29 5 Sep '07

Maybe it helps if you do the creating of object on the heap by using the new and delete operators.
Sign In·View Thread·Permalink

Re: Help me, strange phenomenon

dzyssssss

17:13 29 Jun '08

Who can help me?How to create a sql server database use this classes?In my test, I can create a server database using a command line to Execute ,but this class cann't.How should I set the creating string? df
Sign In·View Thread·Permalink

How to join two tables in different databases

Theo Buys

1:20 7 Mar '07

ADOX lets you control a database's structure. In the first database, ADOX has to create a link to the table in the second database. Then I can perform a normal query joining the table and the link. But how the hack can I do this with this "A set of ADO classes" and "A set of ADOX classes" ? I use Microsoft Access databases.
Sign In·View Thread·Permalink	1.33/5 (3 votes)

80040154 Error when creating a database

BalouLeFou

5:43 18 Jan '07

Hi, When I want to create a database, I got an error : 80040154 Code meaning = "class not registered" Source = ADOX.Catalog I'm under windows XP. How can I fix it ?
Sign In·View Thread·Permalink	1.00/5 (2 votes)

This class create the sql server database have a bug?

blackgole

15:47 20 Dec '06

CADOXCatalog* l_pADOCata_ = new CADOXCatalog();
if( l_pADOCata_->adoxc_CreateDataBase( CADO_GetConnectionString( lpszConn ) ) )
{
CADOXTable l_tblContacts( l_pADOCata_ );
if( !l_tblContacts.adoxt_CreateTable( TEXT("MKLContacts") ) )
{
l_bSuccess = FALSE;
goto LeaveFun;
}

l_tblContacts.adoxt_AddField( TEXT("ContactID"), typeInteger, 0 );
l_tblContacts.adoxt_AddField( TEXT("ContactName"), typeVarWChar, 255 );
l_tblContacts.adoxt_AddField( TEXT("ContactMemo"), typeLongVarWChar, 0 );
l_tblContacts.adoxt_AddField( TEXT("ContactModifyDate"), typeDBTimeStamp, 0 );

if( !l_pADOCata_->adoxc_AddTable( l_tblContacts ) )
{
l_bSuccess = FALSE;
goto LeaveFun;
}

CADOXIndex l_idxID;
l_idxID.adoxi_CreateIndex( TEXT("ContactIDIndex") );
l_idxID.adoxi_AddField( TEXT("ContactID"), typeInteger );
l_idxID.adoxi_SetPrimaryKey();
if( !l_tblContacts.adoxt_AddIndex( l_idxID ) )
{
l_bSuccess = FALSE;
goto LeaveFun;
}

CADOXField l_fContactID( &l_tblContacts, TEXT("ContactID") );
// l_fContactID.adoxf_SetSeed();
l_fContactID.adoxf_SetAutoIncrement();
I don't know how to create the sqlserver2000 database.can you give me some example how to create the sqlserver database.The primarykey and index are not create.I don't know how to solve it.

Re: This class create the sql server database have a bug?

dzyssssss

17:18 29 Jun '08

Do you solve it? Can you share you way? dzyssssss
Sign In·View Thread·Permalink	2.00/5 (1 vote)

DLL problem [modified]

Mark84

21:28 19 Dec '06

I have the same problem with this classes like with ado2.

I get this 2 errors:
d:\Projekti\ArxMFCProject\Debug\msado15.tlh(1631): error C2059: syntax error : 'constant'

d:\Projekti\ArxMFCProject\Debug\msado15.tlh(1631): error C2238: unexpected token(s) preceding ';'

If can help, OnDblClick on error it opens msado15.tih and go to this line:
VARIANT_BOOL EOS;

Frown | :(

I inserted this classes. Comment //#include "afxdao.h" in stdafx.h. Added #include "stdafx.h" in AdoX.cpp. Set do not use precompiled header.

-- modified at 4:50 Wednesday 20th December, 2006

How can I find the columns in an Index

AlexEvans

18:10 11 Oct '06

Hello there Say I have a table with several INDEX tags, each with a name... Is there a way to find out which COLUMNS are taking part in each of these Indexes? Cheers Alex
Sign In·View Thread·Permalink

Who has a new version with ADOXField

NielsR

7:24 24 Aug '06

I have read in this forum ("How do use ADOX to set the column can contain a null value" 25 Mar '04) that it gives a new (unpublic) version of adox with new classes. Can anyone give me the new version per mail? Would be nice. e-mail: Niels.Reinboth@online.de thanks
Sign In·View Thread·Permalink

Re: Who has a new version with ADOXField

SupportElitron

20:23 14 May '07

I need the new version of ADOX. Can anyone give me the new version per mail? Would be nice. e-mail: software@elitron.com Thanks, Massimo.
Sign In·View Thread·Permalink

Unicode support modifications

holst_gustav

22:40 31 Jul '06

Hello Carlos Antollini, I've made some minimal, but several changes in your code for Unicode support. My intention was to attach here the modificated code, but there's no way to attach files to the messages. So if you want to send you this code, please tell me an e-mail to send the files. Thank you for your code
Sign In·View Thread·Permalink	2.00/5 (2 votes)

how i can implement passimistic lock

syed abbdul qavi

11:11 22 Feb '06

hi i have problem that when two or more application updating same record then error occure. so some one telling me to using passimistic lock for open record set so plz any body tell me how to implement passimistic lock in that ado2. thanx Syed Abdul Qavi
Sign In·View Thread·Permalink

Mar

MARARK

0:03 23 Jan '06

The function AddIndex doesn't work when the table's name has white spaces (the return error is DB_E_NOTABLE).
Sign In·View Thread·Permalink

Nice stuff but... ado2 and adox in a DLL ?

Mohamed Y. E.

5:25 28 Nov '05

First this is simply a great page to get a lot of info.. a big thanks to all contributors and a really special thanks to Carlos the boss Big Grin | :-D

.

But... I've been trying to add Ado2 and AdoX to an MFC DLL but I'm just keeping failing to get rid of the Theo Buys' like compiler errors :



Compiling...

StdAfx.cpp

h:\dllproject\debug\msadox.tli(246) : error C2511: 'Append' : overloaded member function 'long (const class _variant_t &,enum ADOX::DataTypeEnum,long)' not found in 'ADOX::Columns'

h:\dllproject\debug\msadox.tlh(350) : see declaration of 'Columns'

 

h:\dllproject\debug\msadox.tli(346) : error C2556: 'enum ADOX::DataTypeEnum __thiscall ADOX::_Column::GetType(void)' : overloaded function differs only by return type from 'enum DataTypeEnum __thiscall ADOX::_Column:

:GetType(void)'

h:\dllproject\debug\msadox.tlh(444) : see declaration of 'GetType'

 

h:\dllproject\debug\msadox.tli(346) : error C2371: 'GetType' : redefinition; different basic types

h:\dllproject\debug\msadox.tlh(444) : see declaration of 'GetType'

 

h:\dllproject\debug\msadox.tli(348) : error C2664: 'get_Type' : cannot convert parameter 1 from 'enum ADOX::DataTypeEnum *' to 'enum DataTypeEnum *'

        Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast

 

h:\dllproject\debug\msadox.tli(353) : error C2511: 'PutType' : overloaded member function 'void (enum ADOX::DataTypeEnum)' not found in 'ADOX::_Column'

h:\dllproject\debug\msadox.tlh(392) : see declaration of '_Column'

 

h:\dllproject\debug\msjro.tlh(48) : error C2011: 'ReplicaTypeEnum' : 'enum' type redefinition

Error executing cl.exe.

 

dllproject.dll - 6 error(s), 0 warning(s)

I've changed imports in both ado2.h and Adox.h to use the AdoImports.h as suggested by Theo (Message ADODB and ADOX - 6:41 28 Apr '05 ).

I even added in front of any ADODB or ADOX type the namespace it is linked to. Example: in ado2.h, I added ADODB:: in front of _ConnectionPtr in CAdoDatabase class declaration.

ADODB::_ConnectionPtr m_pConnection;

and same stuff to other types like _RecordsetPtr and _CommandPtr but it keeps poping the 6 errors. WTF | :WTF:

Do someone experience the same problems ?

Re: Nice stuff but... ado2 and adox in a DLL ?

Theo Buys

22:57 22 May '06

Disable the include of afxdao.h in the stdafx.h file! // #include // MFC DAO database classes
Sign In·View Thread·Permalink	2.00/5 (2 votes)

Not solved this problem!

y_yy2008

8:31 19 Jun '06

I meet the same problem in Dlls. The method of Disable #include "afxdao.h" does not work. following is my tries steps, hope someone can help to give solution:

1. I created a empty DLL in VC6 and then added following #import:

#pragma warning (disable: 4146)
#import "c:\Program Files\Common Files\system\ado\msadox.dll"
#import "c:\Program Files\Common Files\system\ado\msado15.dll" no_namespace rename("EOF", "EndOfFile")

2. Disabled "#include " in stdafx.h. Then go to compile WITHOUT any other more actions. But still following errors coming out (total 5 errors):

error C2511: 'Append' : overloaded member function 'long (const class _variant_t &,enum ADOX::DataTypeEnum,long)' not found in 'ADOX::Columns'
d:\cmailshare\debug\cmdatabase\msadox.tlh(350) : see declaration of 'Columns'

error C2556: 'enum ADOX::DataTypeEnum __thiscall ADOX::_Column::GetType(void)' : overloaded function differs only by return type from 'enum DataTypeEnum __thiscall ADOX::_Column::GetType(void)'
d:\cmailshare\debug\cmdatabase\msadox.tlh(444) : see declaration of 'GetType'

Re: Not solved this problem!

Deng Shi

23:44 11 Jun '07

这样试试： #import "C:\Program Files\Common Files\system\ado\msadox.dll" rename("EOF", "adoXEOF") rename("DataTypeEnum","adoXDataTypeEnum")
Sign In·View Thread·Permalink	1.00/5 (1 vote)