CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Norby mahoney

Page 1 of 3 1 2 3

Search: Search took 0.06 seconds.

  1. Re: ADO and Oracle- Trouble executing stored procedures

    thanks. The second link didn't work when I downloaded and ran the sample. I'm looking @ the second one ( I'm a VC++ guy, not VB, so will have to parse this one out ). Maybe it's the PL/SQL that is...
  2. Replies
    5
    Views
    1,052

    Re: copy one database info to another ?

    Never heard of this database; I did a Google search and found nothing either.
    Are you using ADO? If so, and their is an OLDEDB provider for this database, then have a look at ADOX.
    ...
  3. Replies
    1
    Views
    672

    Re: modifying database

    1.) To create a relationship between these two tables, try this:
    strSQL =
    "ALTER TABLE table2
    ADD CONSTRAINT FK_foreignkeyName
    FOREIGN KEY (table1_ID) REFERENCES
    table1(ID)
    *ON...
  4. Re: ADO and Oracle- Trouble executing stored procedures

    OK, let me ask this then:
    Has anyone every use ADO to retrieve data from an Oracle stored procedure?
  5. Replies
    2
    Views
    549

    Re: Database Searching...?

    If the user chooses to search for a records that have the work XYZ in the Descrip field, this would be your query:
    SELECT * FROM table WHERE table.Descrip LIKE '%XYZ%'

    This works in SQL...
  6. Replies
    2
    Views
    581

    Re: String Search

    Examples:
    SELECT * FROM family WHERE alpha_code >= 'B' AND alpha_code <= 'M'

    SELECT * FROM family WHERE
    (alpha_code >= 'A' AND alpha_code <= 'C' ) OR
    (alpha_code >= 'F' AND alpha_code <= 'I'...
  7. Replies
    5
    Views
    1,052

    Re: copy one database info to another ?

    Yea, you have 2 options ( that I can think of)
    1.) Source Database: Export the data in a form that can be imported into the Target Database.
    2.) Using a tool ( like Enterprise Manager for SQL...
  8. Replies
    0
    Views
    765

    ADOX not playing well with Oracle

    Specifically:
    1.) GetTables() -from a recordset generated by adSchemaTables


    ADODB::_RecordsetPtr rsTables = NULL;
    rsTables.CreateInstance( __uuidof( ADODB::Recordset ) );
    rsTables...
  9. Replies
    1
    Views
    823

    MS or Oracle OLEDB Provider?

    MS Provider:
    -No OS/NT Authentication
    -NO stored procedures support

    Oracle Provider:
    -Both User AND OS/NT Authentication
    -A bit faster
    -stored procedures support
    -Have to redistribute it...
  10. Replies
    7
    Views
    954

    Re: Need advice on VC++6.0

    I just wanted to get across to the original poster that:
    - Given that he seems to be looking to expand his skill set, it would seem that learning C#.NET would be a better use of his time than...
  11. Replies
    7
    Views
    954

    Re: Need advice on VC++6.0

    Hey, since 'popularity of the language' is a big driver for your desire to learn c++, I'd suggest saving your time and learning C#. .NET is about to to go through it's 3rd generation ( with 2005...
  12. Replies
    1
    Views
    865

    Re: reading database with ADOB

    Try this:

    COleVariant Var;
    Var = recordset->Fields->GetItem("FirstName")->Value;
    firstName = ( Var.vt == VT_NULL ? _T("") : ((char *) (_bstr_t)Var.bstrVal) );

    This above code definitely...
  13. ADO and Oracle- Trouble executing stored procedures

    I'm using ADO against an Oracle 10g database.

    2 problems:
    1.) calling the following stored procedures throws an exception on the last line in the code below (DB_E_ERRORSINCOMMAND; IDispatch...
  14. Replies
    1
    Views
    743

    MS OLEDB Provider for Oracle

    I've looked around and have only found connection string examples for this provider that use a 'User id' and 'Password'.

    My question: Is there a way to use this provider and connect using OS/NT...
  15. Re: ADO/Oracle- how do I avoid using a table's schema name

    Iteresting, I'm going to look into this now. Thanks for the tip.
  16. ADO/Oracle- how do I avoid using a table's schema name

    Using VC++ 6 with ADO.

    I'm new to Oracle, so this may be a setup issue. Currently I have to qualify a table name with it's schema name in order for even the simpliest of queries to work ( e.g....
  17. Re: XP in Workgroup- ADO won't connect to MSDE

    No, and I'm glad you asked. After further scrutiny, it looks like the problem was my single quotes around the user, pwd, etc.

    Now it works on both the local and 'remote' machine. Thanks for the...
  18. XP in Workgroup- ADO won't connect to MSDE

    With 2 XP-pro machines in a common workgroup, the following code fails:

    pDBConnection.CreateInstance( __uuidof( ADODB::Connection );

    CString sConnect;...
  19. Is my application causing cluster server crash?

    I have a windows cluster with 2 servers running Windows Server 2003. Initially, my client-server application was crashing so I was fixing bugs with my code. Now, periodically one the two cluster...
  20. Main App Window offset when Media Player running

    When my application starts up, it is set to display full screen and to be topmost (there's actually a splashscreen displayed fullscreen until the User logs in). This is an MFC MDI app.

    The...
  21. Replies
    2
    Views
    795

    Can't catch Access Violation!

    Ok,

    I've read through several threads on using SEH to catch exception that would normally not be caught by your standard try-catch blocks.

    Using a basic setup, I cannot catch an Access...
  22. Replies
    0
    Views
    665

    Can I reparent an ActiveX control?

    Is it possible to reparent an ActiveX control? I've tried calling SetParent(), but when it is time to access a method of this reparented ActiveX control, I receive:

    "ASSERT(m_pCtrlSite != NULL); ...
  23. question

    The resource I need to load is a dialog that needs to be loaded up at the time DLL1 is initially loaded. I think what I'm trying to do is not possible; I guess there is one resource handle shared...
  24. Call AfxSetResourceHandle in DLL without affecting main application's resources

    I have an MFC application. It loads a DLL (DLL1). DLL1 in turn loads DLL2. DLL2 is used by DLL1 for resources. The problem is when I load DLL2 in DLL1, and call AfxSetResourceHandle(), this...
  25. Replies
    1
    Views
    826

    Figured it out

    For anyone else that runs into this problem:
    I needed a message pump of some sort; being in a DLL I didn't have one. So create a CWinThread (UI type). From within the thread's Initinstance(),...
Results 1 to 25 of 62
Page 1 of 3 1 2 3





Click Here to Expand Forum to Full Width

Featured