Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Connecting to an Access 2000 .mdb database with visual C++ ADO commands

  1. Oct 30, 2009 #1
    Hello all,

    I am trying to connect to an Access database, the Northwind sample database, by following this example,


    I am using a Windows XP OS with Visual C++ 2008 Express for the compiler and IDE. The program is a console application. This example is specified for Access 2007 .accdb file types and doesn't specify if a .mdb file type will cause errors.

    Once I get it running correctly I will switch the path name, queries, and table names to my database.

    The code compiles correctly, but fails to execute.

    Here is the code

    Code (Text):
    #include <fstream>
    #include <cmath>
    #include <complex>
    #include <iostream>
    #include <iomanip>
    #include <vector>
    #include <limits>
    #include <stdlib.h>
    #include <stdio.h>
    #include <time.h>
    #include <fcntl.h>
    #include <string.h>
    #include <ctype.h>
    #include <icrsint.h>

    using namespace std;

    #import <C:\\Program Files\\Common Files\\system\\ado\\msado15.dll> rename( "EOF", "AdoNSEOF")

    _bstr_t bstrConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb;";

    HRESULT hr;

    int main()
        const char* DAM = "ADO";
        ADODB::_ConnectionPtr pConn("ADODB.Connection");
        hr = pConn->Open(bstrConnect, "admin", "", ADODB::adConnectUnspecified);
            cout<<DAM<<": Successfully connected to database. Data source name:\n  "

            // Prepare SQL query
            _bstr_t query = "SELECT Customers.[Company], Customers.[First Name] FROM Customers;";
            cout <<DAM<<": SQL query \n  "<<query<<endl;

            // Execute
            ADODB::_RecordsetPtr pRS("ADODB.Recordset");
            hr = pRS->Open(query,
                _variant_t((IDispatch *) pConn, true),
                cout<<DAM<<": Retrieve schema info for the given result set: "<< endl;
                ADODB::Fields* pFields = NULL;
                hr = pRS->get_Fields(&pFields);
                if(SUCCEEDED(hr) && pFields && pFields->GetCount() > 0)
                    for(long nIndex=0; nIndex < pFields->GetCount(); nIndex++)
                        cout << " | "<<_bstr_t(pFields->GetItem(nIndex)->GetName());
                    cout << endl;
                    cout<<DAM<<": Error: Number of fields in the result is set to zero." << endl;
                cout<<DAM<<": Fetch the actual data: " << endl;
                int rowCount = 0;
                while (!pRS->AdoNSEOF)
                    for(long nIndex=0; nIndex < pFields->GetCount(); nIndex++)
                        cout<<" | "<<_bstr_t(pFields->GetItem(nIndex)->GetValue());
                    cout<< endl;
                cout<<DAM<<": Total Row Count:  " << rowCount << endl;
            cout<<DAM<<": Cleanup Done" << endl;
            cout<<DAM<<" : Unable to connect to data source: "<<bstrConnect<<endl;
        return 0;
    The error is with the hr statement. It has an unhandled exception.

    I don't know what is causing this.

    Any help would be appreciated.

  2. jcsd
  3. Oct 31, 2009 #2


    Staff: Mentor

    What's the exception that is thrown? That will give you a clue as to what the problem is.

    Do you know how to use the Visual Studio debugger? The value stored in hr after Open returns will give you an idea as to what's the problem.
  4. Oct 31, 2009 #3
    The exception that is thrown is;

    Unhandled exception at memory location ...

    The same error you would get if tried to access information outside the boundaries of an array.

    Yes, I know how to use the debugger. The value in the Open statement says IUknown in the location for the machine name. I have tried numerous names other than "admin" and still get the same error.

  5. Oct 31, 2009 #4
    Are you sure that:

    ADODB::_ConnectionPtr pConn("ADODB.Connection");

    Actually creates an ADODB::Connection object?

    I have just checked some of my code and it creates a connection like this:

    ADODB::_ConnectionPtr _DC;
    hr = _DC.CreateInstance( __uuidof(ADODB::Connection) );
    _DC->Open( _ConnectionString.c(), L"", L"", ADODB::adAsyncConnect );

    That is for connecting async to SQL server with the username and password in the connection string itself.
  6. Nov 2, 2009 #5

    Thanks. I had added your code but now I have a new error.

    The error is;

    :error C2660: 'ADODB::Connection15::Open' : function does not take 5 arguments

    So I am trying to pass too many arguments.

    Here is the code block where that occurs.

    Code (Text):
    ADODB::_RecordsetPtr pRS("ADODB.Recordset");
            hr = _DC->Open(query,
                _variant_t((IDispatch *) _DC, true),
    The adCmdText is the line that the debugger points to.

    If I change the _DC->Open line to _DC->Open(query,"admin","",ADODB::adOpenUnspecified"

    The code compiles but, I get this error

    Unhandled exception at 0x7c812afb in Database Connection 2.exe: Microsoft C++ exception: _com_error at memory location 0x0012fbcc..

    The debugger directs me to this snippet of code located in the msado15.tli file.

    Code (Text):
    inline HRESULT Connection15::Open ( _bstr_t ConnectionString, _bstr_t UserID, _bstr_t Password, long Options ) {
        HRESULT _hr = raw_Open(ConnectionString, UserID, Password, Options);
        if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
        return _hr;
    Any help would be greatly appreciated.

    Last edited: Nov 2, 2009
  7. Nov 2, 2009 #6
    I think you are confusing the Recordset open with the Connection open. The connection open opens the connection and once it is open you can open a recordset from it. Your original code was about right, you just didn't create an object.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook