Using stored procedures with ADO

ActiveX Data Objects (ADO) enables you to write a client application to access and manipulate data in a database server through a provider.
ADO's primary benefits are ease of use, high speed, low memory overhead, and a small disk footprint.
This sample project is for ADODB, an implementation of ADO optimized for use with Microsoft OLE DB providers, including the Microsoft ODBC provider for OLE DB.
Using this we can execute stored procedure, pass arguments and retrieve value. To use this sample you will have to create the two stored procedures mentioned below.
For using this project you need MFC 5.0 OR above + ADO in your machine.

   CString strTmp;
   CString m_sdatasource; // Data source name
   CString m_sUserID;     // User Id
   CString m_sPassword;   // Password

   // GET the above values from the user 
   //Without creating Datasource we can use database by the following   code
   /* strTmp.Format( "driver={sql server};"
                           m_server,m_sdatabase,m_sUserID,m_sPassword );*/

   strTmp.Format( "dsn=%s;""UID=%s;""PWD=%s;",m_sdatasource,m_sUserID,m_sPassword );
   _bstr_t         bstrSQLServerConnect;
   _bstr_t bstrProc =( L"sp_StartByteImport" );; //Stored procedure name
   _variant_t Final;
   bstrSQLServerConnect = (LPCTSTR) strTmp;
   m_status="Empty File";
   _ConnectionPtr  Conn1; // connection object pointer
   _CommandPtr     Cmd1;  // command object pointer
   _RecordsetPtr   Rs1; // recordset object pointer
   bool            bvalid = false;
      Conn1.CreateInstance( __uuidof( Connection ) ); // Instantiating connection object
	  Conn1->ConnectionString = bstrSQLServerConnect; // giving the sqlconnection
	  Conn1->Open( bstrEmpty, bstrEmpty, bstrEmpty ); // open the connection object
	  Cmd1.CreateInstance( __uuidof( Command ) ); // creating command object
	  Cmd1->ActiveConnection = Conn1;             // giving the connection handle
	  Cmd1->CommandText      = _bstr_t( bstrProc ); // passing the stored procedue
	  Cmd1->CommandType      = adCmdStoredProc;     // type
	  Cmd1->Parameters->Refresh();                 // passing string value as argument to stored procedure
	  Cmd1->Parameters->Item[ _variant_t( (long) 1 ) ]->Value = _variant_t( (LPCTSTR)m_sfilename );
	  Rs1 = Cmd1->Execute( &vtEmpty, &vtEmpty2, adCmdUnknown ); // executing the stored procedure and storing the recordset value
	  bvalid = true;
	  Final  = Rs1->Fields->GetItem( _variant_t( 0L ) )->Value; // getting the first column value of the result row
	  strTmp.Format( "%s", CrackStrVariant( Final) ); // to see the value
	  // put your code to see all column values   
   catch( CException *e ) // trapping all error messages
	  TCHAR    szCause[255];    
      e->GetErrorMessage(szCause, 255);
   catch( _com_error &e )
	m_status=e.ErrorMessage( );
	m_status="Error while executing the Import";

    //we need to create the stored procedures below before running the application
	//CREATE PROCEDURE sp_AddAccountingInfo @nfinal int, @pcDate datetime,
	//@pcURL varchar (250), @pcTop varchar (250),
	//@pcQueryString varchar (250), @pcBytes int, @pcRequests int AS
		Do your operation here
	//CREATE PROCEDURE sp_AddAccountingInfo
	//@nfinal int,
	//@pcDate datetime,
	//@pcURL varchar (250),
	//@pcTop varchar (250),
	//@pcQueryString varchar (250),
	//@pcBytes int,
	//@pcRequests int
		Put your code here

Download demo project - [125 KB] KB


  • given a table name how to get the names of triggers and procedures associated with the table

    Posted by Legacy on 11/05/2003 12:00am

    Originally posted by: josh

    given a table name how to get the names of triggers and procedures associated with the table

  • how do in Oracle

    Posted by Legacy on 11/20/2002 12:00am

    Originally posted by: weijsh

    I have tried using your code with Oracle, and am having problems with things like specifying the input/output parameters.

    Has anyone had any success calling Oracle Stored procedures?


  • ADO - VC++ Calling Stored Procedures with Parameters

    Posted by Legacy on 11/07/2002 12:00am

    Originally posted by: Chuck Iyer

    Thanks Shellie, I will try with your example. Regards.


  • ADO - VC++ Calling Stored Procedures with Parameters

    Posted by Legacy on 11/05/2002 12:00am

    Originally posted by: Chuck Iyer

    Is there someone out there who has an example of a VC++ program which uses ADO to call a Stored Procedure with Parameters. I seem to have created the individual parameters and I think I have created the "PARAMETERS" by appending the individual paremeters. I have set the command type to adCmdStoredProcedure and the cmdText to the name of the Stored Procedure. Do I have to use the Execute command and if so what parameters do I pass it? Help would be appreciated. Thanks.

  • Can I create database in Visual C++?

    Posted by Legacy on 08/14/2002 12:00am

    Originally posted by: kong siang

    Can i create database in Visual C++? Do you have any idea how to do it? Can i create the database using the SQL statement or any classes?

  • Thanks

    Posted by Legacy on 07/29/2002 12:00am

    Originally posted by: Max

    I found it very helpful !!

  • Nice One

    Posted by Legacy on 07/18/2002 12:00am

    Originally posted by: Sujit Kumar Behera

    The code is extremely convinient...for devlopers like me,who are new to the world of MFC..

    Comments are also explained nicely...

    Thank U...

  • Calling Stored Procedures Using CT Libraries

    Posted by Legacy on 01/02/2002 12:00am

    Originally posted by: Venugopal

    Can anybody tell me how do I call a stored procedure using CT Libraries? I need to display the data returned by the Stored Procedure in a DBGrid Control.



  • ADO Recordset

    Posted by Legacy on 11/07/2001 12:00am

    Originally posted by: hemant

    I have a recorset, I want to convert the row column format in the recordset into column row format.
    Is this possible, if yes, How? Please explain in detail.

  • ImportDlg.cpp(644) : error C2660: 'Open' : function does not take 3 parameters

    Posted by Legacy on 11/02/2001 12:00am

    Originally posted by: abche1

    ImportDlg.cpp(644) : error C2660: 'Open' : function does not take 3 parameters

  • Loading, Please Wait ...

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • As the mobile enterprise marketplace expands and customer needs grow more diverse, Samsung recognizes that solution partners and developers play an essential role by continually innovating to meet their customers' needs. Samsung works to provide these developers and partners with the latest tools and resources needed to create these solutions. Read this program guide to learn how the Samsung Enterprise Alliance Program provides partners and developers with Samsung enterprise software development kits (SDKs) …

  • Moving from an on-premises environment to Office 365 does not remove the need to plan for disruptions or reduce the business risk requirements for protecting email services. If anything, some risks increase with a move to the cloud. Read how to ease the transition every business faces if considering or already migrating to cloud email. This white paper discusses: Setting expectations when migrating to Office 365 Understanding the implications of relying solely on Exchange Online security Necessary archiving …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date