Solved

Accessing MS Access database through MS Visual C++ 6

Posted on 2000-03-08
3
259 Views
Last Modified: 2010-04-02
Hi,

I'm writing a program in C++ that will retrieve and store data from a MS Access database. Any pointer on how to set up the connectivity and retrieving and modifying the data ?
0
Comment
Question by:n_chai
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
Wyn earned 100 total points
ID: 2599338
You can use ODBC with sqlbase APIs
QUOTED:
class CDemoODBC
{
public:
CDemoODBC();
~CDemoODBC();

bool Init();

bool ConnectToDatabase( const char* dataSourceName, const char* databaseUser, const char* databasePassword );
void DisconnectFromDatabase();

bool Save( const char* paino, const char* halkaisija );

protected:
private:
CDemoODBC( const CDemoODBC& copyFrom );
CDemoODBC& operator=( const CDemoODBC& copyFrom );

void Close();

// data
public:
protected:
private:
HENV envHandle;
HDBC connHandle;
bool connectedODBC;
HSTMT statementHandle;
};



CDemoODBC::CDemoODBC()
: envHandle( SQL_NULL_HENV ),
connHandle( SQL_NULL_HDBC ),
connectedODBC( false ),
statementHandle( SQL_NULL_HSTMT )
{
}

CDemoODBC::~CDemoODBC()
{
DisconnectFromDatabase();

Close();
}

// -------------------------------------

bool CDemoODBC::Init()
{
if ( ::SQLAllocEnv( &envHandle ) == SQL_SUCCESS )
{
if ( ::SQLAllocConnect( envHandle, &connHandle ) == SQL_SUCCESS )
{
::SQLSetConnectOption( connHandle, SQL_LOGIN_TIMEOUT, 5 );

return true;
}
}

return false;
}

void CDemoODBC::Close()
{
if ( connHandle != SQL_NULL_HDBC )
{
::SQLFreeConnect( connHandle );
connHandle = SQL_NULL_HDBC;
}

if ( envHandle != SQL_NULL_HENV )
{
::SQLFreeEnv( envHandle );
envHandle = SQL_NULL_HENV;
}
}

bool CDemoODBC::ConnectToDatabase( const char* dataSourceName, const char* databaseUser, const char* databasePassword )
{
RETCODE rc = ::SQLConnect( connHandle,
(UCHAR*)dataSourceName, SQL_NTS,
(UCHAR*)databaseUser, SQL_NTS,
(UCHAR*)databasePassword, SQL_NTS );

if ( rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO )
{
connectedODBC = true;

if ( ::SQLAllocStmt( connHandle, &statementHandle ) == SQL_SUCCESS )
return true;
}

return false;
}

void CDemoODBC::DisconnectFromDatabase()
{
if ( statementHandle != SQL_NULL_HSTMT )
{
::SQLFreeStmt( statementHandle, SQL_DROP );
statementHandle = SQL_NULL_HSTMT;
}

if ( connectedODBC )
{
::SQLDisconnect( connHandle );
connectedODBC = false;
}
}

bool CDemoODBC::Save( const char* paino, const char* halkaisija )
{
SDWORD painoLen = SQL_NTS;
SDWORD halkaisijaLen = SQL_NTS;

if ( ::SQLPrepare( statementHandle,
(unsigned char*)"INSERT INTO Painojono " 
"(Pvmklo, Paino, Halkaisija) " 
"VALUES " 
"(GetDate(), ?, ?)", SQL_NTS ) == SQL_SUCCESS )
{
if ( ::SQLBindParameter( statementHandle, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_FLOAT, 0, 0, (char*)paino, 0, &painoLen ) == SQL_SUCCESS )
{
if ( ::SQLBindParameter( statementHandle, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_FLOAT, 0, 0, (char*)halkaisija, 0, &halkaisijaLen ) == SQL_SUCCESS )
{
if ( ::SQLExecute( statementHandle ) == SQL_SUCCESS )
{
if ( ::SQLTransact( envHandle, SQL_NULL_HSTMT, SQL_COMMIT ) == SQL_SUCCESS )
return true;
}
}
}
}

return false;
}

 
0
 
LVL 1

Expert Comment

by:carldean
ID: 2599680
If you only ever intend to connect to an Access database (i.e. you don't have any plans to move the data to Oracle or something similar at a later date) then you should use the Microsoft DAO classes.

However, if you are not able to use MFC then you will have to go along the ODBC route and use the ODBC API as described in Wyn's reply.
0
 
LVL 5

Expert Comment

by:Wyn
ID: 2600339
yup,carldean is right .
I think you ask here than MFC area thus I suggest this.But I'd suggest you use MFC class for efficency if you can do that.
Regards
W.Yinan
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
object modeling - load and save functions 5 62
returning a dereferenced pts in C++ 10 158
passing data from one form to another form in c++ 27 83
No module found pypyodbc, 3 33
Often, when implementing a feature, you won't know how certain events should be handled at the point where they occur and you'd rather defer to the user of your function or class. For example, a XML parser will extract a tag from the source code, wh…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question