#include <Windows.h>

#include <stdio.h>

#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \

no_namespace rename("EOF", "EndOfFile")

int main(int argc, char* argv[])

{

    HRESULT hr = S_OK;

    try

    {

        CoInitialize(NULL);

        // Define string variables.

        _bstr_t strCnn("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=??;Password=????????;Initial Catalog=????????;Data Source=???.???.???.???;");

        _RecordsetPtr pRstAuthors = NULL;

        // Call Create instance to instantiate the Record set

        hr = pRstAuthors.CreateInstance(__uuidof(Recordset));

        if (FAILED(hr))

        {

            printf("Failed creating record set instance\n");

            return ;

        }

        //Open the Record set for getting records from Author table

        pRstAuthors->Open("SELECT [ClubId], [ClubName] FROM Club.Clubs", strCnn, adOpenStatic, adLockReadOnly, adCmdText);

        //Declare a variable of type _bstr_t

        int valField1;

        _bstr_t valField2;

        pRstAuthors->MoveFirst();

        //Loop through the Record set

        if (!pRstAuthors->EndOfFile)

        {

            while (!pRstAuthors->EndOfFile)

            {

                valField1 = pRstAuthors->Fields->GetItem("ClubId")->Value.intVal;

                valField2 = pRstAuthors->Fields->GetItem("ClubName")->Value;

                printf("%d \t %s\n", valField1, (LPCSTR)valField2);

                pRstAuthors->MoveNext();

            }

        }

    }

    catch (_com_error & ce)

    {

        printf("Error:" + ce.Description() + "\n");

    }

    CoUninitialize();

    return ;

}