Guest User

Untitled

a guest
Jul 22nd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. #include <stdio.h>
  2. //#include "stdafx.h"
  3. #include <windows.h>
  4.  
  5. #import "c:\Programme\Gemeinsame Dateien\System\ADO\msado15.dll" rename("EOF","adoEOF")
  6.  
  7.  
  8. //... Init Ole ...
  9.  
  10. struct InitOle {
  11. InitOle() { ::CoInitialize(NULL); }
  12. ~InitOle() { ::CoUninitialize(); }
  13. } _init_InitOle_;
  14.  
  15. void main()
  16. {
  17. HRESULT hr = S_OK;
  18.  
  19. try{
  20. // ADO-Recordset Component
  21. //---------------------------------------
  22. // either explicit call of CreateInstance
  23. // ADODB::_RecordsetPtr Rs1 = NULL;
  24. // hr = Rs1.CreateInstance( __uuidof( ADODB::Recordset ) );
  25. // or implicit via Constructor
  26. ADODB::_RecordsetPtr Rs1( __uuidof( ADODB::Recordset ));
  27.  
  28. _bstr_t Connect( "DSN=ora10g;UID=d4a15;PWD=d4a15;" );
  29. _bstr_t Source ( "SELECT * FROM personen" );
  30.  
  31.  
  32. // Open() liefert die Ergebnisreihen
  33. // und macht implizit ein Connect
  34.  
  35. Rs1->Open( Source, Connect,
  36. ADODB::adOpenForwardOnly,
  37. ADODB::adLockOptimistic,
  38. /*ADODB::adLockReadOnly,*/ -1 );
  39.  
  40. _variant_t vtFirstName;
  41.  
  42. if(!(Rs1->adoEOF && Rs1->BOF)) // falls Recordset leer
  43. {
  44. Rs1->MoveFirst();
  45. while(!(Rs1->GetadoEOF()))
  46. {
  47. vtFirstName = Rs1->Fields->GetItem((long)0)->GetValue();
  48. printf( "First name = '%s'\n",
  49. ((char*) ((_bstr_t) vtFirstName)) );
  50. Rs1->MoveNext();
  51. }
  52. }
  53.  
  54. Rs1->Close();
  55. Rs1 = NULL;
  56.  
  57.  
  58. getchar();
  59.  
  60. }catch (_com_error &e)
  61. {
  62. printf("Description = %s\n", (char*) e.Description());
  63. }
  64.  
  65. // ::MessageBox( NULL, "Success!", "", MB_OK );
  66. }
Add Comment
Please, Sign In to add comment